APPS.DPP_TRANSACTION_PVT dependencies on DPP_TXN_HEADERS_INT_ALL

Line 53: UPDATE DPP_TXN_HEADERS_INT_ALL dtha

49: FND_FILE.PUT_LINE(FND_FILE.LOG,' Begin Update InterfaceErrSts');
50: END IF;
51:
52: --Update Interface Header table with error status
53: UPDATE DPP_TXN_HEADERS_INT_ALL dtha
54: SET
55: dtha.last_update_date = SYSDATE,
56: dtha.last_updated_by = nvl(l_user_id,0),
57: dtha.last_update_login = nvl(l_user_id,0),

Line 503: FROM dpp_txn_headers_int_all dthia,

499: BEGIN
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

Line 521: FROM dpp_txn_headers_int_all dthia,

517: IF l_duplicate_lines < 2 OR l_duplicate_lines IS NULL THEN
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

Line 539: FROM dpp_txn_headers_int_all dthia,

535: IF l_duplicate_lines < 2 OR l_duplicate_lines IS NULL THEN
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

Line 2806: UPDATE DPP_TXN_HEADERS_INT_ALL dtha

2802: IF DPP_DEBUG_HIGH_ON THEN
2803: FND_FILE.PUT_LINE(FND_FILE.LOG,' Begin Update InterfaceTbl');
2804: END IF;
2805: --Update Interface Header table
2806: UPDATE DPP_TXN_HEADERS_INT_ALL dtha
2807: SET
2808: dtha.org_id = p_txn_header_rec_type.org_id,
2809: dtha.vendor_id = p_txn_header_rec_type.vendor_id,
2810: dtha.vendor_site_id = p_txn_header_rec_type.vendor_site_id,

Line 2873: UPDATE DPP_TXN_HEADERS_INT_ALL dtha

2869: FND_FILE.PUT_LINE(FND_FILE.LOG,' Begin Update InterfaceErrSts');
2870: END IF;
2871:
2872: --Update Interface Header table with error status
2873: UPDATE DPP_TXN_HEADERS_INT_ALL dtha
2874: SET
2875: dtha.last_update_date = SYSDATE,
2876: dtha.last_updated_by = nvl(l_user_id,0),
2877: dtha.last_update_login = nvl(l_user_id,0),

Line 2965: FROM dpp_txn_headers_int_all dthia

2961:
2962: --Cursor to fetch header information from interface table
2963: CURSOR fetch_header_cur IS
2964: SELECT *
2965: FROM dpp_txn_headers_int_all dthia
2966: WHERE dthia.transaction_int_header_id = p_transaction_int_header_id;
2967:
2968: BEGIN
2969: -- Standard begin of API savepoint

Line 3001: --fetch records from dpp_txn_headers_int_all table

2997: IF DPP_DEBUG_HIGH_ON THEN
2998: fnd_file.put_line(fnd_file.log, 'Audit Enabled '||l_log_enabled );
2999: END IF;
3000:
3001: --fetch records from dpp_txn_headers_int_all table
3002: FOR fetch_header_rec IN fetch_header_cur
3003: LOOP
3004: --check whether it is an inbound transaction or pre approval transaction by checking Approved by column
3005: IF fetch_header_rec.supplier_approved_by IS NULL THEN

Line 3774: FROM dpp_txn_headers_int_all dtha

3770: -- Checks for the doc reference number for same vendor id in header table*/
3771: BEGIN
3772: SELECT transaction_int_header_id
3773: INTO l_transaction_int_header_id
3774: FROM dpp_txn_headers_int_all dtha
3775: WHERE dtha.ref_document_number = p_txn_header_rec_type.ref_document_number
3776: AND dtha.vendor_name = p_txn_header_rec_type.vendor_name
3777: AND dtha.vendor_site = p_txn_header_rec_type.vendor_site_code
3778: AND dtha.interface_status = 'N';

Line 3790: INSERT INTO dpp_txn_headers_int_all

3786: SELECT dpp_trans_int_hdr_id_seq.nextval
3787: INTO p_txn_header_rec_type.transaction_int_header_id
3788: FROM dual;
3789:
3790: INSERT INTO dpp_txn_headers_int_all
3791: (transaction_int_header_id,
3792: ref_document_number,
3793: effective_start_date,
3794: days_covered,

Line 3917: UPDATE dpp_txn_headers_int_all

3913: p_txn_header_rec_type.attribute30);
3914:
3915: ELSE
3916:
3917: UPDATE dpp_txn_headers_int_all
3918: SET
3919: ref_document_number = p_txn_header_rec_type.ref_document_number,
3920: effective_start_date = p_txn_header_rec_type.effective_start_date,
3921: days_covered = p_txn_header_rec_type.days_covered,

Line 4504: FROM dpp_txn_headers_int_all dthia

4500:
4501: CURSOR transaction_cur(cv_doc_ref_no VARCHAR2, cv_supplier_name VARCHAR2, cv_supplier_site VARCHAR2, cv_operating_unit VARCHAR2 )
4502: IS
4503: SELECT transaction_int_header_id
4504: FROM dpp_txn_headers_int_all dthia
4505: WHERE dthia.ref_document_number = cv_doc_ref_no
4506: AND dthia.vendor_name = cv_supplier_name
4507: AND dthia.vendor_site = cv_supplier_site
4508: AND dthia.interface_status = 'N'

Line 5037: FROM dpp_txn_headers_int_all dtha ,

5033: CURSOR transaction_cur(cv_doc_ref_no VARCHAR2, cv_supplier_name VARCHAR2,cv_supplier_id VARCHAR2,
5034: cv_supplier_site VARCHAR2,cv_supplier_site_id VARCHAR2,cv_operating_unit VARCHAR2,cv_org_id VARCHAR2 )
5035: IS
5036: SELECT transaction_int_header_id
5037: FROM dpp_txn_headers_int_all dtha ,
5038: hr_operating_units hr
5039: WHERE dtha.interface_status = 'N'
5040: AND nvl(dtha.ref_document_number, -1) = nvl(cv_doc_ref_no,nvl(dtha.ref_document_number,-1))
5041: AND (dtha.vendor_name = cv_supplier_name OR

Line 5125: UPDATE dpp_txn_headers_int_all dtha

5121: IF DPP_DEBUG_HIGH_ON THEN
5122: fnd_file.put_line(fnd_file.log, 'Call Insert Transaction p_transaction_int_header_id:'||transaction_rec.transaction_int_header_id);
5123: END IF;
5124: BEGIN
5125: UPDATE dpp_txn_headers_int_all dtha
5126: SET dtha.program_id = l_program_id,
5127: dtha.program_application_id = l_prog_app_id,
5128: dtha.request_id = l_request_id,
5129: dtha.program_update_date = sysdate