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_SYNCH dependencies on CPG_PURCHASING_INTERFACE

Line 190: v_orgn_code IN CPG_PURCHASING_INTERFACE.ORGN_CODE%TYPE)

186: +============================================================================*/
187:
188: FUNCTION new_po_hdr
189: (v_po_no IN PO_ORDR_HDR.PO_NO%TYPE,
190: v_orgn_code IN CPG_PURCHASING_INTERFACE.ORGN_CODE%TYPE)
191: RETURN BOOLEAN
192: IS
193: v_row_count NUMBER :=0;
194: err_msg VARCHAR2(100);

Line 1393: FROM cpg_purchasing_interface

1389: po_release_id,
1390: release_num,
1391: source_shipment_id,
1392: line_no
1393: FROM cpg_purchasing_interface
1394: WHERE invalid_ind ='N'
1395: AND (transaction_type IN ('STANDARD','BLANKET') /* Bug 2031029 - Do not select TEMPLATE PPOs */
1396: OR
1397: (transaction_type = 'PLANNED' AND nvl(po_release_id,0) <> 0 AND nvl(release_num,0) <> 0)

Line 1540: v_po_header_id CPG_PURCHASING_INTERFACE.PO_HEADER_ID%TYPE,

1536: v_buyer_code VARCHAR2(35);
1537: v_agent_id PO_RELEASES_ALL.agent_id%TYPE;
1538:
1539: CURSOR release_date_cur (
1540: v_po_header_id CPG_PURCHASING_INTERFACE.PO_HEADER_ID%TYPE,
1541: v_release_num CPG_PURCHASING_INTERFACE.RELEASE_NUM%TYPE)
1542: IS
1543: SELECT release_date,created_by, last_updated_by, last_update_date,agent_id
1544: FROM po_releases_all

Line 1541: v_release_num CPG_PURCHASING_INTERFACE.RELEASE_NUM%TYPE)

1537: v_agent_id PO_RELEASES_ALL.agent_id%TYPE;
1538:
1539: CURSOR release_date_cur (
1540: v_po_header_id CPG_PURCHASING_INTERFACE.PO_HEADER_ID%TYPE,
1541: v_release_num CPG_PURCHASING_INTERFACE.RELEASE_NUM%TYPE)
1542: IS
1543: SELECT release_date,created_by, last_updated_by, last_update_date,agent_id
1544: FROM po_releases_all
1545: WHERE po_header_id = v_po_header_id

Line 1557: v_po_header_id CPG_PURCHASING_INTERFACE.PO_HEADER_ID%TYPE,

1553:
1554: /* END - BUG 1829102,BUG 1785704 */
1555:
1556: CURSOR bpo_cur (
1557: v_po_header_id CPG_PURCHASING_INTERFACE.PO_HEADER_ID%TYPE,
1558: v_po_line_id CPG_PURCHASING_INTERFACE.PO_LINE_ID%TYPE,
1559: v_source_shipment_id CPG_PURCHASING_INTERFACE.SOURCE_SHIPMENT_ID%TYPE
1560: )
1561: IS

Line 1558: v_po_line_id CPG_PURCHASING_INTERFACE.PO_LINE_ID%TYPE,

1554: /* END - BUG 1829102,BUG 1785704 */
1555:
1556: CURSOR bpo_cur (
1557: v_po_header_id CPG_PURCHASING_INTERFACE.PO_HEADER_ID%TYPE,
1558: v_po_line_id CPG_PURCHASING_INTERFACE.PO_LINE_ID%TYPE,
1559: v_source_shipment_id CPG_PURCHASING_INTERFACE.SOURCE_SHIPMENT_ID%TYPE
1560: )
1561: IS
1562: SELECT bpo_id, bpo_line_id

Line 1559: v_source_shipment_id CPG_PURCHASING_INTERFACE.SOURCE_SHIPMENT_ID%TYPE

1555:
1556: CURSOR bpo_cur (
1557: v_po_header_id CPG_PURCHASING_INTERFACE.PO_HEADER_ID%TYPE,
1558: v_po_line_id CPG_PURCHASING_INTERFACE.PO_LINE_ID%TYPE,
1559: v_source_shipment_id CPG_PURCHASING_INTERFACE.SOURCE_SHIPMENT_ID%TYPE
1560: )
1561: IS
1562: SELECT bpo_id, bpo_line_id
1563: FROM cpg_oragems_mapping

Line 1837: UPDATE cpg_purchasing_interface

1833: int_rec.revision_count,
1834: int_rec.last_update_date) = FALSE OR
1835: v_retval < 0 THEN
1836:
1837: UPDATE cpg_purchasing_interface
1838: SET invalid_ind = 'Y'
1839: WHERE rowid = int_rec.rowid;
1840:
1841: retcode :=1;

Line 1951: /* HW BUG#:1107267 don't get exchange rate, rate is already in cpg_purchasing_interface */

1947:
1948: GML_VALIDATE_PO.get_base_currency (v_base_currency,
1949: int_rec.orgn_code);
1950:
1951: /* HW BUG#:1107267 don't get exchange rate, rate is already in cpg_purchasing_interface */
1952: /* IF (v_base_currency <> int_rec.billing_currency) THEN
1953:
1954: GML_VALIDATE_PO.get_gl_source (v_gl_source_type);
1955:

Line 2102: /* nvl(v_exchange_rate, 1), BUG#:1107267. Get value from cpg_purchasing_interface */

2098: int_rec.to_whse, /* mandatory field, checked not null*/
2099: int_rec.recv_loct, /* T.Ricci 7/7/98 integ constraint change*/
2100: int_rec.ship_mthd, /* T.Ricci 7/6/98 integ constraint change*/
2101: v_frtbill_mthd, /* LE 25/08/98 NULL OK*/
2102: /* nvl(v_exchange_rate, 1), BUG#:1107267. Get value from cpg_purchasing_interface */
2103: nvl(int_rec.purchase_exchange_rate, 1),
2104: /* nvl(v_mul_div_sign, 0), BUG#:1107267. Get value from cpg_purchasing_interface */
2105: nvl(int_rec.mul_div_sign, 0),
2106: int_rec.billing_currency, /*mandatory field, not null*/

Line 2104: /* nvl(v_mul_div_sign, 0), BUG#:1107267. Get value from cpg_purchasing_interface */

2100: int_rec.ship_mthd, /* T.Ricci 7/6/98 integ constraint change*/
2101: v_frtbill_mthd, /* LE 25/08/98 NULL OK*/
2102: /* nvl(v_exchange_rate, 1), BUG#:1107267. Get value from cpg_purchasing_interface */
2103: nvl(int_rec.purchase_exchange_rate, 1),
2104: /* nvl(v_mul_div_sign, 0), BUG#:1107267. Get value from cpg_purchasing_interface */
2105: nvl(int_rec.mul_div_sign, 0),
2106: int_rec.billing_currency, /*mandatory field, not null*/
2107: nvl(int_rec.currency_bght_fwd, 0),
2108: v_terms_code, /* KYH 28/AUG/98 nullable column */

Line 2792: UPDATE cpg_purchasing_interface

2788: retcode :=1;
2789: END IF;
2790:
2791: IF v_map_retcode > 0 THEN
2792: UPDATE cpg_purchasing_interface
2793: SET invalid_ind = 'Y'
2794: WHERE rowid = int_rec.rowid;
2795: EXIT;
2796: END IF;

Line 3598: UPDATE cpg_purchasing_interface

3594: raise_application_error(-20001, err_msg);
3595: END;
3596: /* set the record's flag as 'P', for processed*/
3597:
3598: UPDATE cpg_purchasing_interface
3599: SET invalid_ind = 'P' /*row processed*/
3600: WHERE rowid = int_rec.rowid;
3601:
3602: FND_MESSAGE.set_name('GML', 'PO_NUM_OK');

Line 3609: UPDATE cpg_purchasing_interface

3605: FND_FILE.NEW_LINE(FND_FILE.LOG, 1 );
3606: FND_FILE.PUT_LINE(FND_FILE.LOG, v_err_message ); /*message */
3607: FND_FILE.NEW_LINE(FND_FILE.LOG, 1 );
3608: ELSE
3609: UPDATE cpg_purchasing_interface
3610: SET invalid_ind = 'E' /* This line can not be inserted in po_ordr_dtl */
3611: WHERE rowid = int_rec.rowid;
3612: END IF; /* B2594000 */
3613: