PO SO INV模块API 接口 DEBUG方式-Oracle EBS技术文档

日期作者版本变更说明2015-08-18Wenjing.chen1.0审阅姓名职位分发拷贝编号姓名位置/岗位备注：出于文档管理的目的，如果您收到了本文档的电子版本，请打印出来并在封面的相应位置写上您的名字出于文档管理的目的，如果您收到了本文档的纸介质版本，请在封面写上您的名字目录概述本文主要总结了PO/SO/INV模块的常用API和接口。本文档旨在对黄老师的深入浅出接口文档进行补充，只列举深入浅出里面没有的内容。PO模块PO模块的常见操作。补充了黄老师对PO总结，添加了取消PO和PO行的用法。以及添加新PO行到已有PO上面。可参考示例：取消POapps.po_document_control_pub.control_document(p_api_version=>1.0,--p_api_versionp_init_msg_list=>apps.fnd_api.g_true,--p_init_msg_listp_commit=>apps.fnd_api.g_true,--p_commitx_return_status=>l_return_status,--x_return_statusp_doc_type=>'PO',--p_doc_typep_doc_subtype=>'STANDARD',--p_doc_subtypep_doc_id=>rec_header.po_header_id,--p_doc_idp_doc_num=>NULL,--p_doc_nump_release_id=>NULL,--p_release_idp_release_num=>NULL,--p_release_nump_doc_line_id=>NULL,--p_doc_line_idp_doc_line_num=>NULL,--REC.LINE_NUM,--p_doc_line_nump_doc_line_loc_id=>NULL,--rec.Line_Location_Id,p_doc_shipment_num=>NULL,--p_doc_shipment_nump_action=>'CANCEL',--p_actionp_action_date=>SYSDATE,--p_action_datep_cancel_reason=>NULL,--p_cancel_reasonp_cancel_reqs_flag=>'N',--p_cancel_reqs_flagp_print_flag=>NULL,--p_print_flagp_note_to_vendor=>NULL,p_use_gldate=>NULL);COMMIT;IFl_return_status<>'S'THENretcode:='0';FORiIN1..apps.fnd_msg_pub.count_msgLOOPl_msg_data:=substrb(l_msg_data||apps.fnd_msg_pub.get(p_msg_index=>i,p_encoded=>'F'),0,2000);ENDLOOP;dbms_output.put_line('取消PO失败.'||l_msg_data);ENDIF;取消PO行apps.po_document_control_pub.control_document(p_api_version=>1.0,--p_api_versionp_init_msg_list=>apps.fnd_api.g_true,--p_init_msg_listp_commit=>apps.fnd_api.g_true,--p_commitx_return_status=>l_return_status,--x_return_statusp_doc_type=>'PO',--p_doc_typep_doc_subtype=>'STANDARD',--p_doc_subtypep_doc_id=>rec_header.po_header_id,--p_doc_idp_doc_num=>NULL,--p_doc_nump_release_id=>NULL,--p_release_idp_release_num=>NULL,--p_release_nump_doc_line_id=>rec_header.po_line_id,--p_doc_line_idp_doc_line_num=>NULL,--REC.LINE_NUM,--p_doc_line_nump_doc_line_loc_id=>NULL,--rec.Line_Location_Id,p_doc_shipment_num=>NULL,--p_doc_shipment_nump_action=>'CANCEL',--p_actionp_action_date=>SYSDATE,--p_action_datep_cancel_reason=>NULL,--p_cancel_reasonp_cancel_reqs_flag=>'N',--p_cancel_reqs_flagp_print_flag=>NULL,--p_print_flagp_note_to_vendor=>NULL,p_use_gldate=>NULL);COMMIT;IFl_return_status<>'S'THENretcode:='0';FORiIN1..apps.fnd_msg_pub.count_msgLOOPl_msg_data:=substrb(l_msg_data||apps.fnd_msg_pub.get(p_msg_index=>i,p_encoded=>'F'),0,2000);ENDLOOP;dbms_output.put_line('取消PO行失败.'||l_msg_data);ENDIF;添加新行到PO订单特别说明：如果调用po_docs_interface_cess_po_headers_interface创建的是一揽子协议，则要问清楚，这个一揽子是不是全局的。如果是全局的，则调用时，l_iface_rec.global_agreement_flag='Y'，函数参数x_ga_flag=‘Y’。DECLAREl_iface_recpo.po_headers_interface%ROWTYPE;l_iface_lines_recpo.po_lines_interface%ROWTYPE;l_iface_dis_recpo.po_distributions_interface%ROWTYPE;l_org_idNUMBER:=81;--OUIDl_user_idNUMBER:=0;--UserID?SysadminBEGINl_iface__id:=l_org_id;SELECTpo_headers_interface_s.nextvalINTOl_iface_erface_header_idFROMdual;l_iface_cess_code:='PENDING';l_iface_rec.action:='UPDATE';--此处和创建PO不同l_iface_rec.document_type_code:='STANDARD';l_iface_rec.document_subtype:=NULL;l_iface_rec.quote_warning_delay:=10;l_iface_rec.document_num:=NULL;l_iface_rec.approval_status:='APPROVED';l_iface_rec.agent_id:=2307;l_iface_rec.vendor_id:=33745;l_iface_rec.vendor_site_id:=14187;l_iface_erface_source_code:='TestOnly';l_iface_rec.batch_id:=987654321;l_iface_rec.currency_code:='CNY';--汇率处理(是否和本位币相同)IFl_iface_rec.currency_code<>g_local_currency_codeTHEN--是否使用用户汇率IFl_rate_type<>'USER'THENl_iface_headers.rate_date:=SYSDATE;l_iface_headers.rate_type:='Corporate';--汇率类型l_iface_headers.rate:=NULL;ELSEl_iface_headers.rate:=20;l_iface_headers.rate_date:=SYSDATE;l_iface_headers.rate_type:='User';ENDIF;ELSEl_iface_headers.rate_type:=NULL;l_iface_headers.rate:=NULL;l_iface_headers.rate_date:=NULL;ENDIF;INSERTINTOpo.po_headers_interfaceVALUESl_iface_rec;l_iface_lines_erface_header_id:=l_iface_erface_header_id;l_iface_lines_cess_code:='PENDING';l_iface_lines_rec.action:='ORIGINAL';l_iface_lines_rec.line_num:=1;l_iface_lines_rec.item_id:=1;l_iface_lines_mised_date:=SYSDATE;--Shipment1l_iface_lines_rec.shipment_num:=1;l_iface_lines_rec.quantity:=100;l_iface_lines_rec.unit_price:=2;SELECTpo_lines_interface_s.nextvalINTOl_iface_lines_erface_line_idFROMdual;INSERTINTOpo_lines_interfaceVALUESl_iface_lines_rec;l_iface_dis_erface_header_id:=l_iface_lines_erface_header_id;l_iface_dis_rec.distribution_num:=1;l_iface_dis_rec.quantity_delivered:=0;l_iface_dis_rec.quantity_billed:=0;l_iface_dis_rec.quantity_cancelled:=0;--MustBe0l_iface_dis_rec.charge_account_id:=NULL;l_iface_dis_erface_line_id:=l_iface_lines_erface_line_id;l_iface_dis_rec.quantity_ordered:=l_iface_lines_rec.quantity;SELECTpo.po_distributions_interface_s.nextvalINTOl_iface_dis_erface_distribution_idFROMdual;INSERTINTOpo.po_distributions_interfaceVALUESl_iface_dis_rec;--Shipment2l_iface_lines_rec.shipment_num:=2;l_iface_lines_rec.quantity:=200;l_iface_lines_rec.unit_price:=1;SELECTpo_lines_interface_s.nextvalINTOl_iface_lines_erface_line_idFROMdual;INSERTINTOpo_lines_interfaceVALUESl_iface_lines_rec;l_iface_dis_erface_line_id:=l_iface_lines_erface_line_id;l_iface_dis_rec.quantity_ordered:=l_iface_lines_rec.quantity;SELECTpo.po_distributions_interface_s.nextvalINTOl_iface_dis_erface_distribution_idFROMdual;INSERTINTOpo.po_distributions_interfaceVALUESl_iface_dis_rec;apps.fnd_global.apps_initialize(user_id=>l_user_id,resp_id=>52054,resp_appl_id=>201);po_docs_interface_cess_po_headers_interface(x_selected_batch_id=>l_iface_rec.batch_id,x_buyer_id=>NULL,x_document_type=>l_iface_rec.document_type_code,x_document_subtype=>l_iface_rec.document_subtype,x_create_items=>'N',x_create_sourcing_rules_flag=>NULL,x_rel_gen_method=>NULL,x_approved_status=>l_iface_rec.approval_status,x_commit_interval=>1,x_process_code=>'PENDING',x_interface_header_id=>NULL,x_org_id_param=>NULL,x_ga_flag=>NULL);END;PO模块Debug方法方法一：1、打开配置文件(英文环境)：RCV:ProcessingMode，用户层设置为：Batch2、打开配置文件(英文环境)：PO:EnableSqlTraceforReceivingProcessor，用户层设置为Yes(如果需要trace)3、打开配置文件(英文环境)：RCV:DebugMode=YES上面3个配置文件打开后，重新登录，一定要重新登录,使用标准的接收界面做接收时，会保留rcv_transactions_interface中的数据不清除，这个时候只需要在自己的程序上把提交请求的部分注释掉，只保留插入数据到接口表的部分即可。然后对比标准的数据和自己的数据的区别，这样可以快速定位自己程序中哪些字段输入有误。方法二：如果以上数据对比不能解决问题，可以尝试用标准的log日志去查找问题。4、打开配置文件(英文环境)：FND:DebugLogEnabled=Yes5、打开配置文件(英文环境)：FND:DebugLogLevel=Statement6、打开配置文件(英文环境)：FND:DebugLogModule=po%然后去查看请求日志信息。如一个接收事物处理请求报错，报错内容如下：loggingerrorderive_vendor_rcv_line_qty-098:1Cause:ASQLerrorhasoccurredinderive_vendor_rcv_line_qty.TheSQLerrorisUser-DefinedException.

Action:Takenoteofboththiserrornumberandtheactionsyouweretryingtoperform.Contactyoursystemadministratorforfurtherassistance.oncolumnINTERFACE_TRANSACTION_ID那么我们的关键信息就是：derive_vendor_rcv_line_qty-098:1有了上面的报错code，如何去使用请求日志，定位报错具体位置呢：步骤如下：我们看到：根据报错CODEderive_vendor_rcv_line_qty-098:1在RCV_ROI_TRANSACTION这个包的5094行出现了用户定义异常，code：098。有了报错信息，我们也不能盲目的从头看到尾，这不是我们推荐的调试方法。由于LOG太长，我们找到了报错节点，但是还得决定是往前找，还是往后找。由于报错是队列结构，而非堆栈，从最里层开始报错往外层抛异常，然后在最外层体现出来。那么最里层的报错信息肯定是往往是最先进队，压入日志队列数组中。外层的依次往数组后面插入。然后再按照数组顺序读出来。了解了LOG原理，我们知道，此时应该往回找，真正的报错节点在LOG前面。然后我们会发现第三步和第四步的内容，而第四步已经很详细指出了具体的报错包和行数。剩下的就是去具体位置查报错原因了。另外，我们在做PO接收时一个特别要注意的地方是：po.rcv_transactions_interface.use_mtl_lot:=1;--不启用批次时给1po.rcv_transactions_interface.use_mtl_serial:=1;--不启用序列时给1SO模块整理了SO模块里面深入浅出文档中没有的内容。主要是API的使用方式。以及特别需要注意的容易被思维定势误导的地方。API创建带BOM的SO（重要）重要说明：1、务必按照STANDARD/MODEL/OPTION这样的顺序来给l_line_tbl变量赋值，否则会报错，尤其是所有MODEL行一定要在所有OPTION前面。具体原因有兴趣的可以去翻一下源码。这里只提示和数组下标有关系。2、当同时导入2个BOM时，BOM头和BOM行是通过top_model_line_index和link_to_line_index这两个字段维护关联关系的。DECLAREl_header_price_att_tbloe_order_pub.header_price_att_tbl_type;l_header_adj_att_tbloe_order_pub.header_adj_att_tbl_type;l_header_adj_assoc_tbloe_order_pub.header_adj_assoc_tbl_type;l_line_price_att_tbloe_order_pub.line_price_att_tbl_type;l_line_adj_att_tbloe_order_pub.line_adj_att_tbl_type;l_line_adj_assoc_tbloe_order_pub.line_adj_assoc_tbl_type;l_hdr_recoe_order_pub.header_rec_type;l_line_recoe_order_pub.line_rec_type;l_line_adj_recoe_order_pub.line_adj_rec_type;l_line_tbloe_order_pub.line_tbl_type;l_line_adj_tbloe_order_pub.line_adj_tbl_type;l_x_header_recoe_order_pub.header_rec_type;l_x_header_adj_tbloe_order_pub.header_adj_tbl_type;l_x_header_scredit_tbloe_order_pub.header_scredit_tbl_type;l_x_line_tbloe_order_pub.line_tbl_type;l_x_line_adj_tbloe_order_pub.line_adj_tbl_type;l_x_line_scredit_tbloe_order_pub.line_scredit_tbl_type;l_action_request_tbloe_order_pub.request_tbl_type;l_x_action_request_tbloe_order_pub.request_tbl_type;l_x_lot_serial_tbloe_order_pub.lot_serial_tbl_type;l_return_statusVARCHAR2(30);l_file_valVARCHAR2(300);x_msg_countNUMBER;x_msg_dataVARCHAR2(2000);x_msg_indexNUMBER;vVARCHAR2(30);l_dateDATE;l_line_idNUMBER;--:=Enter_line_id;l_commentsVARCHAR2(40):='Testingupdatefunc';l_reason_codeVARCHAR2(30):='Notprovided';l_count_of_linesNUMBER:=0;BEGIN--mo_global.set_policy_context('S',204);fnd_global.apps_initialize(66184,61318,660);l_hdr_rec:=oe_order_pub.g_miss_header_rec;SELECToe_order_headers_s.nextvalINTOl_hdr_rec.header_idFROMdual;l_hdr_rec.transactional_curr_code:='USD';l_hdr_rec.pricing_date:=SYSDATE;l_hdr_rec.cust_po_number:='Test123';l_hdr_rec.sold_to_org_id:=1005;l_hdr_rec.price_list_id:=1000;l_hdr_rec.ordered_date:=SYSDATE;l_hdr_rec.shipping_method_code:='DHL';l_hdr_rec.sold_from_org_id:=204;l_hdr_rec.salesrep_id:=-3;l_hdr_rec.order_type_id:=1437;l_hdr_rec.operation:=oe_globals.g_opr_create;--第一个BOM头l_line_rec:=oe_order_pub.g_miss_line_rec;l_line_rec.ordered_quantity:=1;--Enter_Ordered_Quantity;l_line_rec.inventory_item_id:=7083176;--Enter_Inv_Item_id;l_line_rec.header_id:=l_hdr_rec.header_id;l_line_rec.order_quantity_uom:='PCS';l_line_rec.ordered_item_id:=7083176;l_line_rec.ship_from_org_id:=380;--Enter_warehouse_id;l_line_rec.price_list_id:=1403454;l_line_rec.item_identifier_type:='INT';l_line_rec.operation:=oe_globals.g_opr_create;l_line_rec.item_type_code:='MODEL';l_line_rec.top_model_line_index:=1;l_line_tbl(1):=l_line_rec;--第二个BOM头l_line_rec:=oe_order_pub.g_miss_line_rec;l_line_rec.ordered_quantity:=1;--Enter_Ordered_Quantity;l_line_rec.inventory_item_id:=7083176;--Enter_Inv_Item_id;l_line_rec.header_id:=l_hdr_rec.header_id;l_line_rec.order_quantity_uom:='PCS';l_line_rec.ordered_item_id:=7083176;l_line_rec.ship_from_org_id:=380;--Enter_warehouse_id;l_line_rec.price_list_id:=1403454;l_line_rec.item_identifier_type:='INT';l_line_rec.operation:=oe_globals.g_opr_create;l_line_rec.item_type_code:='MODEL';l_line_rec.top_model_line_index:=2;l_line_tbl(2):=l_line_rec;l_line_rec:=oe_order_pub.g_miss_line_rec;l_line_rec.ordered_quantity:=4;--Enter_Ordered_Quantity;l_line_rec.inventory_item_id:=5283494;--Enter_Inv_Item_id;l_line_rec.header_id:=l_hdr_rec.header_id;l_line_rec.order_quantity_uom:='个';l_line_rec.ordered_item_id:=5283494;l_line_rec.ship_from_org_id:=380;--Enter_warehouse_id;l_line_rec.price_list_id:=1403454;l_line_rec.item_identifier_type:='INT';l_line_rec.operation:=oe_globals.g_opr_create;l_line_rec.item_type_code:='OPTION';l_line_rec.top_model_line_index:=1;l_line_rec.link_to_line_index:=2;l_line_tbl(3):=l_line_rec;l_line_rec:=oe_order_pub.g_miss_line_rec;--l_line_rec.sold_to_org_id:=1006;l_line_rec.ordered_quantity:=8;--Enter_Ordered_Quantity;l_line_rec.inventory_item_id:=3327690;--Enter_Inv_Item_id;l_line_rec.header_id:=l_hdr_rec.header_id;l_line_rec.order_quantity_uom:='套';l_line_rec.ordered_item_id:=3327690;l_line_rec.ship_from_org_id:=380;--Enter_warehouse_id;l_line_rec.price_list_id:=1403454;l_line_rec.item_identifier_type:='INT';l_line_rec.operation:=oe_globals.g_opr_create;l_line_rec.item_type_code:='OPTION';l_line_rec.top_model_line_index:=1;l_line_rec.link_to_line_index:=3;l_line_tbl(4):=l_line_rec;l_line_rec:=oe_order_pub.g_miss_line_rec;l_line_rec.ordered_quantity:=8;--Enter_Ordered_Quantity;l_line_rec.inventory_item_id:=3272328;--Enter_Inv_Item_id;l_line_rec.header_id:=l_hdr_rec.header_id;l_line_rec.order_quantity_uom:='件';l_line_rec.ordered_item_id:=3272328;l_line_rec.ship_from_org_id:=380;--Enter_warehouse_id;l_line_rec.price_list_id:=1403454;l_line_rec.item_identifier_type:='INT';l_line_rec.operation:=oe_globals.g_opr_create;l_line_rec.item_type_code:='OPTION';l_line_rec.top_model_line_index:=1;l_line_rec.link_to_line_index:=1;l_line_tbl(5):=l_line_rec;l_line_rec:=oe_order_pub.g_miss_line_rec;l_line_rec.ordered_quantity:=8;--Enter_Ordered_Quantity;l_line_rec.inventory_item_id:=3272328;--Enter_Inv_Item_id;l_line_rec.header_id:=l_hdr_rec.header_id;l_line_rec.order_quantity_uom:='件';l_line_rec.ordered_item_id:=3272328;l_line_rec.ship_from_org_id:=380;--Enter_warehouse_id;l_line_rec.price_list_id:=1403454;l_line_rec.item_identifier_type:='INT';l_line_rec.operation:=oe_globals.g_opr_create;l_line_rec.item_type_code:='OPTION';l_line_rec.top_model_line_index:=2;l_line_rec.link_to_line_index:=1;l_line_tbl(6):=l_line_rec;l_line_rec:=oe_order_pub.g_miss_line_rec;l_line_rec.ordered_quantity:=4;--Enter_Ordered_Quantity;l_line_rec.inventory_item_id:=5283494;--Enter_Inv_Item_id;l_line_rec.header_id:=l_hdr_rec.header_id;l_line_rec.order_quantity_uom:='个';l_line_rec.ordered_item_id:=5283494;l_line_rec.ship_from_org_id:=380;--Enter_warehouse_id;l_line_rec.price_list_id:=1403454;l_line_rec.item_identifier_type:='INT';l_line_rec.operation:=oe_globals.g_opr_create;l_line_rec.item_type_code:='OPTION';l_line_rec.top_model_line_index:=2;l_line_rec.link_to_line_index:=2;l_line_tbl(7):=l_line_rec;l_line_rec:=oe_order_pub.g_miss_line_rec;l_line_rec.ordered_quantity:=8;--Enter_Ordered_Quantity;l_line_rec.inventory_item_id:=3327690;--Enter_Inv_Item_id;l_line_rec.header_id:=l_hdr_rec.header_id;l_line_rec.order_quantity_uom:='套';l_line_rec.ordered_item_id:=3327690;l_line_rec.ship_from_org_id:=380;--Enter_warehouse_id;l_line_rec.price_list_id:=1403454;l_line_rec.item_identifier_type:='INT';l_line_rec.operation:=oe_globals.g_opr_create;l_line_rec.item_type_code:='OPTION';l_line_rec.top_model_line_index:=2;l_line_rec.link_to_line_index:=3;l_line_tbl(8):=l_line_rec;l_action_request_tbl(1):=oe_order_pub.g_miss_request_rec;l_action_request_tbl(1).request_type:=oe_globals.g_book_order;l_action_request_tbl(1).entity_code:=oe_globals.g_entity_header;l_action_request_tbl(1).entity_id:=l_header_rec.header_id;--登记此订单oe_order_cess_order(p_api_version_number=>1.0,p_init_msg_list=>fnd_api.g_true,x_return_status=>l_return_status,x_msg_count=>x_msg_count,x_msg_data=>x_msg_data,p_x_header_rec=>l_hdr_rec,p_x_line_tbl=>l_line_tbl,p_x_action_request_tbl=>l_action_request_tbl,p_x_header_adj_tbl=>l_x_header_adj_tbl,p_x_header_scredit_tbl=>l_x_header_scredit_tbl,p_x_line_adj_tbl=>l_x_line_adj_tbl,p_x_line_scredit_tbl=>l_x_line_scredit_tbl,p_x_lot_serial_tbl=>l_x_lot_serial_tbl,p_x_header_price_att_tbl=>l_header_price_att_tbl,p_x_header_adj_att_tbl=>l_header_adj_att_tbl,p_x_header_adj_assoc_tbl=>l_header_adj_assoc_tbl,p_x_line_price_att_tbl=>l_line_price_att_tbl,p_x_line_adj_att_tbl=>l_line_adj_att_tbl,p_x_line_adj_assoc_tbl=>l_line_adj_assoc_tbl);IFx_msg_count>0THENFORiIN1..x_msg_countLOOPx_msg_data:=oe_msg_pub.get(p_msg_index=>i,p_encoded=>'F');dbms_output.put_line('spothula:MESSAGE:'||substrb(x_msg_data,1,200));ENDLOOP;ENDIF;COMMIT;END;API创建标准物料SODECLAREl_header_recoe_order_pub.header_rec_type;l_line_tbloe_order_pub.line_tbl_type;l_action_request_tbloe_order_pub.request_tbl_type;l_header_adj_tbloe_order_pub.header_adj_tbl_type;l_line_adj_tbloe_order_pub.line_adj_tbl_type;l_header_scr_tbloe_order_pub.header_scredit_tbl_type;l_line_scredit_tbloe_order_pub.line_scredit_tbl_type;l_request_recoe_order_pub.request_rec_type;l_return_statusVARCHAR2(1000);l_msg_countNUMBER;l_msg_dataVARCHAR2(1000);p_api_version_numberNUMBER:=1.0;p_init_msg_listVARCHAR2(10):=fnd_api.g_false;p_return_valuesVARCHAR2(10):=fnd_api.g_false;p_action_commitVARCHAR2(10):=fnd_api.g_false;x_return_statusVARCHAR2(1);x_msg_countNUMBER;x_msg_dataVARCHAR2(100);p_header_recoe_order_pub.header_rec_type:=oe_order_pub.g_miss_header_rec;p_old_header_recoe_order_pub.header_rec_type:=oe_order_pub.g_miss_header_rec;p_header_val_recoe_order_pub.header_val_rec_type:=oe_order_pub.g_miss_header_val_rec;p_old_header_val_recoe_order_pub.header_val_rec_type:=oe_order_pub.g_miss_header_val_rec;p_header_adj_tbloe_order_pub.header_adj_tbl_type:=oe_order_pub.g_miss_header_adj_tbl;p_old_header_adj_tbloe_order_pub.header_adj_tbl_type:=oe_order_pub.g_miss_header_adj_tbl;p_header_adj_val_tbloe_order_pub.header_adj_val_tbl_type:=oe_order_pub.g_miss_header_adj_val_tbl;p_old_header_adj_val_tbloe_order_pub.header_adj_val_tbl_type:=oe_order_pub.g_miss_header_adj_val_tbl;p_header_price_att_tbloe_order_pub.header_price_att_tbl_type:=oe_order_pub.g_miss_header_price_att_tbl;p_old_header_price_att_tbloe_order_pub.header_price_att_tbl_type:=oe_order_pub.g_miss_header_price_att_tbl;p_header_adj_att_tbloe_order_pub.header_adj_att_tbl_type:=oe_order_pub.g_miss_header_adj_att_tbl;p_old_header_adj_att_tbloe_order_pub.header_adj_att_tbl_type:=oe_order_pub.g_miss_header_adj_att_tbl;p_header_adj_assoc_tbloe_order_pub.header_adj_assoc_tbl_type:=oe_order_pub.g_miss_header_adj_assoc_tbl;p_old_header_adj_assoc_tbloe_order_pub.header_adj_assoc_tbl_type:=oe_order_pub.g_miss_header_adj_assoc_tbl;p_header_scredit_tbloe_order_pub.header_scredit_tbl_type:=oe_order_pub.g_miss_header_scredit_tbl;p_old_header_scredit_tbloe_order_pub.header_scredit_tbl_type:=oe_order_pub.g_miss_header_scredit_tbl;p_header_scredit_val_tbloe_order_pub.header_scredit_val_tbl_type:=oe_order_pub.g_miss_header_scredit_val_tbl;p_old_header_scredit_val_tbloe_order_pub.header_scredit_val_tbl_type:=oe_order_pub.g_miss_header_scredit_val_tbl;p_line_tbloe_order_pub.line_tbl_type:=oe_order_pub.g_miss_line_tbl;p_old_line_tbloe_order_pub.line_tbl_type:=oe_order_pub.g_miss_line_tbl;p_line_val_tbloe_order_pub.line_val_tbl_type:=oe_order_pub.g_miss_line_val_tbl;p_old_line_val_tbloe_order_pub.line_val_tbl_type:=oe_order_pub.g_miss_line_val_tbl;p_line_adj_tbloe_order_pub.line_adj_tbl_type:=oe_order_pub.g_miss_line_adj_tbl;p_old_line_adj_tbloe_order_pub.line_adj_tbl_type:=oe_order_pub.g_miss_line_adj_tbl;p_line_adj_val_tbloe_order_pub.line_adj_val_tbl_type:=oe_order_pub.g_miss_line_adj_val_tbl;p_old_line_adj_val_tbloe_order_pub.line_adj_val_tbl_type:=oe_order_pub.g_miss_line_adj_val_tbl;p_line_price_att_tbloe_order_pub.line_price_att_tbl_type:=oe_order_pub.g_miss_line_price_att_tbl;p_old_line_price_att_tbloe_order_pub.line_price_att_tbl_type:=oe_order_pub.g_miss_line_price_att_tbl;p_line_adj_att_tbloe_order_pub.line_adj_att_tbl_type:=oe_order_pub.g_miss_line_adj_att_tbl;p_old_line_adj_att_tbloe_order_pub.line_adj_att_tbl_type:=oe_order_pub.g_miss_line_adj_att_tbl;p_line_adj_assoc_tbloe_order_pub.line_adj_assoc_tbl_type:=oe_order_pub.g_miss_line_adj_assoc_tbl;p_old_line_adj_assoc_tbloe_order_pub.line_adj_assoc_tbl_type:=oe_order_pub.g_miss_line_adj_assoc_tbl;p_line_scredit_tbloe_order_pub.line_scredit_tbl_type:=oe_order_pub.g_miss_line_scredit_tbl;p_old_line_scredit_tbloe_order_pub.line_scredit_tbl_type:=oe_order_pub.g_miss_line_scredit_tbl;p_line_scredit_val_tbloe_order_pub.line_scredit_val_tbl_type:=oe_order_pub.g_miss_line_scredit_val_tbl;p_old_line_scredit_val_tbloe_order_pub.line_scredit_val_tbl_type:=oe_order_pub.g_miss_line_scredit_val_tbl;p_lot_serial_tbloe_order_pub.lot_serial_tbl_type:=oe_order_pub.g_miss_lot_serial_tbl;p_old_lot_serial_tbloe_order_pub.lot_serial_tbl_type:=oe_order_pub.g_miss_lot_serial_tbl;p_lot_serial_val_tbloe_order_pub.lot_serial_val_tbl_type:=oe_order_pub.g_miss_lot_serial_val_tbl;p_old_lot_serial_val_tbloe_order_pub.lot_serial_val_tbl_type:=oe_order_pub.g_miss_lot_serial_val_tbl;p_action_request_tbloe_order_pub.request_tbl_type:=oe_order_pub.g_miss_request_tbl;x_header_val_recoe_order_pub.header_val_rec_type;x_header_adj_tbloe_order_pub.header_adj_tbl_type;x_header_adj_val_tbloe_order_pub.header_adj_val_tbl_type;x_header_price_att_tbloe_order_pub.header_price_att_tbl_type;x_header_adj_att_tbloe_order_pub.header_adj_att_tbl_type;x_header_adj_assoc_tbloe_order_pub.header_adj_assoc_tbl_type;x_header_scredit_tbloe_order_pub.header_scredit_tbl_type;x_header_scredit_val_tbloe_order_pub.header_scredit_val_tbl_type;x_line_val_tbloe_order_pub.line_val_tbl_type;x_line_adj_tbloe_order_pub.line_adj_tbl_type;