eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.GML_PO_CON_REQ dependencies on CPG_PURCHASING_INTERFACE

Line 113: | insert rows in cpg_purchasing_interface table |

109: | |
110: | PROCEDURE NAME po_resub_insert |
111: | |
112: | DESCRIPTION This private procedure will call procedure to |
113: | insert rows in cpg_purchasing_interface table |
114: | |
115: | |
116: | MODIFICATION HISTORY |
117: | Uday Phadtare new procedure created for Bug2048971. |

Line 128: FROM cpg_purchasing_interface

124:
125: CURSOR get_failed_releases (v_po_header_id NUMBER, v_po_line_id NUMBER,
126: v_po_line_location_id NUMBER, v_po_release_id NUMBER) IS
127: SELECT po_release_id, invalid_ind
128: FROM cpg_purchasing_interface
129: WHERE po_header_id = v_po_header_id
130: AND po_line_id = v_po_line_id
131: AND po_line_location_id = v_po_line_location_id
132: AND po_release_id = v_po_release_id

Line 245: v_po_header_id cpg_purchasing_interface.po_header_id%TYPE := NULL;

241: v_to_date IN OUT NOCOPY VARCHAR2,
242: v_po_no IN VARCHAR2)
243: IS
244:
245: v_po_header_id cpg_purchasing_interface.po_header_id%TYPE := NULL;
246: v_po_line_id cpg_purchasing_interface.po_line_id%TYPE := NULL;
247: v_line_location_id cpg_purchasing_interface.po_line_location_id%TYPE := NULL;
248: v_transaction_id cpg_purchasing_interface.transaction_id%TYPE := NULL;
249: v_po_release_id cpg_purchasing_interface.po_release_id%TYPE := NULL;

Line 246: v_po_line_id cpg_purchasing_interface.po_line_id%TYPE := NULL;

242: v_po_no IN VARCHAR2)
243: IS
244:
245: v_po_header_id cpg_purchasing_interface.po_header_id%TYPE := NULL;
246: v_po_line_id cpg_purchasing_interface.po_line_id%TYPE := NULL;
247: v_line_location_id cpg_purchasing_interface.po_line_location_id%TYPE := NULL;
248: v_transaction_id cpg_purchasing_interface.transaction_id%TYPE := NULL;
249: v_po_release_id cpg_purchasing_interface.po_release_id%TYPE := NULL;
250: v_transaction_type cpg_purchasing_interface.transaction_type%TYPE := NULL;

Line 247: v_line_location_id cpg_purchasing_interface.po_line_location_id%TYPE := NULL;

243: IS
244:
245: v_po_header_id cpg_purchasing_interface.po_header_id%TYPE := NULL;
246: v_po_line_id cpg_purchasing_interface.po_line_id%TYPE := NULL;
247: v_line_location_id cpg_purchasing_interface.po_line_location_id%TYPE := NULL;
248: v_transaction_id cpg_purchasing_interface.transaction_id%TYPE := NULL;
249: v_po_release_id cpg_purchasing_interface.po_release_id%TYPE := NULL;
250: v_transaction_type cpg_purchasing_interface.transaction_type%TYPE := NULL;
251:

Line 248: v_transaction_id cpg_purchasing_interface.transaction_id%TYPE := NULL;

244:
245: v_po_header_id cpg_purchasing_interface.po_header_id%TYPE := NULL;
246: v_po_line_id cpg_purchasing_interface.po_line_id%TYPE := NULL;
247: v_line_location_id cpg_purchasing_interface.po_line_location_id%TYPE := NULL;
248: v_transaction_id cpg_purchasing_interface.transaction_id%TYPE := NULL;
249: v_po_release_id cpg_purchasing_interface.po_release_id%TYPE := NULL;
250: v_transaction_type cpg_purchasing_interface.transaction_type%TYPE := NULL;
251:
252: CURSOR get_synch_failed_rows_DT (v_date_from DATE, v_date_to DATE) IS

Line 249: v_po_release_id cpg_purchasing_interface.po_release_id%TYPE := NULL;

245: v_po_header_id cpg_purchasing_interface.po_header_id%TYPE := NULL;
246: v_po_line_id cpg_purchasing_interface.po_line_id%TYPE := NULL;
247: v_line_location_id cpg_purchasing_interface.po_line_location_id%TYPE := NULL;
248: v_transaction_id cpg_purchasing_interface.transaction_id%TYPE := NULL;
249: v_po_release_id cpg_purchasing_interface.po_release_id%TYPE := NULL;
250: v_transaction_type cpg_purchasing_interface.transaction_type%TYPE := NULL;
251:
252: CURSOR get_synch_failed_rows_DT (v_date_from DATE, v_date_to DATE) IS
253: SELECT po_header_id,

Line 250: v_transaction_type cpg_purchasing_interface.transaction_type%TYPE := NULL;

246: v_po_line_id cpg_purchasing_interface.po_line_id%TYPE := NULL;
247: v_line_location_id cpg_purchasing_interface.po_line_location_id%TYPE := NULL;
248: v_transaction_id cpg_purchasing_interface.transaction_id%TYPE := NULL;
249: v_po_release_id cpg_purchasing_interface.po_release_id%TYPE := NULL;
250: v_transaction_type cpg_purchasing_interface.transaction_type%TYPE := NULL;
251:
252: CURSOR get_synch_failed_rows_DT (v_date_from DATE, v_date_to DATE) IS
253: SELECT po_header_id,
254: po_line_id,