APPS.OE_SALES_CAN_UTIL dependencies on OE_HOLD_RELEASES

Line 214: l_release_reason_code OE_HOLD_RELEASES.RELEASE_REASON_CODE%TYPE;

210: lhisttypecode VARCHAR2(240);
211: l_fulfill VARCHAR2(30);
212: l_order_tbl OE_HOLDS_PVT.order_tbl_type;
213: l_hold_id OE_HOLD_DEFINITIONS.HOLD_ID%TYPE;
214: l_release_reason_code OE_HOLD_RELEASES.RELEASE_REASON_CODE%TYPE;
215: l_release_comment OE_HOLD_RELEASES.RELEASE_COMMENT%TYPE;
216:
217: -- INVCONV
218: l_cancelled_qty2 NUMBER; -- INVCONV

Line 215: l_release_comment OE_HOLD_RELEASES.RELEASE_COMMENT%TYPE;

211: l_fulfill VARCHAR2(30);
212: l_order_tbl OE_HOLDS_PVT.order_tbl_type;
213: l_hold_id OE_HOLD_DEFINITIONS.HOLD_ID%TYPE;
214: l_release_reason_code OE_HOLD_RELEASES.RELEASE_REASON_CODE%TYPE;
215: l_release_comment OE_HOLD_RELEASES.RELEASE_COMMENT%TYPE;
216:
217: -- INVCONV
218: l_cancelled_qty2 NUMBER; -- INVCONV
219:

Line 1217: l_release_reason_code OE_HOLD_RELEASES.RELEASE_REASON_CODE%TYPE;

1213: l_return_status VARCHAR2(30);
1214: l_result_out VARCHAR2(30);
1215: l_order_tbl OE_HOLDS_PVT.order_tbl_type;
1216: l_hold_id OE_HOLD_DEFINITIONS.HOLD_ID%TYPE;
1217: l_release_reason_code OE_HOLD_RELEASES.RELEASE_REASON_CODE%TYPE;
1218: l_release_comment OE_HOLD_RELEASES.RELEASE_COMMENT%TYPE;
1219:
1220: l_service_parent_exists VARCHAR2(1) := 'N';
1221: l_x_line_old_tbl OE_Order_PUB.line_tbl_type;

Line 1218: l_release_comment OE_HOLD_RELEASES.RELEASE_COMMENT%TYPE;

1214: l_result_out VARCHAR2(30);
1215: l_order_tbl OE_HOLDS_PVT.order_tbl_type;
1216: l_hold_id OE_HOLD_DEFINITIONS.HOLD_ID%TYPE;
1217: l_release_reason_code OE_HOLD_RELEASES.RELEASE_REASON_CODE%TYPE;
1218: l_release_comment OE_HOLD_RELEASES.RELEASE_COMMENT%TYPE;
1219:
1220: l_service_parent_exists VARCHAR2(1) := 'N';
1221: l_x_line_old_tbl OE_Order_PUB.line_tbl_type;
1222: i NUMBER := 0;