DBA Data[Home] [Help]

APPS.WSH_OPSM_ASN_BE_PKG dependencies on WSH_OPSM_ASN_DELIVERY_REC

Line 38: v_delivery wsh_opsm_asn_delivery_rec;

34: IS
35: l_module_name CONSTANT VARCHAR2(100):= 'wsh.plsql.' || G_PKG_NAME || '.' || 'GET_ASN_DATA';
36: l_msg_data VARCHAR2(2000):=NULL;
37: l_debug_on BOOLEAN;
38: v_delivery wsh_opsm_asn_delivery_rec;
39: v_delivery_tab wsh_opsm_asn_delivery_tbl;
40: v_container wsh_opsm_asn_containers_rec;
41: v_container_tab wsh_opsm_asn_containers_tbl;
42: v_items wsh_opsm_asn_items_rec;

Line 882: v_delivery:= wsh_opsm_asn_delivery_rec( del_tab(l).transaction_date ,

878: NVL(del_tab(l).invoice_to_contact_id,-999) = NVL(v_cur_item.invoice_to_contact_id,-999) AND
879: NVL(del_tab(l).soldto_customer_id,-999) = NVL(v_cur_item.soldto_customer_id,-999) AND
880: NVL(del_tab(l).soldto_contact_id,-999) = NVL(v_cur_item.soldto_contact_id,-999) THEN
881: --To get delivery Information into the object type
882: v_delivery:= wsh_opsm_asn_delivery_rec( del_tab(l).transaction_date ,
883: del_tab(l).document_code ,
884: del_tab(l).organization_id ,
885: del_tab(l).delivery_id ,
886: del_tab(l).delivery_name ,

Line 1111: v_delivery wsh_opsm_asn_delivery_rec;

1107: IS
1108: l_module_name CONSTANT VARCHAR2(100):= 'wsh.plsql.' || G_PKG_NAME || '.' || 'GET_ASN_DATA';
1109: l_msg_data VARCHAR2(2000):=NULL;
1110: l_debug_on BOOLEAN;
1111: v_delivery wsh_opsm_asn_delivery_rec;
1112: v_delivery_tab wsh_opsm_asn_delivery_tbl;
1113: v_container wsh_opsm_asn_containers_rec;
1114: v_container_tab wsh_opsm_asn_containers_tbl;
1115: v_items wsh_opsm_asn_items_rec;

Line 1945: v_delivery:= wsh_opsm_asn_delivery_rec( del_tab(l).transaction_date ,

1941: NVL(del_tab(l).invoice_to_contact_id,-999) = NVL(v_cur_item.invoice_to_contact_id,-999) AND
1942: NVL(del_tab(l).soldto_customer_id,-999) = NVL(v_cur_item.soldto_customer_id,-999) AND
1943: NVL(del_tab(l).soldto_contact_id,-999) = NVL(v_cur_item.soldto_contact_id,-999) THEN
1944: --To get delivery Information into the object type
1945: v_delivery:= wsh_opsm_asn_delivery_rec( del_tab(l).transaction_date ,
1946: del_tab(l).document_code ,
1947: del_tab(l).organization_id ,
1948: del_tab(l).delivery_id ,
1949: del_tab(l).delivery_name ,