APPS.GML_SYNCH_BPOS dependencies on PO_BPOS_DTL

Line 181: | of the max(line_no) from po_bpos_dtl. Bug#1246767. |

177: | |
178: | 26-OCT-97 R Chellam Created |
179: | 20-NOV-97 R Chellam Modified to deal only with PPOs |
180: | 25-APR-00 N Chekuri Changed to return line_num from po_lines_all instead|
181: | of the max(line_no) from po_bpos_dtl. Bug#1246767. |
182: | Changed parameter accordingly.
183: | 15-MAY-00 N Chekuri Added logic to take care of more than one shipment |
184: | line per PO line. Added parameters.
185: |-----------------------------------------------------------------------------*/

Line 221: FROM po_bpos_dtl

217: WHERE po_line_id = v_po_line_id;
218: ELSE
219: SELECT NVL(MAX(line_no),0) +1
220: INTO v_bpo_line_no
221: FROM po_bpos_dtl
222: WHERE bpo_id = v_bpo_id;
223: END IF;
224:
225: RETURN v_bpo_line_no;

Line 341: v_bpo_line_id PO_BPOS_DTL.LINE_ID%TYPE;

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:
345: v_item_id IC_ITEM_MST.ITEM_ID%TYPE;

Line 342: v_new_line_id PO_BPOS_DTL.LINE_ID%TYPE;

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:
345: v_item_id IC_ITEM_MST.ITEM_ID%TYPE;
346: v_item_um2 IC_ITEM_MST.ITEM_UM%TYPE;

Line 343: v_bpo_line_no PO_BPOS_DTL.LINE_NO%TYPE;

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:
345: v_item_id IC_ITEM_MST.ITEM_ID%TYPE;
346: v_item_um2 IC_ITEM_MST.ITEM_UM%TYPE;
347: v_item_dualum_ind IC_ITEM_MST.DUALUM_IND%TYPE;

Line 640: INSERT INTO po_bpos_dtl

636:
637: /* T.Ricci 5/12/98 removed user_class and added new who columns*/
638:
639: BEGIN
640: INSERT INTO po_bpos_dtl
641: (
642: bpo_id,
643: line_no,
644: line_id,

Line 734: FND_FILE.PUT_LINE(FND_FILE.LOG,'Error inserting into po_bpos_dtl');

730: );
731: EXCEPTION
732: WHEN OTHERS THEN
733: FND_FILE.NEW_LINE(FND_FILE.LOG, 1 );
734: FND_FILE.PUT_LINE(FND_FILE.LOG,'Error inserting into po_bpos_dtl');
735: FND_FILE.NEW_LINE(FND_FILE.LOG, 1 );
736: err_num := SQLCODE;
737: err_msg := SUBSTRB (SQLERRM, 1, 100);
738: FND_FILE.PUT_LINE(FND_FILE.LOG, err_msg);

Line 882: UPDATE po_bpos_dtl

878: raise_application_error(-20001, err_msg);
879: END;
880:
881: BEGIN
882: UPDATE po_bpos_dtl
883: SET item_id = nvl(v_item_id, 0),
884: generic_id = int_rec.generic_id, /* KYH nullable */
885: item_desc = nvl(v_item_desc,' '),
886: contract_value = int_rec.contract_value,/* KYH nullable*/

Line 926: FND_FILE.PUT_LINE(FND_FILE.LOG,'Error updating po_bpos_dtl');

922: AND line_id = v_bpo_line_id;
923: EXCEPTION
924: WHEN OTHERS THEN
925: FND_FILE.NEW_LINE(FND_FILE.LOG, 1 );
926: FND_FILE.PUT_LINE(FND_FILE.LOG,'Error updating po_bpos_dtl');
927: FND_FILE.NEW_LINE(FND_FILE.LOG, 1 );
928: err_num := SQLCODE;
929: err_msg := SUBSTRB (SQLERRM, 1, 100);
930: FND_FILE.PUT_LINE(FND_FILE.LOG, err_msg);

Line 976: UPDATE po_bpos_dtl

972: /*for closing cancellation_code = ' ' */
973: IF int_rec.po_status IN ('CLOSED', 'CLOSED FOR RECEIVING',
974: 'CLOSED FOR INVOICE', 'FINALLY CLOSED') THEN
975:
976: UPDATE po_bpos_dtl
977: SET bpo_status = v_po_status, /*20, */
978: cancellation_code = int_rec.cancellation_code,
979: trans_cnt = trans_cnt + 1
980: WHERE bpo_id = v_bpo_id