[Home] [Help]
708: --Concatinate the claim flag with necessary quotes to generate xml data
709: l_claim_type_flag := ''''||p_txn_hdr_rec.claim_type_flag||'''';
710: DPP_UTILITY_PVT.debug_message(FND_LOG.LEVEL_STATEMENT, l_module, 'Claim Type Flag : ' || l_claim_type_flag);
711: END IF;
712: --Delete the existing rows from the DPP_TRANSACTION_LINES_GT table
713: DELETE FROM DPP_TRANSACTION_LINES_GT;
714: --Check if any line id has been passed and insert into the table DPP_TRANSACTION_LINES_GT
715: l_table_count := p_txn_line_id.COUNT;
716: --Changed the condition to check the claim source instead of the table count since array cannot be NULL from UI
709: l_claim_type_flag := ''''||p_txn_hdr_rec.claim_type_flag||'''';
710: DPP_UTILITY_PVT.debug_message(FND_LOG.LEVEL_STATEMENT, l_module, 'Claim Type Flag : ' || l_claim_type_flag);
711: END IF;
712: --Delete the existing rows from the DPP_TRANSACTION_LINES_GT table
713: DELETE FROM DPP_TRANSACTION_LINES_GT;
714: --Check if any line id has been passed and insert into the table DPP_TRANSACTION_LINES_GT
715: l_table_count := p_txn_line_id.COUNT;
716: --Changed the condition to check the claim source instead of the table count since array cannot be NULL from UI
717: IF p_txn_hdr_rec.claim_creation_source <> 'EXEDTLS' THEN
710: DPP_UTILITY_PVT.debug_message(FND_LOG.LEVEL_STATEMENT, l_module, 'Claim Type Flag : ' || l_claim_type_flag);
711: END IF;
712: --Delete the existing rows from the DPP_TRANSACTION_LINES_GT table
713: DELETE FROM DPP_TRANSACTION_LINES_GT;
714: --Check if any line id has been passed and insert into the table DPP_TRANSACTION_LINES_GT
715: l_table_count := p_txn_line_id.COUNT;
716: --Changed the condition to check the claim source instead of the table count since array cannot be NULL from UI
717: IF p_txn_hdr_rec.claim_creation_source <> 'EXEDTLS' THEN
718: IF l_table_count > 0 THEN
717: IF p_txn_hdr_rec.claim_creation_source <> 'EXEDTLS' THEN
718: IF l_table_count > 0 THEN
719: FOR i IN p_txn_line_id.FIRST..p_txn_line_id.LAST LOOP
720: BEGIN
721: INSERT INTO DPP_TRANSACTION_LINES_GT(transaction_header_id,
722: transaction_line_id
723: )
724: VALUES(p_txn_hdr_rec.Transaction_Header_ID,
725: p_txn_line_id(i)
747: END IF; --l_table_count
748: ELSE
749: IF p_txn_hdr_rec.claim_type_flag = 'SUPP_DSTR_CL' THEN
750: BEGIN
751: INSERT INTO DPP_TRANSACTION_LINES_GT(transaction_header_id,
752: transaction_line_id)
753: SELECT transaction_header_id,
754: transaction_line_id
755: FROM dpp_transaction_lines_all
767: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
768: END;
769: ELSE
770: BEGIN
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
1378: dtl.approved_inventory CLAIM_QUANTITY,
1379: dtl.UOM,
1380: headers.trx_currency currency
1381: FROM dpp_transaction_lines_all dtl,
1382: DPP_TRANSACTION_LINES_GT dtlg
1383: WHERE headers.Transaction_header_id = dtl.Transaction_header_id
1384: AND dtl.transaction_line_id = dtlg.transaction_line_id
1385: AND '||dtl_price_change||'
1386: AND nvl(dtl.approved_inventory,0) > 0
1388: FROM dpp_transaction_headers_all headers
1389: WHERE headers.Transaction_header_id = ' ||p_txn_hdr_rec.Transaction_Header_ID||
1390: 'AND EXISTS (SELECT dtla.Transaction_header_id
1391: FROM dpp_transaction_lines_all dtla,
1392: DPP_TRANSACTION_LINES_GT dtg
1393: WHERE dtla.Transaction_header_id = '||p_txn_hdr_rec.Transaction_Header_ID||'
1394: AND dtla.transaction_line_id = dtg.transaction_line_id
1395: AND nvl(dtla.SUPP_DIST_CLAIM_STATUS,''N'') = ''N''
1396: AND '||dtla_price_change||'
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
1496: AND nvl(dcc.supp_claim_amt,0) > 0
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''
1506: AND nvl(dcca.reported_inventory,0) > 0
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
1576: AND nvl(dcc.cust_claim_amt,0) > 0
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''
1586: AND nvl(dcca.reported_inventory,0) > 0