APPS.GML_SYNCH_BPOS dependencies on PO_BPOS_HDR

Line 20: PROCEDURE next_bpo_id ( new_bpo_id OUT NOCOPY PO_BPOS_HDR.BPO_ID%TYPE,

16: | 14-MAY-98 T Ricci replaced sy_surg_ctl with nextval from |
17: | sys.dual for GEMMS 5.0 |
18: +----------------------------------------------------------------------------*/
19:
20: PROCEDURE next_bpo_id ( new_bpo_id OUT NOCOPY PO_BPOS_HDR.BPO_ID%TYPE,
21: p_orgn_code IN SY_ORGN_MST.ORGN_CODE%TYPE,
22: v_next_id_status OUT NOCOPY BOOLEAN)
23: IS
24:

Line 82: ( v_bpo_no IN PO_BPOS_HDR.BPO_NO%TYPE)

78: +-----------------------------------------------------------------------------*/
79:
80:
81: FUNCTION bpo_exist
82: ( v_bpo_no IN PO_BPOS_HDR.BPO_NO%TYPE)
83: RETURN BOOLEAN
84: IS
85:
86: v_row_count NUMBER :=0;

Line 91: FROM po_bpos_hdr

87: err_msg VARCHAR2(100);
88:
89: CURSOR row_count1_cur IS
90: SELECT COUNT(*)
91: FROM po_bpos_hdr
92: WHERE bpo_no = v_bpo_no;
93:
94: BEGIN
95: OPEN row_count1_cur;

Line 303: CURSOR bpo_id_cur (p_bpo_no PO_BPOS_HDR.BPO_NO%TYPE) IS

299: WHERE of_terms_code = p_of_terms_code;
300:
301: /* Cursor to select bpo_id */
302:
303: CURSOR bpo_id_cur (p_bpo_no PO_BPOS_HDR.BPO_NO%TYPE) IS
304: SELECT bpo_id
305: FROM po_bpos_hdr
306: WHERE bpo_no = p_bpo_no;
307:

Line 305: FROM po_bpos_hdr

301: /* Cursor to select bpo_id */
302:
303: CURSOR bpo_id_cur (p_bpo_no PO_BPOS_HDR.BPO_NO%TYPE) IS
304: SELECT bpo_id
305: FROM po_bpos_hdr
306: WHERE bpo_no = p_bpo_no;
307:
308: /* Cursor to select bpo_line_id */
309:

Line 339: v_new_bpo_id PO_BPOS_HDR.BPO_ID%TYPE;

335:
336: v_po_status NUMBER;
337: v_order2 NUMBER;
338:
339: v_new_bpo_id PO_BPOS_HDR.BPO_ID%TYPE;
340: v_bpo_id PO_BPOS_HDR.BPO_ID%TYPE;
341: v_bpo_line_id PO_BPOS_DTL.LINE_ID%TYPE;
342: v_new_line_id PO_BPOS_DTL.LINE_ID%TYPE;
343: v_bpo_line_no PO_BPOS_DTL.LINE_NO%TYPE;

Line 340: v_bpo_id PO_BPOS_HDR.BPO_ID%TYPE;

336: v_po_status NUMBER;
337: v_order2 NUMBER;
338:
339: v_new_bpo_id PO_BPOS_HDR.BPO_ID%TYPE;
340: v_bpo_id PO_BPOS_HDR.BPO_ID%TYPE;
341: v_bpo_line_id PO_BPOS_DTL.LINE_ID%TYPE;
342: v_new_line_id PO_BPOS_DTL.LINE_ID%TYPE;
343: v_bpo_line_no PO_BPOS_DTL.LINE_NO%TYPE;
344:

Line 478: INSERT INTO po_bpos_hdr

474:
475: /* T.Ricci 5/11/98 removed user_class and added new who columns*/
476:
477: BEGIN
478: INSERT INTO po_bpos_hdr
479: (
480: bpo_id,
481: orgn_code,
482: bpo_no,

Line 571: FND_FILE.PUT_LINE(FND_FILE.LOG,'Error inserting into po_bpos_hdr');

567: );
568: EXCEPTION
569: WHEN OTHERS THEN
570: FND_FILE.NEW_LINE(FND_FILE.LOG, 1 );
571: FND_FILE.PUT_LINE(FND_FILE.LOG,'Error inserting into po_bpos_hdr');
572: FND_FILE.NEW_LINE(FND_FILE.LOG, 1 );
573: err_num := SQLCODE;
574: err_msg := SUBSTRB (SQLERRM, 1, 100);
575: FND_FILE.PUT_LINE(FND_FILE.LOG, err_msg);

Line 830: UPDATE po_bpos_hdr

826:
827: /*Updates including closed/cancel*/
828:
829: BEGIN
830: UPDATE po_bpos_hdr
831: SET payvend_id = nvl(v_pay_vendor_id,0),
832: contract_no = int_rec.contract_no, /*KYH nullable*/
833: contract_value = int_rec.contract_value,/*KYH nullable*/
834: contract_currency = nvl(int_rec.billing_currency,'USD'),

Line 872: FND_FILE.PUT_LINE(FND_FILE.LOG,'Error updating po_bpos_hdr');

868: WHERE bpo_id = v_bpo_id;
869: EXCEPTION
870: WHEN OTHERS THEN
871: FND_FILE.NEW_LINE(FND_FILE.LOG, 1 );
872: FND_FILE.PUT_LINE(FND_FILE.LOG,'Error updating po_bpos_hdr');
873: FND_FILE.NEW_LINE(FND_FILE.LOG, 1 );
874: err_num := SQLCODE;
875: err_msg := SUBSTRB (SQLERRM, 1, 100);
876: FND_FILE.PUT_LINE(FND_FILE.LOG, err_msg);