APPS.WSH_OPSM_ASN_BE_PKG dependencies on WSH_OPSM_ASN_DELIVERY_TBL

Line 8: -- p_out_delivery- It is wsh_opsm_asn_delivery_tbl Type

4: ---------------------------------------------------------------------------------------
5: --
6: -- Procedure: get_asn_data
7: -- Parameters: p_delivery_id - DELIVERY_ID
8: -- p_out_delivery- It is wsh_opsm_asn_delivery_tbl Type
9: -- p_out_container - It is wsh_opsm_asn_containers_tbl Type
10: -- p_out_items-It is wsh_opsm_asn_items_tbl Type
11: -- p_out_itemdetails - It is wsh_opsm_asn_itemdetails_tbl Type
12: -- p_out_itemgenealogy - It is wsh_opsm_asn_itemgenealogy_tbl Type

Line 27: p_out_delivery OUT NOCOPY wsh_opsm_asn_delivery_tbl ,

23: --
24: ---------------------------------------------------------------------------------------
25: PROCEDURE get_asn_data ( p_delivery_id IN NUMBER ,
26: p_delivery_detail_id IN NUMBER ,
27: p_out_delivery OUT NOCOPY wsh_opsm_asn_delivery_tbl ,
28: p_out_container OUT NOCOPY wsh_opsm_asn_containers_tbl ,
29: p_out_items OUT NOCOPY wsh_opsm_asn_items_tbl ,
30: p_out_itemdetails OUT NOCOPY wsh_opsm_asn_itemdetails_tbl ,
31: p_out_itemgenealogy OUT NOCOPY wsh_opsm_asn_itemgenealogy_tbl,

Line 39: v_delivery_tab wsh_opsm_asn_delivery_tbl;

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

Line 992: v_delivery_tab :=wsh_opsm_asn_delivery_tbl(v_delivery);

988: del_tab(l).soldby_contact_emailid ,
989: del_tab(l).soldby_contact_phonenumber);
990:
991: IF i=1 THEN
992: v_delivery_tab :=wsh_opsm_asn_delivery_tbl(v_delivery);
993: END IF;
994: IF i>1 THEN
995: v_delivery_tab.EXTEND;
996: v_delivery_tab(i):=v_delivery;

Line 1082: -- p_out_delivery- It is wsh_opsm_asn_delivery_tbl Type

1078: ---------------------------------------------------------------------------------------
1079: --
1080: -- Procedure: get_asn_data
1081: -- Parameters: p_delivery_id - DELIVERY_ID
1082: -- p_out_delivery- It is wsh_opsm_asn_delivery_tbl Type
1083: -- p_out_container - It is wsh_opsm_asn_containers_tbl Type
1084: -- p_out_items-It is wsh_opsm_asn_items_tbl Type
1085: -- p_out_itemdetails - It is wsh_opsm_asn_itemdetails_tbl Type
1086: -- p_out_itemgenealogy - It is wsh_opsm_asn_itemgenealogy_tbl Type

Line 1100: p_out_delivery OUT NOCOPY wsh_opsm_asn_delivery_tbl ,

1096: -- out in the form Out parameters.
1097: --
1098: ---------------------------------------------------------------------------------------
1099: PROCEDURE get_asn_data ( p_delivery_id IN NUMBER ,
1100: p_out_delivery OUT NOCOPY wsh_opsm_asn_delivery_tbl ,
1101: p_out_container OUT NOCOPY wsh_opsm_asn_containers_tbl ,
1102: p_out_items OUT NOCOPY wsh_opsm_asn_items_tbl ,
1103: p_out_itemdetails OUT NOCOPY wsh_opsm_asn_itemdetails_tbl ,
1104: p_out_itemgenealogy OUT NOCOPY wsh_opsm_asn_itemgenealogy_tbl,

Line 1112: v_delivery_tab wsh_opsm_asn_delivery_tbl;

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

Line 2055: v_delivery_tab :=wsh_opsm_asn_delivery_tbl(v_delivery);

2051: del_tab(l).soldby_contact_emailid ,
2052: del_tab(l).soldby_contact_phonenumber);
2053:
2054: IF i=1 THEN
2055: v_delivery_tab :=wsh_opsm_asn_delivery_tbl(v_delivery);
2056: END IF;
2057: IF i>1 THEN
2058: v_delivery_tab.EXTEND;
2059: v_delivery_tab(i):=v_delivery;