DBA Data[Home] [Help]

APPS.GML_PO_SYNCH dependencies on PO_ORDR_DTL

Line 74: (line_type IN VARCHAR2,new_line_id OUT NOCOPY PO_ORDR_DTL.LINE_ID%TYPE,

70: | |
71: +============================================================================*/
72:
73: PROCEDURE next_line_id
74: (line_type IN VARCHAR2,new_line_id OUT NOCOPY PO_ORDR_DTL.LINE_ID%TYPE,
75: v_next_id_status OUT NOCOPY BOOLEAN) -- yannamal GSCC b4403407
76: AS
77:
78: /* CURSOR nline_id_cur IS

Line 281: | max(line_no) from po_ordr_dtl.TAR #12693733.6

277: | MODIFICATION HISTORY |
278: | 10/27/97 Kenny Jiang created |
279: | 03/24/00 NC - modified the procedure to accept po_line_id instead of
280: | po_id and return line_num from po_lines all instead of the
281: | max(line_no) from po_ordr_dtl.TAR #12693733.6
282: | (Bug#1249797 base bug#1247332.
283: | 15/05/00 NC - Added code to take care of line numbering for Planned and|
284: | Blanket POS and in case of more than one shipment per |
285: | line.Added new parameters. |

Line 333: FROM po_ordr_dtl

329: WHERE po_line_id = v_po_line_id;
330: ELSE
331: SELECT NVL(MAX(line_no),0) +1
332: INTO v_line_no
333: FROM po_ordr_dtl
334: WHERE po_id = v_po_id;
335: END IF;
336:
337: END IF;

Line 1187: From po_ordr_dtl

1183: Where po_id = p_po_id;
1184:
1185: Cursor get_line_status IS
1186: Select po_status
1187: From po_ordr_dtl
1188: Where po_id = p_po_id
1189: and po_status = 0;
1190:
1191: Cursor get_uncancelled_lines IS

Line 1193: From po_ordr_dtl

1189: and po_status = 0;
1190:
1191: Cursor get_uncancelled_lines IS
1192: Select count(*)
1193: From po_ordr_dtl
1194: Where po_id = p_po_id
1195: and cancellation_code IS NULL;
1196:
1197: v_total_lines NUMBER :=0 ;

Line 1200: v_cancellation_code PO_ORDR_DTL.CANCELLATION_CODE%TYPE := p_cancellation_code;

1196:
1197: v_total_lines NUMBER :=0 ;
1198: v_po_status NUMBER :=0;
1199: v_count NUMBER :=0;
1200: v_cancellation_code PO_ORDR_DTL.CANCELLATION_CODE%TYPE := p_cancellation_code;
1201:
1202: BEGIN
1203:
1204: Open total_lines_cur;

Line 1465: v_bpo_line_id PO_ORDR_DTL.BPO_LINE_ID%TYPE;

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;
1469: v_qty_purchased NUMBER;

Line 1490: v_line_id PO_ORDR_DTL.LINE_id%TYPE;

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

Line 1491: v_new_line_id PO_ORDR_DTL.LINE_id%TYPE;

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;
1494: v_item_id IC_ITEM_MST.ITEM_ID%TYPE;
1495: v_item_um2 IC_ITEM_MST.ITEM_UM2%TYPE;

Line 1492: v_line_no PO_ORDR_DTL.LINE_no%TYPE;

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;
1494: v_item_id IC_ITEM_MST.ITEM_ID%TYPE;
1495: v_item_um2 IC_ITEM_MST.ITEM_UM2%TYPE;
1496: v_item_um1 IC_ITEM_MST.ITEM_UM%TYPE; /* PPB */

Line 1493: v_dtl_line_no PO_ORDR_DTL.LINE_no%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;
1494: v_item_id IC_ITEM_MST.ITEM_ID%TYPE;
1495: v_item_um2 IC_ITEM_MST.ITEM_UM2%TYPE;
1496: v_item_um1 IC_ITEM_MST.ITEM_UM%TYPE; /* PPB */
1497: v_item_desc IC_ITEM_MST.ITEM_DESC1%TYPE;

Line 1505: v_old_order_qty1 PO_ORDR_DTL.ORDER_QTY1%TYPE;

1501: v_frtbill_mthd OP_FRGT_MTH.FRTBILL_MTHD%TYPE;
1502: v_terms_code OP_TERM_MST.TERMS_CODE%TYPE;
1503: v_new_trans_id IC_TRAN_PND.TRANS_ID%TYPE;
1504: v_co_code SY_ORGN_MST.CO_CODE%TYPE;
1505: v_old_order_qty1 PO_ORDR_DTL.ORDER_QTY1%TYPE;
1506: v_old_order_qty2 PO_ORDR_DTL.ORDER_QTY2%TYPE;
1507: v_old_order_um1 PO_ORDR_DTL.ORDER_UM1%TYPE;
1508: v_old_order_um2 PO_ORDR_DTL.ORDER_UM2%TYPE;
1509: v_old_extended_price PO_ORDR_DTL.EXTENDED_PRICE%TYPE;

Line 1506: v_old_order_qty2 PO_ORDR_DTL.ORDER_QTY2%TYPE;

1502: v_terms_code OP_TERM_MST.TERMS_CODE%TYPE;
1503: v_new_trans_id IC_TRAN_PND.TRANS_ID%TYPE;
1504: v_co_code SY_ORGN_MST.CO_CODE%TYPE;
1505: v_old_order_qty1 PO_ORDR_DTL.ORDER_QTY1%TYPE;
1506: v_old_order_qty2 PO_ORDR_DTL.ORDER_QTY2%TYPE;
1507: v_old_order_um1 PO_ORDR_DTL.ORDER_UM1%TYPE;
1508: v_old_order_um2 PO_ORDR_DTL.ORDER_UM2%TYPE;
1509: v_old_extended_price PO_ORDR_DTL.EXTENDED_PRICE%TYPE;
1510: v_acct_map_ind NUMBER DEFAULT 0;

Line 1507: v_old_order_um1 PO_ORDR_DTL.ORDER_UM1%TYPE;

1503: v_new_trans_id IC_TRAN_PND.TRANS_ID%TYPE;
1504: v_co_code SY_ORGN_MST.CO_CODE%TYPE;
1505: v_old_order_qty1 PO_ORDR_DTL.ORDER_QTY1%TYPE;
1506: v_old_order_qty2 PO_ORDR_DTL.ORDER_QTY2%TYPE;
1507: v_old_order_um1 PO_ORDR_DTL.ORDER_UM1%TYPE;
1508: v_old_order_um2 PO_ORDR_DTL.ORDER_UM2%TYPE;
1509: v_old_extended_price PO_ORDR_DTL.EXTENDED_PRICE%TYPE;
1510: v_acct_map_ind NUMBER DEFAULT 0;
1511: v_map_retcode NUMBER DEFAULT 0;

Line 1508: v_old_order_um2 PO_ORDR_DTL.ORDER_UM2%TYPE;

1504: v_co_code SY_ORGN_MST.CO_CODE%TYPE;
1505: v_old_order_qty1 PO_ORDR_DTL.ORDER_QTY1%TYPE;
1506: v_old_order_qty2 PO_ORDR_DTL.ORDER_QTY2%TYPE;
1507: v_old_order_um1 PO_ORDR_DTL.ORDER_UM1%TYPE;
1508: v_old_order_um2 PO_ORDR_DTL.ORDER_UM2%TYPE;
1509: v_old_extended_price PO_ORDR_DTL.EXTENDED_PRICE%TYPE;
1510: v_acct_map_ind NUMBER DEFAULT 0;
1511: v_map_retcode NUMBER DEFAULT 0;
1512: uomcv_item_id NUMBER;

Line 1509: v_old_extended_price PO_ORDR_DTL.EXTENDED_PRICE%TYPE;

1505: v_old_order_qty1 PO_ORDR_DTL.ORDER_QTY1%TYPE;
1506: v_old_order_qty2 PO_ORDR_DTL.ORDER_QTY2%TYPE;
1507: v_old_order_um1 PO_ORDR_DTL.ORDER_UM1%TYPE;
1508: v_old_order_um2 PO_ORDR_DTL.ORDER_UM2%TYPE;
1509: v_old_extended_price PO_ORDR_DTL.EXTENDED_PRICE%TYPE;
1510: v_acct_map_ind NUMBER DEFAULT 0;
1511: v_map_retcode NUMBER DEFAULT 0;
1512: uomcv_item_id NUMBER;
1513:

Line 1517: v_old_po_status PO_ORDR_DTL.PO_STATUS%TYPE;

1513:
1514: /*PPB - Bug# 1365777 */
1515: v_noninv_ind IC_ITEM_MST.NONINV_IND%TYPE;
1516:
1517: v_old_po_status PO_ORDR_DTL.PO_STATUS%TYPE;
1518: v_old_cancellation_code PO_ORDR_DTL.CANCELLATION_CODE%TYPE;
1519:
1520: v_old_order_base_qty PO_ORDR_DTL.ORDER_QTY1%TYPE;
1521: v_old_order_sec_qty PO_ORDR_DTL.ORDER_QTY1%TYPE;

Line 1518: v_old_cancellation_code PO_ORDR_DTL.CANCELLATION_CODE%TYPE;

1514: /*PPB - Bug# 1365777 */
1515: v_noninv_ind IC_ITEM_MST.NONINV_IND%TYPE;
1516:
1517: v_old_po_status PO_ORDR_DTL.PO_STATUS%TYPE;
1518: v_old_cancellation_code PO_ORDR_DTL.CANCELLATION_CODE%TYPE;
1519:
1520: v_old_order_base_qty PO_ORDR_DTL.ORDER_QTY1%TYPE;
1521: v_old_order_sec_qty PO_ORDR_DTL.ORDER_QTY1%TYPE;
1522: v_total_received_qty NUMBER DEFAULT 0;

Line 1520: v_old_order_base_qty PO_ORDR_DTL.ORDER_QTY1%TYPE;

1516:
1517: v_old_po_status PO_ORDR_DTL.PO_STATUS%TYPE;
1518: v_old_cancellation_code PO_ORDR_DTL.CANCELLATION_CODE%TYPE;
1519:
1520: v_old_order_base_qty PO_ORDR_DTL.ORDER_QTY1%TYPE;
1521: v_old_order_sec_qty PO_ORDR_DTL.ORDER_QTY1%TYPE;
1522: v_total_received_qty NUMBER DEFAULT 0;
1523: v_total_received_qty2 NUMBER DEFAULT 0;
1524:

Line 1521: v_old_order_sec_qty PO_ORDR_DTL.ORDER_QTY1%TYPE;

1517: v_old_po_status PO_ORDR_DTL.PO_STATUS%TYPE;
1518: v_old_cancellation_code PO_ORDR_DTL.CANCELLATION_CODE%TYPE;
1519:
1520: v_old_order_base_qty PO_ORDR_DTL.ORDER_QTY1%TYPE;
1521: v_old_order_sec_qty PO_ORDR_DTL.ORDER_QTY1%TYPE;
1522: v_total_received_qty NUMBER DEFAULT 0;
1523: v_total_received_qty2 NUMBER DEFAULT 0;
1524:
1525: /* BEGIN - BUG 1785704 */

Line 1609: FROM po_ordr_dtl

1605: WHERE orgn_code = v_orgn_code;
1606:
1607: CURSOR order_qty_price_cur(v_po_id NUMBER, v_line_id NUMBER) IS
1608: SELECT order_qty1, order_qty2,order_um1,order_um2, extended_price, line_no
1609: FROM po_ordr_dtl
1610: WHERE po_id = v_po_id
1611: AND line_id = v_line_id;
1612:
1613: CURSOR Old_po_line_status_cur(v_po_id NUMBER, v_line_id NUMBER) IS

Line 1615: FROM po_ordr_dtl

1611: AND line_id = v_line_id;
1612:
1613: CURSOR Old_po_line_status_cur(v_po_id NUMBER, v_line_id NUMBER) IS
1614: SELECT po_status,cancellation_code
1615: FROM po_ordr_dtl
1616: WHERE po_id = v_po_id
1617: AND line_id = v_line_id;
1618:
1619:

Line 1654: FROM po_ordr_dtl

1650: /* Begin B2043468 */
1651:
1652: CURSOR opm_po_line_dtl(v_po_id NUMBER, v_line_id NUMBER) IS
1653: SELECT order_qty1,received_qty1
1654: FROM po_ordr_dtl
1655: WHERE po_id = v_po_id
1656: AND line_id = v_line_id;
1657:
1658: rec_opm_po_line_dtl opm_po_line_dtl%ROWTYPE;

Line 1672: from po_ordr_dtl

1668:
1669: /* Begin B2594000 */
1670: cursor check_dup is
1671: select 1
1672: from po_ordr_dtl
1673: where po_id = v_po_id
1674: and line_no = v_line_no;
1675:
1676: v_check NUMBER := 0;

Line 2275: INSERT INTO po_ordr_dtl

2271: /* End B2594000 */
2272:
2273: IF error_ind = 0 THEN /* B2594000 */
2274: BEGIN
2275: INSERT INTO po_ordr_dtl
2276: ( po_id,
2277: line_no,
2278: line_id,
2279: bpo_line_id,

Line 2412: FND_FILE.PUT_LINE(FND_FILE.LOG,'Error inserting into po_ordr_dtl');

2408: );
2409: EXCEPTION
2410: WHEN OTHERS THEN
2411: FND_FILE.NEW_LINE(FND_FILE.LOG, 1 );
2412: FND_FILE.PUT_LINE(FND_FILE.LOG,'Error inserting into po_ordr_dtl');
2413: FND_FILE.NEW_LINE(FND_FILE.LOG, 1 );
2414: err_num := SQLCODE;
2415: err_msg := SUBSTRB (SQLERRM, 1, 100);
2416: FND_FILE.PUT_LINE(FND_FILE.LOG, err_msg);

Line 2825: UPDATE po_ordr_dtl

2821: /* for closing, cancellation_code = ' '*/
2822: /* T. Ricci 5/12/98 changed who columns for GEMMS 5.0*/
2823: /* T. Ricci 11/10/98 removed trans_cnt = trans_cnt + 1 from update*/
2824:
2825: UPDATE po_ordr_dtl
2826: SET po_status = 20,
2827: cancellation_code = int_rec.cancellation_code,
2828: last_update_date = nvl(int_rec.last_update_date, SYSDATE),
2829: last_updated_by = nvl(int_rec.last_updated_by, 0),

Line 2868: UPDATE po_ordr_dtl

2864: rec_item_dtl.item_um2,0);
2865: ELSE
2866: v_order2 := 0;
2867: END IF;
2868: UPDATE po_ordr_dtl
2869: SET order_qty1 = int_rec.order_qty1, order_qty2 = v_order2
2870: WHERE po_id = v_po_id
2871: AND line_id = v_line_id;
2872: END IF;

Line 3158: UPDATE po_ordr_dtl

3154: /* T. Ricci 11/10/98 removed trans_cnt = trans_cnt + 1 from update*/
3155: /* T. Ricci 12/01/98 removed line_no from update*/
3156:
3157: BEGIN
3158: UPDATE po_ordr_dtl
3159: SET item_id = v_item_id,
3160: item_desc = nvl(v_item_desc, ' '),
3161: order_qty1 = nvl(int_rec.order_qty1,0),
3162: /* LE 26/AUG/98 NULL OK*/

Line 3215: FND_FILE.PUT_LINE(FND_FILE.LOG,'Error updating po_ordr_dtl');

3211: AND line_id = v_line_id;
3212: EXCEPTION
3213: WHEN OTHERS THEN
3214: FND_FILE.NEW_LINE(FND_FILE.LOG, 1 );
3215: FND_FILE.PUT_LINE(FND_FILE.LOG,'Error updating po_ordr_dtl');
3216: FND_FILE.NEW_LINE(FND_FILE.LOG, 1 );
3217: err_num := SQLCODE;
3218: err_msg := SUBSTRB (SQLERRM, 1, 100);
3219: FND_FILE.PUT_LINE(FND_FILE.LOG, err_msg);

Line 3579: UPDATE po_ordr_dtl /* For standard, blanket and PPOs */

3575: END IF;
3576:
3577: IF error_ind = 0 THEN /* B2594000 */
3578: BEGIN
3579: UPDATE po_ordr_dtl /* For standard, blanket and PPOs */
3580: SET acct_map_ind = v_acct_map_ind,
3581: last_update_date = nvl(v_last_update_date, SYSDATE),/* lswamy - BUG 1829102 */
3582: last_updated_by = nvl(v_last_updated_by, 0), /* lswamy - BUG 1829102 */
3583: last_update_login = int_rec.last_update_login /* LE 26/AUG/98 NULL OK*/

Line 3588: FND_FILE.PUT_LINE(FND_FILE.LOG,'Error updating po_ordr_dtl');

3584: WHERE po_id = v_po_id;
3585: EXCEPTION
3586: WHEN OTHERS THEN
3587: FND_FILE.NEW_LINE(FND_FILE.LOG, 1 );
3588: FND_FILE.PUT_LINE(FND_FILE.LOG,'Error updating po_ordr_dtl');
3589: FND_FILE.NEW_LINE(FND_FILE.LOG, 1 );
3590: err_num := SQLCODE;
3591: err_msg := SUBSTRB (SQLERRM, 1, 100);
3592: FND_FILE.PUT_LINE(FND_FILE.LOG, err_msg);

Line 3610: SET invalid_ind = 'E' /* This line can not be inserted in po_ordr_dtl */

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:
3614: END IF; /* if gemms_validate is true*/