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_RECV2_PKG dependencies on CPG_ORAGEMS_MAPPING

Line 23: v_po_header_id OUT NOCOPY cpg_oragems_mapping.po_header_id%TYPE,

19:
20: PROCEDURE get_oracle_id
21: ( v_po_id IN po_ordr_hdr.po_id%TYPE,
22: v_line_id IN po_ordr_dtl.line_id%TYPE,
23: v_po_header_id OUT NOCOPY cpg_oragems_mapping.po_header_id%TYPE,
24: v_po_line_id OUT NOCOPY cpg_oragems_mapping.po_line_id%TYPE,
25: v_line_location_id OUT NOCOPY cpg_oragems_mapping.po_line_location_id%TYPE,
26: v_po_release_id OUT NOCOPY cpg_oragems_mapping.po_release_id%TYPE)
27: IS

Line 24: v_po_line_id OUT NOCOPY cpg_oragems_mapping.po_line_id%TYPE,

20: PROCEDURE get_oracle_id
21: ( v_po_id IN po_ordr_hdr.po_id%TYPE,
22: v_line_id IN po_ordr_dtl.line_id%TYPE,
23: v_po_header_id OUT NOCOPY cpg_oragems_mapping.po_header_id%TYPE,
24: v_po_line_id OUT NOCOPY cpg_oragems_mapping.po_line_id%TYPE,
25: v_line_location_id OUT NOCOPY cpg_oragems_mapping.po_line_location_id%TYPE,
26: v_po_release_id OUT NOCOPY cpg_oragems_mapping.po_release_id%TYPE)
27: IS
28: CURSOR id_cur IS

Line 25: v_line_location_id OUT NOCOPY cpg_oragems_mapping.po_line_location_id%TYPE,

21: ( v_po_id IN po_ordr_hdr.po_id%TYPE,
22: v_line_id IN po_ordr_dtl.line_id%TYPE,
23: v_po_header_id OUT NOCOPY cpg_oragems_mapping.po_header_id%TYPE,
24: v_po_line_id OUT NOCOPY cpg_oragems_mapping.po_line_id%TYPE,
25: v_line_location_id OUT NOCOPY cpg_oragems_mapping.po_line_location_id%TYPE,
26: v_po_release_id OUT NOCOPY cpg_oragems_mapping.po_release_id%TYPE)
27: IS
28: CURSOR id_cur IS
29: SELECT po_header_id,

Line 26: v_po_release_id OUT NOCOPY cpg_oragems_mapping.po_release_id%TYPE)

22: v_line_id IN po_ordr_dtl.line_id%TYPE,
23: v_po_header_id OUT NOCOPY cpg_oragems_mapping.po_header_id%TYPE,
24: v_po_line_id OUT NOCOPY cpg_oragems_mapping.po_line_id%TYPE,
25: v_line_location_id OUT NOCOPY cpg_oragems_mapping.po_line_location_id%TYPE,
26: v_po_release_id OUT NOCOPY cpg_oragems_mapping.po_release_id%TYPE)
27: IS
28: CURSOR id_cur IS
29: SELECT po_header_id,
30: po_line_id,

Line 33: FROM cpg_oragems_mapping

29: SELECT po_header_id,
30: po_line_id,
31: po_line_location_id,
32: po_release_id
33: FROM cpg_oragems_mapping
34: WHERE po_id = v_po_id
35: AND line_id = v_line_id;
36:
37: err_num NUMBER;

Line 347: ( v_po_header_id IN cpg_oragems_mapping.po_header_id%TYPE,

343: | 03-MAR-00 HW - BUG#:1222247 - changed status code |
344: =========================================================================*/
345:
346: PROCEDURE update_line_locations
347: ( v_po_header_id IN cpg_oragems_mapping.po_header_id%TYPE,
348: v_po_line_id IN cpg_oragems_mapping.po_line_id%TYPE,
349: v_line_location_id IN cpg_oragems_mapping.po_line_location_id%TYPE,
350: v_po_release_id IN cpg_oragems_mapping.po_release_id%TYPE,
351: v_org_id IN gl_plcy_mst.org_id%TYPE,

Line 348: v_po_line_id IN cpg_oragems_mapping.po_line_id%TYPE,

344: =========================================================================*/
345:
346: PROCEDURE update_line_locations
347: ( v_po_header_id IN cpg_oragems_mapping.po_header_id%TYPE,
348: v_po_line_id IN cpg_oragems_mapping.po_line_id%TYPE,
349: v_line_location_id IN cpg_oragems_mapping.po_line_location_id%TYPE,
350: v_po_release_id IN cpg_oragems_mapping.po_release_id%TYPE,
351: v_org_id IN gl_plcy_mst.org_id%TYPE,
352: v_po_status IN po_ordr_dtl.po_status%TYPE,

Line 349: v_line_location_id IN cpg_oragems_mapping.po_line_location_id%TYPE,

345:
346: PROCEDURE update_line_locations
347: ( v_po_header_id IN cpg_oragems_mapping.po_header_id%TYPE,
348: v_po_line_id IN cpg_oragems_mapping.po_line_id%TYPE,
349: v_line_location_id IN cpg_oragems_mapping.po_line_location_id%TYPE,
350: v_po_release_id IN cpg_oragems_mapping.po_release_id%TYPE,
351: v_org_id IN gl_plcy_mst.org_id%TYPE,
352: v_po_status IN po_ordr_dtl.po_status%TYPE,
353: v_received_qty IN po_recv_dtl.recv_qty1%TYPE,

Line 350: v_po_release_id IN cpg_oragems_mapping.po_release_id%TYPE,

346: PROCEDURE update_line_locations
347: ( v_po_header_id IN cpg_oragems_mapping.po_header_id%TYPE,
348: v_po_line_id IN cpg_oragems_mapping.po_line_id%TYPE,
349: v_line_location_id IN cpg_oragems_mapping.po_line_location_id%TYPE,
350: v_po_release_id IN cpg_oragems_mapping.po_release_id%TYPE,
351: v_org_id IN gl_plcy_mst.org_id%TYPE,
352: v_po_status IN po_ordr_dtl.po_status%TYPE,
353: v_received_qty IN po_recv_dtl.recv_qty1%TYPE,
354: v_returned_qty IN po_rtrn_dtl.return_qty1%TYPE,

Line 356: v_timestamp IN cpg_oragems_mapping.time_stamp%TYPE)

352: v_po_status IN po_ordr_dtl.po_status%TYPE,
353: v_received_qty IN po_recv_dtl.recv_qty1%TYPE,
354: v_returned_qty IN po_rtrn_dtl.return_qty1%TYPE,
355: v_created_by IN po_recv_dtl.created_by%TYPE,
356: v_timestamp IN cpg_oragems_mapping.time_stamp%TYPE)
357: IS
358: v_closed_code po_line_locations_all.closed_code%TYPE;
359: v_last_updated_by po_line_locations_all.last_updated_by%TYPE;
360: v_closed_reason po_line_locations_all.closed_reason%TYPE;