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 PO_ORDR_HDR

Line 20: PROCEDURE next_po_id ( new_po_id OUT NOCOPY PO_ORDR_HDR.PO_ID%TYPE,

16: | |
17: +============================================================================*/
18:
19: -- yannamal GSCC b4403407
20: PROCEDURE next_po_id ( new_po_id OUT NOCOPY PO_ORDR_HDR.PO_ID%TYPE,
21: p_doc_type IN VARCHAR2,
22: p_orgn_code IN VARCHAR2,
23: v_next_id_status OUT NOCOPY BOOLEAN)
24: AS

Line 189: (v_po_no IN PO_ORDR_HDR.PO_NO%TYPE,

185: | |
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;

Line 199: FROM po_ordr_hdr

195:
196: BEGIN
197: SELECT COUNT(*)
198: INTO v_row_count
199: FROM po_ordr_hdr
200: WHERE po_no = v_po_no
201: AND orgn_code = v_orgn_code;
202:
203: IF v_row_count > 0 THEN

Line 1210: update po_ordr_hdr

1206: Close total_lines_cur;
1207:
1208: IF v_total_lines = 1
1209: THEN
1210: update po_ordr_hdr
1211: set po_status = 20,
1212: cancellation_code = p_cancellation_code
1213: where po_id = p_po_id;
1214: ELSE

Line 1230: update po_ordr_hdr

1226: IF v_count > 0 THEN
1227: v_cancellation_code := NULL;
1228: END IF;
1229: END IF;
1230: update po_ordr_hdr
1231: set po_status = 20,
1232: cancellation_code = v_cancellation_code
1233: where po_id = p_po_id;
1234: END IF; /* %FOUND */

Line 1463: v_po_no PO_ORDR_HDR.PO_NO%TYPE;

1459: WHERE po_header_id = v_ordr_header_id
1460: AND po_line_id = v_line_id;
1461:
1462:
1463: v_po_no PO_ORDR_HDR.PO_NO%TYPE;
1464: v_bpo_id PO_ORDR_HDR.BPO_ID%TYPE;
1465: v_bpo_line_id PO_ORDR_DTL.BPO_LINE_ID%TYPE;
1466: v_po_status NUMBER;
1467: v_doc_type VARCHAR2(4);

Line 1464: v_bpo_id PO_ORDR_HDR.BPO_ID%TYPE;

1460: AND po_line_id = v_line_id;
1461:
1462:
1463: v_po_no PO_ORDR_HDR.PO_NO%TYPE;
1464: v_bpo_id PO_ORDR_HDR.BPO_ID%TYPE;
1465: v_bpo_line_id PO_ORDR_DTL.BPO_LINE_ID%TYPE;
1466: v_po_status NUMBER;
1467: v_doc_type VARCHAR2(4);
1468: v_amt_purchased NUMBER;

Line 1488: v_new_po_id PO_ORDR_HDR.PO_ID%TYPE;

1484: v_err_message VARCHAR2(2000);
1485:
1486: /* variables to fetch values of columns*/
1487:
1488: v_new_po_id PO_ORDR_HDR.PO_ID%TYPE;
1489: v_po_id PO_ORDR_HDR.PO_ID%TYPE;
1490: v_line_id PO_ORDR_DTL.LINE_id%TYPE;
1491: v_new_line_id PO_ORDR_DTL.LINE_id%TYPE;
1492: v_line_no PO_ORDR_DTL.LINE_no%TYPE;

Line 1489: v_po_id PO_ORDR_HDR.PO_ID%TYPE;

1485:
1486: /* variables to fetch values of columns*/
1487:
1488: v_new_po_id PO_ORDR_HDR.PO_ID%TYPE;
1489: v_po_id PO_ORDR_HDR.PO_ID%TYPE;
1490: v_line_id PO_ORDR_DTL.LINE_id%TYPE;
1491: v_new_line_id PO_ORDR_DTL.LINE_id%TYPE;
1492: v_line_no PO_ORDR_DTL.LINE_no%TYPE;
1493: v_dtl_line_no PO_ORDR_DTL.LINE_no%TYPE;

Line 1582: CURSOR po_id_cur(v_po_no PO_ORDR_HDR.PO_NO%TYPE,

1578: SELECT terms_code
1579: FROM op_term_mst
1580: WHERE of_terms_code = v_of_terms_code;
1581: /* Liz Enstone 18/AUG/98 Add orgn_code parameter*/
1582: CURSOR po_id_cur(v_po_no PO_ORDR_HDR.PO_NO%TYPE,
1583: v_orgn_code int_rec.orgn_code%TYPE) IS
1584: SELECT po_id
1585: FROM po_ordr_hdr
1586: WHERE po_no = v_po_no

Line 1585: FROM po_ordr_hdr

1581: /* Liz Enstone 18/AUG/98 Add orgn_code parameter*/
1582: CURSOR po_id_cur(v_po_no PO_ORDR_HDR.PO_NO%TYPE,
1583: v_orgn_code int_rec.orgn_code%TYPE) IS
1584: SELECT po_id
1585: FROM po_ordr_hdr
1586: WHERE po_no = v_po_no
1587: AND orgn_code = v_orgn_code;
1588:
1589: CURSOR line_id_cur(v_po_header_id NUMBER, v_po_line_id NUMBER,

Line 2020: INSERT INTO po_ordr_hdr

2016:
2017: /* T. Ricci 5/12/98 removed user_class and changed who */
2018: /* columns for GEMMS 5.0*/
2019: BEGIN
2020: INSERT INTO po_ordr_hdr
2021: ( po_id,
2022: orgn_code,
2023: po_no,
2024: bpo_id,

Line 2153: FND_FILE.PUT_LINE(FND_FILE.LOG,'Error inserting into po_ordr_hdr')

2149: );
2150: EXCEPTION
2151: WHEN OTHERS THEN
2152: FND_FILE.NEW_LINE(FND_FILE.LOG, 1 );
2153: FND_FILE.PUT_LINE(FND_FILE.LOG,'Error inserting into po_ordr_hdr')
2154: ;
2155: FND_FILE.NEW_LINE(FND_FILE.LOG, 1 );
2156: err_num := SQLCODE;
2157: err_msg := SUBSTRB (SQLERRM, 1, 100);

Line 2697: UPDATE po_ordr_hdr

2693:
2694: BEGIN
2695: /* BEGIN BUG#2041468 V. Ajay Kumar */
2696: /* Modified the following update statement by adding 'cancellation_code = NULL' */
2697: UPDATE po_ordr_hdr
2698: SET po_status = 0, cancellation_code = NULL
2699: WHERE po_id = v_po_id;
2700: /* END BUG#2041468 */
2701: EXCEPTION

Line 2704: FND_FILE.PUT_LINE(FND_FILE.LOG,'Error updating status in po_ordr_hdr');

2700: /* END BUG#2041468 */
2701: EXCEPTION
2702: WHEN OTHERS THEN
2703: FND_FILE.NEW_LINE(FND_FILE.LOG, 1 );
2704: FND_FILE.PUT_LINE(FND_FILE.LOG,'Error updating status in po_ordr_hdr');
2705: FND_FILE.NEW_LINE(FND_FILE.LOG, 1 );
2706: err_num := SQLCODE;
2707: err_msg := SUBSTRB (SQLERRM, 1, 100);
2708: FND_FILE.PUT_LINE(FND_FILE.LOG, err_msg);

Line 3049: UPDATE po_ordr_hdr

3045:
3046: /* T. Ricci 5/12/98 changed who columns for GEMMS 5.0*/
3047:
3048: BEGIN
3049: UPDATE po_ordr_hdr
3050: SET payvend_id = nvl(v_pay_vendor_id,0),
3051: shipvend_id = nvl(v_ship_vendor_id,0),
3052: /* HW BUG#:1095846 */
3053: po_status = nvl(v_po_status,0),

Line 3095: FND_FILE.PUT_LINE(FND_FILE.LOG,'Error updating po_ordr_hdr');

3091: WHERE po_id = v_po_id;
3092: EXCEPTION
3093: WHEN OTHERS THEN
3094: FND_FILE.NEW_LINE(FND_FILE.LOG, 1 );
3095: FND_FILE.PUT_LINE(FND_FILE.LOG,'Error updating po_ordr_hdr');
3096: FND_FILE.NEW_LINE(FND_FILE.LOG, 1 );
3097: err_num := SQLCODE;
3098: err_msg := SUBSTRB (SQLERRM, 1, 100);
3099: FND_FILE.PUT_LINE(FND_FILE.LOG, err_msg);

Line 3420: UPDATE po_ordr_hdr

3416: raise_application_error(-20001, err_msg);
3417: END;
3418:
3419: BEGIN
3420: UPDATE po_ordr_hdr
3421: SET revision_count = revision_count + 1,
3422: last_update_date = nvl(int_rec.last_update_date, SYSDATE),
3423: last_updated_by = nvl(int_rec.last_updated_by, 0),
3424: last_update_login = int_rec.last_update_login /* LE 26/AUG/98 NULL OK*/

Line 3430: FND_FILE.PUT_LINE(FND_FILE.LOG,'Error updating po_ordr_hdr');

3426: AND revision_count = 0;
3427: EXCEPTION
3428: WHEN OTHERS THEN
3429: FND_FILE.NEW_LINE(FND_FILE.LOG, 1 );
3430: FND_FILE.PUT_LINE(FND_FILE.LOG,'Error updating po_ordr_hdr');
3431: FND_FILE.NEW_LINE(FND_FILE.LOG, 1 );
3432: err_num := SQLCODE;
3433: err_msg := SUBSTRB (SQLERRM, 1, 100);
3434: FND_FILE.PUT_LINE(FND_FILE.LOG, err_msg);