eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.DPP_CLAIMS_PVT dependencies on DPP_TRANSACTION_CLAIMS_ALL

Line 49: UPDATE dpp_transaction_claims_all

45: WHERE EXECUTION_DETAIL_ID = p_txn_hdr_rec.Execution_Detail_ID
46: AND transaction_header_id = p_txn_hdr_rec.Transaction_Header_ID;
47: --In case of updtate flow
48: IF p_status = 'WARNING' AND p_api_name = 'Update_Claims' THEN
49: UPDATE dpp_transaction_claims_all
50: SET approved_by_supplier = 'N',
51: OBJECT_VERSION_NUMBER = OBJECT_VERSION_NUMBER +1,
52: last_updated_by = p_txn_hdr_rec.LAST_UPDATED_BY,
53: last_update_date = sysdate,

Line 536: --Insert the claim id into the dpp_transaction_claims_all table

532: --Get the claim number corresponding to the claim id
533: FOR get_claim_number_rec IN get_claim_number_csr(l_x_claim_id) LOOP
534: l_claim_number := get_claim_number_rec.claim_number;
535: END LOOP;
536: --Insert the claim id into the dpp_transaction_claims_all table
537: BEGIN
538: --Derive the claim type based on the change type i.e. price increase or price decrease
539: IF l_price_increase_flag = 'Y' THEN
540: l_claim_type := 'SUPP_DSTR_INC_CL';

Line 544: INSERT INTO dpp_transaction_claims_all(CLAIM_ID,

540: l_claim_type := 'SUPP_DSTR_INC_CL';
541: ELSIF l_price_increase_flag = 'N' THEN
542: l_claim_type := 'SUPP_DSTR_CL';
543: END IF;
544: INSERT INTO dpp_transaction_claims_all(CLAIM_ID,
545: TRANSACTION_HEADER_ID,
546: OBJECT_VERSION_NUMBER,
547: CLAIM_TYPE,
548: CREATION_DATE,

Line 833: --Insert the claim id into the dpp_transaction_claims_all table

829: --Get the claim number corresponding to the claim id
830: FOR get_claim_number_rec IN get_claim_number_csr(l_x_claim_id) LOOP
831: l_claim_number := get_claim_number_rec.claim_number;
832: END LOOP;
833: --Insert the claim id into the dpp_transaction_claims_all table
834: BEGIN
835: INSERT INTO dpp_transaction_claims_all(CLAIM_ID,
836: TRANSACTION_HEADER_ID,
837: OBJECT_VERSION_NUMBER,

Line 835: INSERT INTO dpp_transaction_claims_all(CLAIM_ID,

831: l_claim_number := get_claim_number_rec.claim_number;
832: END LOOP;
833: --Insert the claim id into the dpp_transaction_claims_all table
834: BEGIN
835: INSERT INTO dpp_transaction_claims_all(CLAIM_ID,
836: TRANSACTION_HEADER_ID,
837: OBJECT_VERSION_NUMBER,
838: CLAIM_TYPE,
839: CREATION_DATE,

Line 1045: --Insert the claim id into the dpp_transaction_claims_all table

1041: --Get the claim number corresponding to the claim id
1042: FOR get_claim_number_rec IN get_claim_number_csr(l_x_claim_id) LOOP
1043: l_claim_number := get_claim_number_rec.claim_number;
1044: END LOOP;
1045: --Insert the claim id into the dpp_transaction_claims_all table
1046: BEGIN
1047: INSERT INTO dpp_transaction_claims_all(CLAIM_ID,
1048: TRANSACTION_HEADER_ID,
1049: OBJECT_VERSION_NUMBER,

Line 1047: INSERT INTO dpp_transaction_claims_all(CLAIM_ID,

1043: l_claim_number := get_claim_number_rec.claim_number;
1044: END LOOP;
1045: --Insert the claim id into the dpp_transaction_claims_all table
1046: BEGIN
1047: INSERT INTO dpp_transaction_claims_all(CLAIM_ID,
1048: TRANSACTION_HEADER_ID,
1049: OBJECT_VERSION_NUMBER,
1050: CLAIM_TYPE,
1051: CREATION_DATE,