APPS.WSH_OPSM_ASN_BE_PKG dependencies on WSH_OPSM_ASN_ITEMDETAILS_TBL

Line 11: -- p_out_itemdetails - It is wsh_opsm_asn_itemdetails_tbl Type

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
13: -- x_return_status-return status of the API
14: -- x_msg_data -return Error Message of the API
15:

Line 30: p_out_itemdetails OUT NOCOPY wsh_opsm_asn_itemdetails_tbl ,

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,
32: x_return_status OUT NOCOPY VARCHAR2 ,
33: x_msg_data OUT NOCOPY VARCHAR2)
34: IS

Line 45: v_itemdetails_tab wsh_opsm_asn_itemdetails_tbl;

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;
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;

Line 383: v_itemdetails_tab :=wsh_opsm_asn_itemdetails_tbl(v_itemdetails);

379: v_cur_itemdetails.to_serial_number ,
380: v_cur_itemdetails.organization_code );
381:
382: IF m=1 THEN
383: v_itemdetails_tab :=wsh_opsm_asn_itemdetails_tbl(v_itemdetails);
384: END IF;
385: IF m>1 THEN
386: v_itemdetails_tab.EXTEND;
387: v_itemdetails_tab(m):=v_itemdetails;

Line 1085: -- p_out_itemdetails - It is wsh_opsm_asn_itemdetails_tbl Type

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
1087: -- x_return_status-return status of the API
1088: -- x_msg_data -return Error Message of the API
1089:

Line 1103: p_out_itemdetails OUT NOCOPY wsh_opsm_asn_itemdetails_tbl ,

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,
1105: x_return_status OUT NOCOPY VARCHAR2 ,
1106: x_msg_data OUT NOCOPY VARCHAR2)
1107: IS

Line 1118: v_itemdetails_tab wsh_opsm_asn_itemdetails_tbl;

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;
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;

Line 1448: v_itemdetails_tab :=wsh_opsm_asn_itemdetails_tbl(v_itemdetails);

1444: v_cur_itemdetails.to_serial_number ,
1445: v_cur_itemdetails.organization_code );
1446:
1447: IF m=1 THEN
1448: v_itemdetails_tab :=wsh_opsm_asn_itemdetails_tbl(v_itemdetails);
1449: END IF;
1450: IF m>1 THEN
1451: v_itemdetails_tab.EXTEND;
1452: v_itemdetails_tab(m):=v_itemdetails;