APPS.DPP_BUSINESSEVENTS_PVT dependencies on DPP_CUSTOMER_CLAIMS_ALL

Line 775: FROM dpp_customer_claims_all

771: INSERT INTO DPP_TRANSACTION_LINES_GT(transaction_header_id,
772: transaction_line_id)
773: SELECT transaction_header_id,
774: customer_inv_line_id
775: FROM dpp_customer_claims_all
776: WHERE transaction_header_id = p_txn_hdr_rec.Transaction_Header_ID;
777: EXCEPTION
778: WHEN OTHERS THEN
779: fnd_message.set_name('FND', 'SQL_PLSQL_ERROR');

Line 1491: FROM DPP_customer_claims_all dcc,

1487: dcc.supp_claim_amt CLAIM_LINE_AMOUNT,
1488: dcc.reported_inventory claim_quantity,
1489: dcc.trx_currency currency,
1490: dcc.UOM
1491: FROM DPP_customer_claims_all dcc,
1492: DPP_TRANSACTION_LINES_GT dtg
1493: WHERE headers.Transaction_header_id = dcc.Transaction_header_id
1494: AND dcc.customer_inv_line_id = dtg.transaction_line_id
1495: AND nvl(dcc.reported_inventory,0) > 0

Line 1501: FROM DPP_customer_claims_all dcca,

1497: AND nvl(dcc.supplier_claim_created,''N'') = ''N'') LINES
1498: FROM dpp_transaction_headers_all headers
1499: WHERE headers.Transaction_header_id = ' ||p_txn_hdr_rec.Transaction_Header_ID||
1500: 'AND EXISTS (SELECT dcca.Transaction_header_id
1501: FROM DPP_customer_claims_all dcca,
1502: DPP_TRANSACTION_LINES_GT dtga
1503: WHERE dcca.Transaction_header_id = '||p_txn_hdr_rec.Transaction_Header_ID||'
1504: AND dcca.customer_inv_line_id = dtga.transaction_line_id
1505: AND nvl(dcca.supplier_claim_created,''N'') = ''N''

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

1518: dbms_xmlquery.closeContext(l_queryCtx);
1519:
1520: IF l_row_count >0 THEN
1521: IF p_txn_hdr_rec.claim_creation_source = 'EXEDTLS' THEN
1522: --Update the line status to PENDING in the DPP_customer_claims_all table
1523: UPDATE DPP_customer_claims_all
1524: SET supplier_claim_created = 'P',
1525: OBJECT_VERSION_NUMBER = OBJECT_VERSION_NUMBER +1,
1526: last_updated_by = l_user_id,

Line 1523: UPDATE DPP_customer_claims_all

1519:
1520: IF l_row_count >0 THEN
1521: IF p_txn_hdr_rec.claim_creation_source = 'EXEDTLS' THEN
1522: --Update the line status to PENDING in the DPP_customer_claims_all table
1523: UPDATE DPP_customer_claims_all
1524: SET supplier_claim_created = 'P',
1525: OBJECT_VERSION_NUMBER = OBJECT_VERSION_NUMBER +1,
1526: last_updated_by = l_user_id,
1527: last_update_date = sysdate,

Line 1536: DPP_UTILITY_PVT.debug_message(FND_LOG.LEVEL_STATEMENT, l_module, 'Unable to Update the column supplier_claim_created in DPP_customer_claims_all Table');

1532: AND nvl(supp_claim_amt,0) > 0;
1533:
1534: IF SQL%ROWCOUNT = 0 THEN
1535: l_return_status := FND_API.G_RET_STS_ERROR;
1536: DPP_UTILITY_PVT.debug_message(FND_LOG.LEVEL_STATEMENT, l_module, 'Unable to Update the column supplier_claim_created in DPP_customer_claims_all Table');
1537: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1538: END IF;
1539: --Update those lines to Y which have reported inventory as 0
1540: UPDATE DPP_customer_claims_all

Line 1540: UPDATE DPP_customer_claims_all

1536: DPP_UTILITY_PVT.debug_message(FND_LOG.LEVEL_STATEMENT, l_module, 'Unable to Update the column supplier_claim_created in DPP_customer_claims_all Table');
1537: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1538: END IF;
1539: --Update those lines to Y which have reported inventory as 0
1540: UPDATE DPP_customer_claims_all
1541: SET supplier_claim_created = 'Y',
1542: OBJECT_VERSION_NUMBER = OBJECT_VERSION_NUMBER +1,
1543: last_updated_by = l_user_id,
1544: last_update_date = sysdate,

Line 1571: FROM DPP_customer_claims_all dcc,

1567: dcc.cust_claim_amt claim_line_amount,
1568: dcc.reported_inventory claim_quantity,
1569: dcc.trx_currency currency,
1570: dcc.UOM
1571: FROM DPP_customer_claims_all dcc,
1572: DPP_TRANSACTION_LINES_GT dtg
1573: WHERE headers.Transaction_header_id = dcc.Transaction_header_id
1574: AND dcc.customer_inv_line_id = dtg.transaction_line_id
1575: AND nvl(dcc.reported_inventory,0) > 0

Line 1581: FROM DPP_customer_claims_all dcca,

1577: AND nvl(dcc.customer_claim_created,''N'') = ''N'') LINES
1578: FROM dpp_transaction_headers_all headers
1579: WHERE headers.Transaction_header_id = ' ||p_txn_hdr_rec.Transaction_Header_ID||
1580: 'AND EXISTS (SELECT dcca.Transaction_header_id
1581: FROM DPP_customer_claims_all dcca,
1582: DPP_TRANSACTION_LINES_GT dtga
1583: WHERE dcca.Transaction_header_id = '||p_txn_hdr_rec.Transaction_Header_ID||'
1584: AND dcca.customer_inv_line_id = dtga.transaction_line_id
1585: AND nvl(dcca.customer_claim_created,''N'') = ''N''