APPS.WSH_OPSM_ASN_BE_PKG dependencies on WSH_OPSM_ASN_ITEMGENEALOGY_TBL

Line 12: -- p_out_itemgenealogy - It is wsh_opsm_asn_itemgenealogy_tbl Type

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
13: -- x_return_status-return status of the API
14: -- x_msg_data -return Error Message of the API
15:
16: -- Description: This Procedure takes delivery_id has input and

Line 31: p_out_itemgenealogy OUT NOCOPY wsh_opsm_asn_itemgenealogy_tbl,

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,
32: x_return_status OUT NOCOPY VARCHAR2 ,
33: x_msg_data OUT NOCOPY VARCHAR2)
34: IS
35: l_module_name CONSTANT VARCHAR2(100):= 'wsh.plsql.' || G_PKG_NAME || '.' || 'GET_ASN_DATA';

Line 47: v_itemgenealogy_tab wsh_opsm_asn_itemgenealogy_tbl;

43: v_items_tab wsh_opsm_asn_items_tbl;
44: v_itemdetails wsh_opsm_asn_itemdetails_rec;
45: v_itemdetails_tab wsh_opsm_asn_itemdetails_tbl;
46: v_itemgenealogy wsh_opsm_asn_itemgenealogy_rec;
47: v_itemgenealogy_tab wsh_opsm_asn_itemgenealogy_tbl;
48: v_container_level VARCHAR2(200);
49: v_parent_id NUMBER;
50: v_opsm_parent_identification VARCHAR2(1000):=NULL;
51: v_serial_identification VARCHAR2(1000):='0---0';

Line 599: v_itemgenealogy_tab :=wsh_opsm_asn_itemgenealogy_tbl(v_itemgenealogy);

595: v_opsm_parent_identification);
596:
597:
598: IF n=1 THEN
599: v_itemgenealogy_tab :=wsh_opsm_asn_itemgenealogy_tbl(v_itemgenealogy);
600: END IF;
601: IF n>1 THEN
602: v_itemgenealogy_tab.EXTEND;
603: v_itemgenealogy_tab(n):=v_itemgenealogy;

Line 1086: -- p_out_itemgenealogy - It is wsh_opsm_asn_itemgenealogy_tbl Type

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
1087: -- x_return_status-return status of the API
1088: -- x_msg_data -return Error Message of the API
1089:
1090: -- Description: This Procedure takes delivery_id has input and

Line 1104: p_out_itemgenealogy OUT NOCOPY wsh_opsm_asn_itemgenealogy_tbl,

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,
1105: x_return_status OUT NOCOPY VARCHAR2 ,
1106: x_msg_data OUT NOCOPY VARCHAR2)
1107: IS
1108: l_module_name CONSTANT VARCHAR2(100):= 'wsh.plsql.' || G_PKG_NAME || '.' || 'GET_ASN_DATA';

Line 1120: v_itemgenealogy_tab wsh_opsm_asn_itemgenealogy_tbl;

1116: v_items_tab wsh_opsm_asn_items_tbl;
1117: v_itemdetails wsh_opsm_asn_itemdetails_rec;
1118: v_itemdetails_tab wsh_opsm_asn_itemdetails_tbl;
1119: v_itemgenealogy wsh_opsm_asn_itemgenealogy_rec;
1120: v_itemgenealogy_tab wsh_opsm_asn_itemgenealogy_tbl;
1121: v_container_level VARCHAR2(200);
1122: v_parent_id NUMBER;
1123: v_opsm_parent_identification VARCHAR2(1000):=NULL;
1124: v_serial_identification VARCHAR2(1000):='0---0';

Line 1664: v_itemgenealogy_tab :=wsh_opsm_asn_itemgenealogy_tbl(v_itemgenealogy);

1660: v_opsm_parent_identification);
1661:
1662:
1663: IF n=1 THEN
1664: v_itemgenealogy_tab :=wsh_opsm_asn_itemgenealogy_tbl(v_itemgenealogy);
1665: END IF;
1666: IF n>1 THEN
1667: v_itemgenealogy_tab.EXTEND;
1668: v_itemgenealogy_tab(n):=v_itemgenealogy;