APPS.DPP_TRANSACTION_PVT dependencies on DPP_TXN_LINES_INT_ALL

Line 504: dpp_txn_lines_int_all dtlia

500: BEGIN
501: SELECT COUNT(dtlia.supplier_part_num)
502: INTO l_duplicate_lines
503: FROM dpp_txn_headers_int_all dthia,
504: dpp_txn_lines_int_all dtlia
505: WHERE dthia.transaction_int_header_id = dtlia.transaction_int_header_id
506: AND dthia.transaction_int_header_id = p_txn_header_rec_type.transaction_int_header_id
507: GROUP BY dtlia.supplier_part_num
508: HAVING COUNT(dtlia.supplier_part_num) > 1;

Line 522: dpp_txn_lines_int_all dtlia

518: BEGIN
519: SELECT COUNT(dtlia.item_number)
520: INTO l_duplicate_lines
521: FROM dpp_txn_headers_int_all dthia,
522: dpp_txn_lines_int_all dtlia
523: WHERE dthia.transaction_int_header_id = dtlia.transaction_int_header_id
524: AND dthia.transaction_int_header_id = p_txn_header_rec_type.transaction_int_header_id
525: GROUP BY dtlia.item_number
526: HAVING COUNT(dtlia.item_number) > 1;

Line 540: dpp_txn_lines_int_all dtlia

536: BEGIN
537: SELECT COUNT(dtlia.inventory_item_id)
538: INTO l_duplicate_lines
539: FROM dpp_txn_headers_int_all dthia,
540: dpp_txn_lines_int_all dtlia
541: WHERE dthia.transaction_int_header_id = dtlia.transaction_int_header_id
542: AND dthia.transaction_int_header_id = p_txn_header_rec_type.transaction_int_header_id
543: GROUP BY dtlia.inventory_item_id
544: HAVING COUNT(dtlia.inventory_item_id) > 1;

Line 590: dpp_txn_lines_int_all dtla WHERE

586: );
587: END;
588: BEGIN
589: SELECT 1 INTO l_lines FROM
590: dpp_txn_lines_int_all dtla WHERE
591: dtla.transaction_int_header_id = p_txn_header_rec_type.transaction_int_header_id;
592: EXCEPTION
593: WHEN NO_DATA_FOUND THEN
594: fnd_message.set_name('DPP', 'DPP_TXN_NO_LINES');

Line 2423: FROM dpp_txn_lines_int_all

2419:
2420: --Cursor to fetch line information from interface table
2421: CURSOR fetch_lines_cur(p_transaction_id NUMBER) IS
2422: SELECT *
2423: FROM dpp_txn_lines_int_all
2424: WHERE transaction_int_header_id = p_transaction_id
2425: order by transaction_int_line_id;
2426:
2427: BEGIN

Line 2436: --fetch records from dpp_txn_lines_int_all table for the selected header.

2432: END IF;
2433:
2434:
2435: l_line_number := 0;
2436: --fetch records from dpp_txn_lines_int_all table for the selected header.
2437: FOR fetch_lines_rec IN fetch_lines_cur(p_txn_header_rec_type.transaction_int_header_id)
2438: LOOP
2439: IF p_txn_header_rec_type.org_id <> nvl(fetch_lines_rec.org_id,p_txn_header_rec_type.org_id) THEN
2440: x_return_status := fnd_api.g_ret_sts_error;

Line 2821: UPDATE DPP_TXN_LINES_INT_ALL dtla

2817:
2818: --Update interface lines table
2819: FOR i in p_txn_lines_tbl_type.FIRST..p_txn_lines_tbl_type.LAST
2820: LOOP
2821: UPDATE DPP_TXN_LINES_INT_ALL dtla
2822: SET
2823: dtla.supplier_part_num = p_txn_lines_tbl_type(i).supplier_part_num,
2824: dtla.inventory_item_id = p_txn_lines_tbl_type(i).inventory_item_id,
2825: dtla.item_number = p_txn_lines_tbl_type(i).item_number,

Line 2885: UPDATE DPP_TXN_LINES_INT_ALL dtla

2881:
2882: --Update interface lines table with error status for all the lines of the error header.
2883: FOR i in p_txn_lines_tbl_type.FIRST..p_txn_lines_tbl_type.LAST
2884: LOOP
2885: UPDATE DPP_TXN_LINES_INT_ALL dtla
2886: SET
2887: dtla.last_update_date = SYSDATE,
2888: dtla.last_updated_by = nvl(l_user_id,0),
2889: dtla.last_update_login = nvl(l_user_id,0),

Line 3996: INSERT INTO dpp_txn_lines_int_all(

3992: INTO p_transaction_lines_rec.transaction_int_line_id
3993: FROM dual;
3994:
3995:
3996: INSERT INTO dpp_txn_lines_int_all(
3997: transaction_int_header_id,
3998: transaction_int_line_id,
3999: supplier_part_num,
4000: inventory_item_id,

Line 5132: UPDATE dpp_txn_lines_int_all dtla

5128: dtha.request_id = l_request_id,
5129: dtha.program_update_date = sysdate
5130: WHERE dtha.transaction_int_header_id = transaction_rec.transaction_int_header_id;
5131:
5132: UPDATE dpp_txn_lines_int_all dtla
5133: SET dtla.program_id = l_program_id,
5134: dtla.program_application_id = l_prog_app_id,
5135: dtla.request_id = l_request_id,
5136: dtla.program_update_date = sysdate