DBA Data[Home] [Help]

APPS.WSH_OPSM_ASN_BE_PKG dependencies on WSH_OPSM_ASN_CONTAINERS_REC

Line 40: v_container wsh_opsm_asn_containers_rec;

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;
43: v_items_tab wsh_opsm_asn_items_tbl;
44: v_itemdetails wsh_opsm_asn_itemdetails_rec;

Line 772: v_container:=wsh_opsm_asn_containers_rec( v_cur_parent_container.container_instance_id ,

768: ||'.'||TO_CHAR(v_cur_item.invoice_to_org_id)
769: ||'.'||TO_CHAR(v_cur_item.invoice_to_contact_id)
770: ||'.'||TO_CHAR(v_cur_item.soldto_customer_id)
771: ||'.'||TO_CHAR(v_cur_item.soldto_contact_id)) ;
772: v_container:=wsh_opsm_asn_containers_rec( v_cur_parent_container.container_instance_id ,
773: v_cur_parent_container.lpn ,
774: v_cur_parent_container.container_item_id ,
775: v_cur_parent_container.master_serial_number ,
776: v_cur_parent_container.container_serial_number ,

Line 820: v_container:=wsh_opsm_asn_containers_rec( v_cur_container.container_instance_id ,

816: END IF;
817: END LOOP;
818: v_container_level:='CHILD';
819: END IF;
820: v_container:=wsh_opsm_asn_containers_rec( v_cur_container.container_instance_id ,
821: v_cur_container.lpn ,
822: v_cur_container.container_item_id ,
823: v_cur_container.master_serial_number ,
824: v_cur_container.container_serial_number ,

Line 1113: v_container wsh_opsm_asn_containers_rec;

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;
1116: v_items_tab wsh_opsm_asn_items_tbl;
1117: v_itemdetails wsh_opsm_asn_itemdetails_rec;

Line 1835: v_container:=wsh_opsm_asn_containers_rec( v_cur_parent_container.container_instance_id ,

1831: ||'.'||TO_CHAR(v_cur_item.invoice_to_org_id)
1832: ||'.'||TO_CHAR(v_cur_item.invoice_to_contact_id)
1833: ||'.'||TO_CHAR(v_cur_item.soldto_customer_id)
1834: ||'.'||TO_CHAR(v_cur_item.soldto_contact_id)) ;
1835: v_container:=wsh_opsm_asn_containers_rec( v_cur_parent_container.container_instance_id ,
1836: v_cur_parent_container.lpn ,
1837: v_cur_parent_container.container_item_id ,
1838: v_cur_parent_container.master_serial_number ,
1839: v_cur_parent_container.container_serial_number ,

Line 1883: v_container:=wsh_opsm_asn_containers_rec( v_cur_container.container_instance_id ,

1879: END IF;
1880: END LOOP;
1881: v_container_level:='CHILD';
1882: END IF;
1883: v_container:=wsh_opsm_asn_containers_rec( v_cur_container.container_instance_id ,
1884: v_cur_container.lpn ,
1885: v_cur_container.container_item_id ,
1886: v_cur_container.master_serial_number ,
1887: v_cur_container.container_serial_number ,