APPS.GML_SYNCH_BPOS dependencies on CPG_PURCHASING_INTERFACE

Line 131: ( v_po_header_id IN CPG_PURCHASING_INTERFACE.PO_HEADER_ID%TYPE,

127:
128:
129: FUNCTION bpo_line_exist
130:
131: ( v_po_header_id IN CPG_PURCHASING_INTERFACE.PO_HEADER_ID%TYPE,
132: v_po_line_id IN CPG_PURCHASING_INTERFACE.PO_LINE_ID%TYPE,
133: v_po_line_location_id IN CPG_PURCHASING_INTERFACE.PO_LINE_LOCATION_ID%TYPE)
134:
135: RETURN BOOLEAN

Line 132: v_po_line_id IN CPG_PURCHASING_INTERFACE.PO_LINE_ID%TYPE,

128:
129: FUNCTION bpo_line_exist
130:
131: ( v_po_header_id IN CPG_PURCHASING_INTERFACE.PO_HEADER_ID%TYPE,
132: v_po_line_id IN CPG_PURCHASING_INTERFACE.PO_LINE_ID%TYPE,
133: v_po_line_location_id IN CPG_PURCHASING_INTERFACE.PO_LINE_LOCATION_ID%TYPE)
134:
135: RETURN BOOLEAN
136: IS

Line 133: v_po_line_location_id IN CPG_PURCHASING_INTERFACE.PO_LINE_LOCATION_ID%TYPE)

129: FUNCTION bpo_line_exist
130:
131: ( v_po_header_id IN CPG_PURCHASING_INTERFACE.PO_HEADER_ID%TYPE,
132: v_po_line_id IN CPG_PURCHASING_INTERFACE.PO_LINE_ID%TYPE,
133: v_po_line_location_id IN CPG_PURCHASING_INTERFACE.PO_LINE_LOCATION_ID%TYPE)
134:
135: RETURN BOOLEAN
136: IS
137:

Line 270: FROM cpg_purchasing_interface

266: IS
267:
268: CURSOR int_cur IS
269: SELECT *
270: FROM cpg_purchasing_interface
271: WHERE invalid_ind = 'N'
272: AND (transaction_type = 'PLANNED' AND release_num = 0);
273:
274: int_rec int_cur%ROWTYPE;

Line 312: p_po_header_id CPG_PURCHASING_INTERFACE.PO_HEADER_ID%TYPE,

308: /* Cursor to select bpo_line_id */
309:
310: CURSOR bpo_line_id_cur
311: (
312: p_po_header_id CPG_PURCHASING_INTERFACE.PO_HEADER_ID%TYPE,
313: p_po_line_id CPG_PURCHASING_INTERFACE.PO_LINE_ID%TYPE,
314: p_po_line_location_id CPG_PURCHASING_INTERFACE.PO_LINE_LOCATION_ID%TYPE
315: ) IS
316: SELECT bpo_line_id

Line 313: p_po_line_id CPG_PURCHASING_INTERFACE.PO_LINE_ID%TYPE,

309:
310: CURSOR bpo_line_id_cur
311: (
312: p_po_header_id CPG_PURCHASING_INTERFACE.PO_HEADER_ID%TYPE,
313: p_po_line_id CPG_PURCHASING_INTERFACE.PO_LINE_ID%TYPE,
314: p_po_line_location_id CPG_PURCHASING_INTERFACE.PO_LINE_LOCATION_ID%TYPE
315: ) IS
316: SELECT bpo_line_id
317: FROM cpg_oragems_mapping

Line 314: p_po_line_location_id CPG_PURCHASING_INTERFACE.PO_LINE_LOCATION_ID%TYPE

310: CURSOR bpo_line_id_cur
311: (
312: p_po_header_id CPG_PURCHASING_INTERFACE.PO_HEADER_ID%TYPE,
313: p_po_line_id CPG_PURCHASING_INTERFACE.PO_LINE_ID%TYPE,
314: p_po_line_location_id CPG_PURCHASING_INTERFACE.PO_LINE_LOCATION_ID%TYPE
315: ) IS
316: SELECT bpo_line_id
317: FROM cpg_oragems_mapping
318: WHERE po_header_id = p_po_header_id

Line 400: UPDATE cpg_purchasing_interface

396: /* last_update_date for GEMMS 5.0*/
397: int_rec.last_update_date
398: ) = FALSE THEN
399:
400: UPDATE cpg_purchasing_interface
401: SET invalid_ind = 'Y'
402: WHERE po_header_id = int_rec.po_header_id
403: AND po_line_id = int_rec.po_line_id
404: AND po_line_location_id = int_rec.po_line_location_id;

Line 987: UPDATE cpg_purchasing_interface

983: END IF; /* Cancel/Close of PPO. */
984:
985: END IF; /* End of If condition for bpo_line existing*/
986:
987: UPDATE cpg_purchasing_interface
988: SET invalid_ind = 'P' /*row processed*/
989: WHERE po_header_id = int_rec.po_header_id
990: AND po_line_id = int_rec.po_line_id
991: AND po_line_location_id = int_rec.po_line_location_id;