APPS.DPP_BUSINESSEVENTS_PVT dependencies on DPP_CUSTOMER_CLAIMS_ALL

Line 257: FROM dpp_customer_claims_all

253: INSERT INTO DPP_TRANSACTION_LINES_GT(transaction_header_id,
254: transaction_line_id)
255: SELECT transaction_header_id,
256: customer_inv_line_id
257: FROM dpp_customer_claims_all
258: WHERE transaction_header_id = p_txn_hdr_rec.Transaction_Header_ID;
259: EXCEPTION
260: WHEN OTHERS THEN
261: fnd_message.set_name('FND', 'SQL_PLSQL_ERROR');

Line 965: FROM DPP_customer_claims_all dcc,

961: dcc.supp_claim_amt CLAIM_LINE_AMOUNT,
962: dcc.reported_inventory claim_quantity,
963: dcc.trx_currency currency,
964: dcc.UOM
965: FROM DPP_customer_claims_all dcc,
966: DPP_TRANSACTION_LINES_GT dtg
967: WHERE headers.Transaction_header_id = dcc.Transaction_header_id
968: AND dcc.customer_inv_line_id = dtg.transaction_line_id
969: AND nvl(dcc.reported_inventory,0) > 0

Line 975: FROM DPP_customer_claims_all dcca,

971: AND nvl(dcc.supplier_claim_created,''N'') = ''N'') LINES
972: FROM dpp_transaction_headers_all headers
973: WHERE headers.Transaction_header_id = ' ||p_txn_hdr_rec.Transaction_Header_ID||
974: 'AND EXISTS (SELECT dcca.Transaction_header_id
975: FROM DPP_customer_claims_all dcca,
976: DPP_TRANSACTION_LINES_GT dtga
977: WHERE dcca.Transaction_header_id = '||p_txn_hdr_rec.Transaction_Header_ID||'
978: AND dcca.customer_inv_line_id = dtga.transaction_line_id
979: AND nvl(dcca.supplier_claim_created,''N'') = ''N''

Line 996: --Update the line status to PENDING in the DPP_customer_claims_all table

992: dbms_xmlquery.closeContext(l_queryCtx);
993:
994: IF l_row_count >0 THEN
995: IF p_txn_hdr_rec.claim_creation_source = 'EXEDTLS' THEN
996: --Update the line status to PENDING in the DPP_customer_claims_all table
997: UPDATE DPP_customer_claims_all
998: SET supplier_claim_created = 'P',
999: OBJECT_VERSION_NUMBER = OBJECT_VERSION_NUMBER +1,
1000: last_updated_by = l_user_id,

Line 997: UPDATE DPP_customer_claims_all

993:
994: IF l_row_count >0 THEN
995: IF p_txn_hdr_rec.claim_creation_source = 'EXEDTLS' THEN
996: --Update the line status to PENDING in the DPP_customer_claims_all table
997: UPDATE DPP_customer_claims_all
998: SET supplier_claim_created = 'P',
999: OBJECT_VERSION_NUMBER = OBJECT_VERSION_NUMBER +1,
1000: last_updated_by = l_user_id,
1001: last_update_date = sysdate,

Line 1010: DPP_UTILITY_PVT.debug_message('Unable to Update the column supplier_claim_created in DPP_customer_claims_all Table');

1006: AND nvl(supp_claim_amt,0) > 0;
1007:
1008: IF SQL%ROWCOUNT = 0 THEN
1009: l_return_status := FND_API.G_RET_STS_ERROR;
1010: DPP_UTILITY_PVT.debug_message('Unable to Update the column supplier_claim_created in DPP_customer_claims_all Table');
1011: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1012: END IF;
1013: --Update those lines to Y which have reported inventory as 0
1014: UPDATE DPP_customer_claims_all

Line 1014: UPDATE DPP_customer_claims_all

1010: DPP_UTILITY_PVT.debug_message('Unable to Update the column supplier_claim_created in DPP_customer_claims_all Table');
1011: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1012: END IF;
1013: --Update those lines to Y which have reported inventory as 0
1014: UPDATE DPP_customer_claims_all
1015: SET supplier_claim_created = 'Y',
1016: OBJECT_VERSION_NUMBER = OBJECT_VERSION_NUMBER +1,
1017: last_updated_by = l_user_id,
1018: last_update_date = sysdate,

Line 1045: FROM DPP_customer_claims_all dcc,

1041: dcc.cust_claim_amt claim_line_amount,
1042: dcc.reported_inventory claim_quantity,
1043: dcc.trx_currency currency,
1044: dcc.UOM
1045: FROM DPP_customer_claims_all dcc,
1046: DPP_TRANSACTION_LINES_GT dtg
1047: WHERE headers.Transaction_header_id = dcc.Transaction_header_id
1048: AND dcc.customer_inv_line_id = dtg.transaction_line_id
1049: AND nvl(dcc.reported_inventory,0) > 0

Line 1055: FROM DPP_customer_claims_all dcca,

1051: AND nvl(dcc.customer_claim_created,''N'') = ''N'') LINES
1052: FROM dpp_transaction_headers_all headers
1053: WHERE headers.Transaction_header_id = ' ||p_txn_hdr_rec.Transaction_Header_ID||
1054: 'AND EXISTS (SELECT dcca.Transaction_header_id
1055: FROM DPP_customer_claims_all dcca,
1056: DPP_TRANSACTION_LINES_GT dtga
1057: WHERE dcca.Transaction_header_id = '||p_txn_hdr_rec.Transaction_Header_ID||'
1058: AND dcca.customer_inv_line_id = dtga.transaction_line_id
1059: AND nvl(dcca.customer_claim_created,''N'') = ''N''