APPS.WSH_OPSM_ASN_BE_PKG dependencies on WSH_OPSM_ASN_DELIVERIES_V

Line 78: TYPE tab_del IS TABLE OF wsh_opsm_asn_deliveries_v%ROWTYPE INDEX BY BINARY_INTEGER;

74: TYPE delivery_count IS TABLE OF NUMBER INDEX BY VARCHAR2(255);
75: del_count delivery_count;
76: TYPE container_count IS TABLE OF NUMBER INDEX BY VARCHAR2(255);
77: cont_count container_count;
78: TYPE tab_del IS TABLE OF wsh_opsm_asn_deliveries_v%ROWTYPE INDEX BY BINARY_INTEGER;
79: del_tab tab_del;
80:
81: CURSOR cur_item
82: IS

Line 112: FROM wsh_opsm_asn_deliveries_v

108:
109: CURSOR cur_delivery
110: IS
111: SELECT *
112: FROM wsh_opsm_asn_deliveries_v
113: WHERE delivery_id = p_delivery_id
114: AND delivery_detail_id = p_delivery_detail_id;
115:
116: CURSOR cur_itemdetails(p_delivery_id IN NUMBER,

Line 1151: TYPE tab_del IS TABLE OF wsh_opsm_asn_deliveries_v%ROWTYPE INDEX BY BINARY_INTEGER;

1147: TYPE delivery_count IS TABLE OF NUMBER INDEX BY VARCHAR2(255);
1148: del_count delivery_count;
1149: TYPE container_count IS TABLE OF NUMBER INDEX BY VARCHAR2(255);
1150: cont_count container_count;
1151: TYPE tab_del IS TABLE OF wsh_opsm_asn_deliveries_v%ROWTYPE INDEX BY BINARY_INTEGER;
1152: del_tab tab_del;
1153:
1154: CURSOR cur_item
1155: IS

Line 1180: FROM wsh_opsm_asn_deliveries_v

1176:
1177: CURSOR cur_delivery
1178: IS
1179: SELECT *
1180: FROM wsh_opsm_asn_deliveries_v
1181: WHERE delivery_id = p_delivery_id ;
1182:
1183: CURSOR cur_itemdetails(p_delivery_id IN NUMBER,
1184: p_delivery_detail_id IN NUMBER)