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 545: --Insert the claim id into the dpp_transaction_claims_all table

541: --Get the claim number corresponding to the claim id
542: FOR get_claim_number_rec IN get_claim_number_csr(l_x_claim_id) LOOP
543: l_claim_number := get_claim_number_rec.claim_number;
544: END LOOP;
545: --Insert the claim id into the dpp_transaction_claims_all table
546: BEGIN
547: --Derive the claim type based on the change type i.e. price increase or price decrease
548: IF l_price_increase_flag = 'Y' THEN
549: l_claim_type := 'SUPP_DSTR_INC_CL';

Line 553: INSERT INTO dpp_transaction_claims_all(CLAIM_ID,

549: l_claim_type := 'SUPP_DSTR_INC_CL';
550: ELSIF l_price_increase_flag = 'N' THEN
551: l_claim_type := 'SUPP_DSTR_CL';
552: END IF;
553: INSERT INTO dpp_transaction_claims_all(CLAIM_ID,
554: TRANSACTION_HEADER_ID,
555: OBJECT_VERSION_NUMBER,
556: CLAIM_TYPE,
557: CREATION_DATE,

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

843: --Get the claim number corresponding to the claim id
844: FOR get_claim_number_rec IN get_claim_number_csr(l_x_claim_id) LOOP
845: l_claim_number := get_claim_number_rec.claim_number;
846: END LOOP;
847: --Insert the claim id into the dpp_transaction_claims_all table
848: BEGIN
849: INSERT INTO dpp_transaction_claims_all(CLAIM_ID,
850: TRANSACTION_HEADER_ID,
851: OBJECT_VERSION_NUMBER,

Line 849: INSERT INTO dpp_transaction_claims_all(CLAIM_ID,

845: l_claim_number := get_claim_number_rec.claim_number;
846: END LOOP;
847: --Insert the claim id into the dpp_transaction_claims_all table
848: BEGIN
849: INSERT INTO dpp_transaction_claims_all(CLAIM_ID,
850: TRANSACTION_HEADER_ID,
851: OBJECT_VERSION_NUMBER,
852: CLAIM_TYPE,
853: CREATION_DATE,

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

1057: --Get the claim number corresponding to the claim id
1058: FOR get_claim_number_rec IN get_claim_number_csr(l_x_claim_id) LOOP
1059: l_claim_number := get_claim_number_rec.claim_number;
1060: END LOOP;
1061: --Insert the claim id into the dpp_transaction_claims_all table
1062: BEGIN
1063: INSERT INTO dpp_transaction_claims_all(CLAIM_ID,
1064: TRANSACTION_HEADER_ID,
1065: OBJECT_VERSION_NUMBER,

Line 1063: INSERT INTO dpp_transaction_claims_all(CLAIM_ID,

1059: l_claim_number := get_claim_number_rec.claim_number;
1060: END LOOP;
1061: --Insert the claim id into the dpp_transaction_claims_all table
1062: BEGIN
1063: INSERT INTO dpp_transaction_claims_all(CLAIM_ID,
1064: TRANSACTION_HEADER_ID,
1065: OBJECT_VERSION_NUMBER,
1066: CLAIM_TYPE,
1067: CREATION_DATE,