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_BUSINESSEVENTS_PVT dependencies on DPP_TRANSACTION_LINES_ALL

Line 755: FROM dpp_transaction_lines_all

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
756: WHERE transaction_header_id = p_txn_hdr_rec.Transaction_Header_ID;
757: EXCEPTION
758: WHEN OTHERS THEN
759: fnd_message.set_name('FND', 'SQL_PLSQL_ERROR');

Line 808: FROM dpp_transaction_lines_all lines

804: inventory_item_id,
805: supplier_new_price new_price,
806: UOM,
807: headers.trx_currency currency
808: FROM dpp_transaction_lines_all lines
809: WHERE headers.Transaction_header_id = lines.Transaction_header_id
810: AND nvl(lines.UPDATE_ITEM_LIST_PRICE,''N'') = ''N'') LINES
811: FROM dpp_transaction_headers_all headers
812: WHERE headers.Transaction_header_id = ' ||p_txn_hdr_rec.Transaction_Header_ID||

Line 814: FROM dpp_transaction_lines_all

810: AND nvl(lines.UPDATE_ITEM_LIST_PRICE,''N'') = ''N'') LINES
811: FROM dpp_transaction_headers_all headers
812: WHERE headers.Transaction_header_id = ' ||p_txn_hdr_rec.Transaction_Header_ID||
813: 'AND EXISTS (SELECT Transaction_header_id
814: FROM dpp_transaction_lines_all
815: WHERE Transaction_header_id = '||p_txn_hdr_rec.Transaction_Header_ID||'
816: AND nvl(UPDATE_ITEM_LIST_PRICE,''N'') = ''N'')'
817: );
818: dbms_xmlquery.setRowTag(l_queryCtx

Line 830: --Update the line status to PENDING in the DPP_TRANSACTION_LINES_ALL table

826: l_row_count := dbms_xmlquery.getNumRowsProcessed(l_queryCtx);
827: dbms_xmlquery.closeContext(l_queryCtx);
828:
829: IF l_row_count >0 THEN
830: --Update the line status to PENDING in the DPP_TRANSACTION_LINES_ALL table
831: UPDATE DPP_TRANSACTION_LINES_ALL
832: SET update_item_list_price = 'P',
833: OBJECT_VERSION_NUMBER = OBJECT_VERSION_NUMBER +1,
834: last_updated_by = l_user_id,

Line 831: UPDATE DPP_TRANSACTION_LINES_ALL

827: dbms_xmlquery.closeContext(l_queryCtx);
828:
829: IF l_row_count >0 THEN
830: --Update the line status to PENDING in the DPP_TRANSACTION_LINES_ALL table
831: UPDATE DPP_TRANSACTION_LINES_ALL
832: SET update_item_list_price = 'P',
833: OBJECT_VERSION_NUMBER = OBJECT_VERSION_NUMBER +1,
834: last_updated_by = l_user_id,
835: last_update_date = sysdate,

Line 842: DPP_UTILITY_PVT.debug_message(FND_LOG.LEVEL_STATEMENT, l_module, 'Unable to Update the column update_item_list_price in DPP_TRANSACTION_LINES_ALL Table');

838: AND nvl(update_item_list_price, 'N') = 'N';
839:
840: IF SQL%ROWCOUNT = 0 THEN
841: l_return_status := FND_API.G_RET_STS_ERROR;
842: DPP_UTILITY_PVT.debug_message(FND_LOG.LEVEL_STATEMENT, l_module, 'Unable to Update the column update_item_list_price in DPP_TRANSACTION_LINES_ALL Table');
843: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
844: END IF;
845:
846: END IF;

Line 863: FROM dpp_transaction_lines_all lines

859: CURSOR(select transaction_line_id,
860: inventory_item_id,
861: supplier_new_price new_price,
862: headers.trx_currency currency
863: FROM dpp_transaction_lines_all lines
864: WHERE headers.Transaction_header_id = lines.Transaction_header_id
865: AND nvl(lines.NOTIFY_OUTBOUND_PRICELIST,''N'') <> ''D'') LINES
866: FROM dpp_transaction_headers_all headers
867: WHERE headers.Transaction_header_id = ' ||p_txn_hdr_rec.Transaction_Header_ID||

Line 869: FROM dpp_transaction_lines_all

865: AND nvl(lines.NOTIFY_OUTBOUND_PRICELIST,''N'') <> ''D'') LINES
866: FROM dpp_transaction_headers_all headers
867: WHERE headers.Transaction_header_id = ' ||p_txn_hdr_rec.Transaction_Header_ID||
868: 'AND EXISTS (SELECT Transaction_header_id
869: FROM dpp_transaction_lines_all
870: WHERE Transaction_header_id = '||p_txn_hdr_rec.Transaction_Header_ID||'
871: AND nvl(NOTIFY_OUTBOUND_PRICELIST,''N'') <> ''D'')'
872: );
873: dbms_xmlquery.setRowTag(l_queryCtx

Line 885: --Update the line status to PENDING in the DPP_TRANSACTION_LINES_ALL table

881: l_row_count := dbms_xmlquery.getNumRowsProcessed(l_queryCtx);
882: dbms_xmlquery.closeContext(l_queryCtx);
883:
884: IF l_row_count >0 THEN
885: --Update the line status to PENDING in the DPP_TRANSACTION_LINES_ALL table
886: UPDATE DPP_TRANSACTION_LINES_ALL
887: SET NOTIFY_OUTBOUND_PRICELIST = 'P',
888: OBJECT_VERSION_NUMBER = OBJECT_VERSION_NUMBER +1,
889: last_updated_by = l_user_id,

Line 886: UPDATE DPP_TRANSACTION_LINES_ALL

882: dbms_xmlquery.closeContext(l_queryCtx);
883:
884: IF l_row_count >0 THEN
885: --Update the line status to PENDING in the DPP_TRANSACTION_LINES_ALL table
886: UPDATE DPP_TRANSACTION_LINES_ALL
887: SET NOTIFY_OUTBOUND_PRICELIST = 'P',
888: OBJECT_VERSION_NUMBER = OBJECT_VERSION_NUMBER +1,
889: last_updated_by = l_user_id,
890: last_update_date = sysdate,

Line 897: DPP_UTILITY_PVT.debug_message(FND_LOG.LEVEL_STATEMENT, l_module, 'Unable to Update the column NOTIFY_OUTBOUND_PRICELIST in DPP_TRANSACTION_LINES_ALL Table');

893: AND nvl(NOTIFY_OUTBOUND_PRICELIST,'N') <> 'D';
894:
895: IF SQL%ROWCOUNT = 0 THEN
896: l_return_status := FND_API.G_RET_STS_ERROR;
897: DPP_UTILITY_PVT.debug_message(FND_LOG.LEVEL_STATEMENT, l_module, 'Unable to Update the column NOTIFY_OUTBOUND_PRICELIST in DPP_TRANSACTION_LINES_ALL Table');
898: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
899: END IF;
900: END IF;
901:

Line 912: FROM dpp_transaction_lines_all

908: WHERE transaction_header_id = p_txn_hdr_rec.transaction_header_id;
909:
910: SELECT SUM(DPP_UTILITY_PVT.CurrRound(nvl(claim_amount,0), l_trx_currency))
911: INTO l_claim_hdr_amt
912: FROM dpp_transaction_lines_all
913: WHERE transaction_header_id = p_txn_hdr_rec.Transaction_Header_ID
914: AND to_number(supp_dist_claim_id) = p_txn_hdr_rec.claim_id;
915: EXCEPTION
916: WHEN NO_DATA_FOUND THEN

Line 959: FROM dpp_transaction_lines_all lines

955: approved_inventory claim_quantity,
956: UOM,'
957: ||p_txn_hdr_rec.claim_id||'claim_id,
958: headers.trx_currency currency
959: FROM dpp_transaction_lines_all lines
960: WHERE headers.Transaction_header_id = lines.Transaction_header_id
961: AND lines.supp_dist_claim_id = '||p_txn_hdr_rec.claim_id||') LINES
962: FROM dpp_transaction_headers_all headers
963: WHERE headers.Transaction_header_id = ' ||p_txn_hdr_rec.Transaction_Header_ID

Line 992: FROM dpp_transaction_lines_all lines

988: CURSOR(select transaction_line_id,
989: inventory_item_id,
990: supplier_new_price new_price,
991: headers.trx_currency currency
992: FROM dpp_transaction_lines_all lines
993: WHERE headers.Transaction_header_id = lines.Transaction_header_id
994: AND nvl(lines.NOTIFY_INBOUND_PRICELIST,''N'') <> ''D'') LINES
995: FROM dpp_transaction_headers_all headers
996: WHERE headers.Transaction_header_id = ' ||p_txn_hdr_rec.Transaction_Header_ID||

Line 998: FROM dpp_transaction_lines_all

994: AND nvl(lines.NOTIFY_INBOUND_PRICELIST,''N'') <> ''D'') LINES
995: FROM dpp_transaction_headers_all headers
996: WHERE headers.Transaction_header_id = ' ||p_txn_hdr_rec.Transaction_Header_ID||
997: 'AND EXISTS (SELECT Transaction_header_id
998: FROM dpp_transaction_lines_all
999: WHERE Transaction_header_id = '||p_txn_hdr_rec.Transaction_Header_ID||'
1000: AND nvl(NOTIFY_INBOUND_PRICELIST,''N'') <> ''D'')'
1001: );
1002: dbms_xmlquery.setRowTag(l_queryCtx

Line 1014: --Update the line status to PENDING in the DPP_TRANSACTION_LINES_ALL table

1010: l_row_count := dbms_xmlquery.getNumRowsProcessed(l_queryCtx);
1011: dbms_xmlquery.closeContext(l_queryCtx);
1012:
1013: IF l_row_count >0 THEN
1014: --Update the line status to PENDING in the DPP_TRANSACTION_LINES_ALL table
1015: UPDATE DPP_TRANSACTION_LINES_ALL
1016: SET NOTIFY_INBOUND_PRICELIST = 'P',
1017: OBJECT_VERSION_NUMBER = OBJECT_VERSION_NUMBER +1,
1018: last_updated_by = l_user_id,

Line 1015: UPDATE DPP_TRANSACTION_LINES_ALL

1011: dbms_xmlquery.closeContext(l_queryCtx);
1012:
1013: IF l_row_count >0 THEN
1014: --Update the line status to PENDING in the DPP_TRANSACTION_LINES_ALL table
1015: UPDATE DPP_TRANSACTION_LINES_ALL
1016: SET NOTIFY_INBOUND_PRICELIST = 'P',
1017: OBJECT_VERSION_NUMBER = OBJECT_VERSION_NUMBER +1,
1018: last_updated_by = l_user_id,
1019: last_update_date = sysdate,

Line 1026: DPP_UTILITY_PVT.debug_message(FND_LOG.LEVEL_STATEMENT, l_module, 'Unable to Update the column NOTIFY_INBOUND_PRICELIST in DPP_TRANSACTION_LINES_ALL Table');

1022: AND nvl(NOTIFY_INBOUND_PRICELIST,'N') <> 'D';
1023:
1024: IF SQL%ROWCOUNT = 0 THEN
1025: l_return_status := FND_API.G_RET_STS_ERROR;
1026: DPP_UTILITY_PVT.debug_message(FND_LOG.LEVEL_STATEMENT, l_module, 'Unable to Update the column NOTIFY_INBOUND_PRICELIST in DPP_TRANSACTION_LINES_ALL Table');
1027: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1028: END IF;
1029: END IF;
1030:

Line 1047: FROM dpp_transaction_lines_all lines

1043: CURSOR(select transaction_line_id,
1044: inventory_item_id,
1045: supplier_new_price new_price,
1046: headers.trx_currency currency
1047: FROM dpp_transaction_lines_all lines
1048: WHERE headers.Transaction_header_id = lines.Transaction_header_id
1049: AND nvl(lines.NOTIFY_PROMOTIONS_PRICELIST,''N'') <> ''D'') LINES
1050: FROM dpp_transaction_headers_all headers
1051: WHERE headers.Transaction_header_id = ' ||p_txn_hdr_rec.Transaction_Header_ID||

Line 1053: FROM dpp_transaction_lines_all

1049: AND nvl(lines.NOTIFY_PROMOTIONS_PRICELIST,''N'') <> ''D'') LINES
1050: FROM dpp_transaction_headers_all headers
1051: WHERE headers.Transaction_header_id = ' ||p_txn_hdr_rec.Transaction_Header_ID||
1052: 'AND EXISTS (SELECT Transaction_header_id
1053: FROM dpp_transaction_lines_all
1054: WHERE Transaction_header_id = '||p_txn_hdr_rec.Transaction_Header_ID||'
1055: AND nvl(NOTIFY_PROMOTIONS_PRICELIST,''N'') <> ''D'')'
1056: );
1057: dbms_xmlquery.setRowTag(l_queryCtx

Line 1069: --Update the line status to PENDING in the DPP_TRANSACTION_LINES_ALL table

1065: l_row_count := dbms_xmlquery.getNumRowsProcessed(l_queryCtx);
1066: dbms_xmlquery.closeContext(l_queryCtx);
1067:
1068: IF l_row_count >0 THEN
1069: --Update the line status to PENDING in the DPP_TRANSACTION_LINES_ALL table
1070: UPDATE DPP_TRANSACTION_LINES_ALL
1071: SET NOTIFY_PROMOTIONS_PRICELIST = 'P',
1072: OBJECT_VERSION_NUMBER = OBJECT_VERSION_NUMBER +1,
1073: last_updated_by = l_user_id,

Line 1070: UPDATE DPP_TRANSACTION_LINES_ALL

1066: dbms_xmlquery.closeContext(l_queryCtx);
1067:
1068: IF l_row_count >0 THEN
1069: --Update the line status to PENDING in the DPP_TRANSACTION_LINES_ALL table
1070: UPDATE DPP_TRANSACTION_LINES_ALL
1071: SET NOTIFY_PROMOTIONS_PRICELIST = 'P',
1072: OBJECT_VERSION_NUMBER = OBJECT_VERSION_NUMBER +1,
1073: last_updated_by = l_user_id,
1074: last_update_date = sysdate,

Line 1081: DPP_UTILITY_PVT.debug_message(FND_LOG.LEVEL_STATEMENT, l_module, 'Unable to Update the column NOTIFY_PROMOTIONS_PRICELIST in DPP_TRANSACTION_LINES_ALL Table');

1077: AND nvl(NOTIFY_PROMOTIONS_PRICELIST,'N') <> 'D';
1078:
1079: IF SQL%ROWCOUNT = 0 THEN
1080: l_return_status := FND_API.G_RET_STS_ERROR;
1081: DPP_UTILITY_PVT.debug_message(FND_LOG.LEVEL_STATEMENT, l_module, 'Unable to Update the column NOTIFY_PROMOTIONS_PRICELIST in DPP_TRANSACTION_LINES_ALL Table');
1082: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1083: END IF;
1084: END IF;
1085: ELSIF p_txn_hdr_rec.process_code = 'INVC' THEN

Line 1163: FROM dpp_transaction_lines_all lines

1159: supplier_new_price new_price,
1160: headers.trx_currency currency,
1161: UOM,
1162: price_change
1163: FROM dpp_transaction_lines_all lines
1164: WHERE headers.Transaction_header_id = lines.Transaction_header_id
1165: AND nvl(lines.UPDATE_INVENTORY_COSTING,''N'') = ''N'') LINES
1166: FROM dpp_transaction_headers_all headers
1167: WHERE headers.Transaction_header_id = ' ||p_txn_hdr_rec.Transaction_Header_ID||

Line 1169: FROM dpp_transaction_lines_all

1165: AND nvl(lines.UPDATE_INVENTORY_COSTING,''N'') = ''N'') LINES
1166: FROM dpp_transaction_headers_all headers
1167: WHERE headers.Transaction_header_id = ' ||p_txn_hdr_rec.Transaction_Header_ID||
1168: 'AND EXISTS (SELECT Transaction_header_id
1169: FROM dpp_transaction_lines_all
1170: WHERE Transaction_header_id = '||p_txn_hdr_rec.Transaction_Header_ID||'
1171: AND nvl(UPDATE_INVENTORY_COSTING,''N'') = ''N'')'
1172: );
1173: dbms_xmlquery.setRowTag(l_queryCtx

Line 1185: --Update the line status to PENDING in the DPP_TRANSACTION_LINES_ALL table

1181: l_row_count := dbms_xmlquery.getNumRowsProcessed(l_queryCtx);
1182: dbms_xmlquery.closeContext(l_queryCtx);
1183:
1184: IF l_row_count >0 THEN
1185: --Update the line status to PENDING in the DPP_TRANSACTION_LINES_ALL table
1186: UPDATE DPP_TRANSACTION_LINES_ALL
1187: SET UPDATE_INVENTORY_COSTING = 'P',
1188: OBJECT_VERSION_NUMBER = OBJECT_VERSION_NUMBER +1,
1189: last_updated_by = l_user_id,

Line 1186: UPDATE DPP_TRANSACTION_LINES_ALL

1182: dbms_xmlquery.closeContext(l_queryCtx);
1183:
1184: IF l_row_count >0 THEN
1185: --Update the line status to PENDING in the DPP_TRANSACTION_LINES_ALL table
1186: UPDATE DPP_TRANSACTION_LINES_ALL
1187: SET UPDATE_INVENTORY_COSTING = 'P',
1188: OBJECT_VERSION_NUMBER = OBJECT_VERSION_NUMBER +1,
1189: last_updated_by = l_user_id,
1190: last_update_date = sysdate,

Line 1197: DPP_UTILITY_PVT.debug_message(FND_LOG.LEVEL_STATEMENT, l_module, 'Unable to Update the column UPDATE_INVENTORY_COSTING in DPP_TRANSACTION_LINES_ALL Table');

1193: AND nvl(UPDATE_INVENTORY_COSTING,'N') = 'N';
1194:
1195: IF SQL%ROWCOUNT = 0 THEN
1196: l_return_status := FND_API.G_RET_STS_ERROR;
1197: DPP_UTILITY_PVT.debug_message(FND_LOG.LEVEL_STATEMENT, l_module, 'Unable to Update the column UPDATE_INVENTORY_COSTING in DPP_TRANSACTION_LINES_ALL Table');
1198: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1199: END IF;
1200: END IF;
1201: ELSE

Line 1230: FROM dpp_transaction_lines_all lines

1226: inventory_item_id,
1227: supplier_new_price new_price,
1228: UOM,
1229: headers.trx_currency currency
1230: FROM dpp_transaction_lines_all lines
1231: WHERE headers.Transaction_header_id = lines.Transaction_header_id
1232: AND nvl(lines.NOTIFY_PURCHASING_DOCS,''N'') <> ''D'') LINES
1233: FROM dpp_transaction_headers_all headers
1234: WHERE headers.Transaction_header_id = ' ||p_txn_hdr_rec.Transaction_Header_ID||

Line 1236: FROM dpp_transaction_lines_all

1232: AND nvl(lines.NOTIFY_PURCHASING_DOCS,''N'') <> ''D'') LINES
1233: FROM dpp_transaction_headers_all headers
1234: WHERE headers.Transaction_header_id = ' ||p_txn_hdr_rec.Transaction_Header_ID||
1235: 'AND EXISTS (SELECT Transaction_header_id
1236: FROM dpp_transaction_lines_all
1237: WHERE Transaction_header_id = '||p_txn_hdr_rec.Transaction_Header_ID||'
1238: AND nvl(NOTIFY_PURCHASING_DOCS,''N'') <> ''D'')'
1239: );
1240: dbms_xmlquery.setRowTag(l_queryCtx

Line 1252: --Update the line status to PENDING in the DPP_TRANSACTION_LINES_ALL table

1248: l_row_count := dbms_xmlquery.getNumRowsProcessed(l_queryCtx);
1249: dbms_xmlquery.closeContext(l_queryCtx);
1250:
1251: IF l_row_count >0 THEN
1252: --Update the line status to PENDING in the DPP_TRANSACTION_LINES_ALL table
1253: UPDATE DPP_TRANSACTION_LINES_ALL
1254: SET notify_purchasing_docs = 'P',
1255: OBJECT_VERSION_NUMBER = OBJECT_VERSION_NUMBER +1,
1256: last_updated_by = l_user_id,

Line 1253: UPDATE DPP_TRANSACTION_LINES_ALL

1249: dbms_xmlquery.closeContext(l_queryCtx);
1250:
1251: IF l_row_count >0 THEN
1252: --Update the line status to PENDING in the DPP_TRANSACTION_LINES_ALL table
1253: UPDATE DPP_TRANSACTION_LINES_ALL
1254: SET notify_purchasing_docs = 'P',
1255: OBJECT_VERSION_NUMBER = OBJECT_VERSION_NUMBER +1,
1256: last_updated_by = l_user_id,
1257: last_update_date = sysdate,

Line 1264: DPP_UTILITY_PVT.debug_message(FND_LOG.LEVEL_STATEMENT, l_module, 'Unable to Update the column notify_purchasing_docs in DPP_TRANSACTION_LINES_ALL Table');

1260: AND nvl(notify_purchasing_docs ,'N') <> 'D';
1261:
1262: IF SQL%ROWCOUNT = 0 THEN
1263: l_return_status := FND_API.G_RET_STS_ERROR;
1264: DPP_UTILITY_PVT.debug_message(FND_LOG.LEVEL_STATEMENT, l_module, 'Unable to Update the column notify_purchasing_docs in DPP_TRANSACTION_LINES_ALL Table');
1265: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1266: END IF;
1267: END IF;
1268: ELSIF p_txn_hdr_rec.process_code = 'UPDTPO' THEN

Line 1282: FROM dpp_transaction_lines_all lines

1278: inventory_item_id,
1279: supplier_new_price new_price,
1280: UOM,
1281: headers.trx_currency currency
1282: FROM dpp_transaction_lines_all lines
1283: WHERE headers.Transaction_header_id = lines.Transaction_header_id
1284: AND nvl(lines.UPDATE_PURCHASING_DOCS,''N'') = ''N'') LINES
1285: FROM dpp_transaction_headers_all headers
1286: WHERE headers.Transaction_header_id = ' ||p_txn_hdr_rec.Transaction_Header_ID||

Line 1288: FROM dpp_transaction_lines_all

1284: AND nvl(lines.UPDATE_PURCHASING_DOCS,''N'') = ''N'') LINES
1285: FROM dpp_transaction_headers_all headers
1286: WHERE headers.Transaction_header_id = ' ||p_txn_hdr_rec.Transaction_Header_ID||
1287: 'AND EXISTS (SELECT Transaction_header_id
1288: FROM dpp_transaction_lines_all
1289: WHERE Transaction_header_id = '||p_txn_hdr_rec.Transaction_Header_ID||'
1290: AND nvl(UPDATE_PURCHASING_DOCS,''N'') = ''N'')'
1291: );
1292: dbms_xmlquery.setRowTag(l_queryCtx

Line 1304: --Update the line status to PENDING in the DPP_TRANSACTION_LINES_ALL table

1300: l_row_count := dbms_xmlquery.getNumRowsProcessed(l_queryCtx);
1301: dbms_xmlquery.closeContext(l_queryCtx);
1302:
1303: IF l_row_count >0 THEN
1304: --Update the line status to PENDING in the DPP_TRANSACTION_LINES_ALL table
1305: UPDATE DPP_TRANSACTION_LINES_ALL
1306: SET UPDATE_PURCHASING_DOCS = 'P',
1307: OBJECT_VERSION_NUMBER = OBJECT_VERSION_NUMBER +1,
1308: last_updated_by = l_user_id,

Line 1305: UPDATE DPP_TRANSACTION_LINES_ALL

1301: dbms_xmlquery.closeContext(l_queryCtx);
1302:
1303: IF l_row_count >0 THEN
1304: --Update the line status to PENDING in the DPP_TRANSACTION_LINES_ALL table
1305: UPDATE DPP_TRANSACTION_LINES_ALL
1306: SET UPDATE_PURCHASING_DOCS = 'P',
1307: OBJECT_VERSION_NUMBER = OBJECT_VERSION_NUMBER +1,
1308: last_updated_by = l_user_id,
1309: last_update_date = sysdate,

Line 1316: DPP_UTILITY_PVT.debug_message(FND_LOG.LEVEL_STATEMENT, l_module, 'Unable to Update the column UPDATE_PURCHASING_DOCS in DPP_TRANSACTION_LINES_ALL Table');

1312: AND nvl(UPDATE_PURCHASING_DOCS ,'N')= 'N';
1313:
1314: IF SQL%ROWCOUNT = 0 THEN
1315: l_return_status := FND_API.G_RET_STS_ERROR;
1316: DPP_UTILITY_PVT.debug_message(FND_LOG.LEVEL_STATEMENT, l_module, 'Unable to Update the column UPDATE_PURCHASING_DOCS in DPP_TRANSACTION_LINES_ALL Table');
1317: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1318: END IF;
1319: END IF;
1320: ELSIF p_txn_hdr_rec.process_code = 'DSTRINVCL' THEN

Line 1381: FROM dpp_transaction_lines_all dtl,

1377: dtl.claim_amount claim_line_amount,
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||'

Line 1391: FROM dpp_transaction_lines_all dtla,

1387: AND nvl(dtl.SUPP_DIST_CLAIM_STATUS,''N'') = ''N'') LINES
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''

Line 1414: --Update the line status to PENDING in the DPP_TRANSACTION_LINES_ALL table

1410: IF l_row_count >0 THEN
1411: IF p_txn_hdr_rec.claim_creation_source = 'EXEDTLS' THEN
1412:
1413: IF (l_price_change_flag = 'N') THEN -- Only Price Decrease Lines
1414: --Update the line status to PENDING in the DPP_TRANSACTION_LINES_ALL table
1415: UPDATE DPP_TRANSACTION_LINES_ALL
1416: SET SUPP_DIST_CLAIM_STATUS = 'P',
1417: OBJECT_VERSION_NUMBER = OBJECT_VERSION_NUMBER +1,
1418: last_updated_by = l_user_id,

Line 1415: UPDATE DPP_TRANSACTION_LINES_ALL

1411: IF p_txn_hdr_rec.claim_creation_source = 'EXEDTLS' THEN
1412:
1413: IF (l_price_change_flag = 'N') THEN -- Only Price Decrease Lines
1414: --Update the line status to PENDING in the DPP_TRANSACTION_LINES_ALL table
1415: UPDATE DPP_TRANSACTION_LINES_ALL
1416: SET SUPP_DIST_CLAIM_STATUS = 'P',
1417: OBJECT_VERSION_NUMBER = OBJECT_VERSION_NUMBER +1,
1418: last_updated_by = l_user_id,
1419: last_update_date = sysdate,

Line 1428: DPP_UTILITY_PVT.debug_message(FND_LOG.LEVEL_STATEMENT, l_module, 'Unable to Update the column SUPP_DIST_CLAIM_STATUS in DPP_TRANSACTION_LINES_ALL Table');

1424: AND nvl(price_change,0) > 0;
1425:
1426: IF SQL%ROWCOUNT = 0 THEN
1427: l_return_status := FND_API.G_RET_STS_ERROR;
1428: DPP_UTILITY_PVT.debug_message(FND_LOG.LEVEL_STATEMENT, l_module, 'Unable to Update the column SUPP_DIST_CLAIM_STATUS in DPP_TRANSACTION_LINES_ALL Table');
1429: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1430: END IF;
1431: --Update those lines to Y who have the approved inventory as 0
1432: UPDATE DPP_TRANSACTION_LINES_ALL

Line 1432: UPDATE DPP_TRANSACTION_LINES_ALL

1428: DPP_UTILITY_PVT.debug_message(FND_LOG.LEVEL_STATEMENT, l_module, 'Unable to Update the column SUPP_DIST_CLAIM_STATUS in DPP_TRANSACTION_LINES_ALL Table');
1429: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1430: END IF;
1431: --Update those lines to Y who have the approved inventory as 0
1432: UPDATE DPP_TRANSACTION_LINES_ALL
1433: SET SUPP_DIST_CLAIM_STATUS = 'Y',
1434: OBJECT_VERSION_NUMBER = OBJECT_VERSION_NUMBER +1,
1435: last_updated_by = l_user_id,
1436: last_update_date = sysdate,

Line 1442: --Update the line status to PENDING in the DPP_TRANSACTION_LINES_ALL table

1438: WHERE transaction_header_id = p_txn_hdr_rec.Transaction_Header_ID
1439: AND nvl(SUPP_DIST_CLAIM_STATUS ,'N')= 'N'
1440: AND (nvl(approved_inventory,0) = 0 OR nvl(price_change,0) <= 0);
1441: ELSE -- Both Price Increase and Price Decrease Lines
1442: --Update the line status to PENDING in the DPP_TRANSACTION_LINES_ALL table
1443: UPDATE DPP_TRANSACTION_LINES_ALL
1444: SET SUPP_DIST_CLAIM_STATUS = 'P',
1445: OBJECT_VERSION_NUMBER = OBJECT_VERSION_NUMBER +1,
1446: last_updated_by = l_user_id,

Line 1443: UPDATE DPP_TRANSACTION_LINES_ALL

1439: AND nvl(SUPP_DIST_CLAIM_STATUS ,'N')= 'N'
1440: AND (nvl(approved_inventory,0) = 0 OR nvl(price_change,0) <= 0);
1441: ELSE -- Both Price Increase and Price Decrease Lines
1442: --Update the line status to PENDING in the DPP_TRANSACTION_LINES_ALL table
1443: UPDATE DPP_TRANSACTION_LINES_ALL
1444: SET SUPP_DIST_CLAIM_STATUS = 'P',
1445: OBJECT_VERSION_NUMBER = OBJECT_VERSION_NUMBER +1,
1446: last_updated_by = l_user_id,
1447: last_update_date = sysdate,

Line 1456: DPP_UTILITY_PVT.debug_message(FND_LOG.LEVEL_STATEMENT, l_module, 'Unable to Update the column SUPP_DIST_CLAIM_STATUS in DPP_TRANSACTION_LINES_ALL Table');

1452: AND nvl(price_change,0) <> 0;
1453:
1454: IF SQL%ROWCOUNT = 0 THEN
1455: l_return_status := FND_API.G_RET_STS_ERROR;
1456: DPP_UTILITY_PVT.debug_message(FND_LOG.LEVEL_STATEMENT, l_module, 'Unable to Update the column SUPP_DIST_CLAIM_STATUS in DPP_TRANSACTION_LINES_ALL Table');
1457: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1458: END IF;
1459: --Update those lines to Y who have the approved inventory as 0
1460: UPDATE DPP_TRANSACTION_LINES_ALL

Line 1460: UPDATE DPP_TRANSACTION_LINES_ALL

1456: DPP_UTILITY_PVT.debug_message(FND_LOG.LEVEL_STATEMENT, l_module, 'Unable to Update the column SUPP_DIST_CLAIM_STATUS in DPP_TRANSACTION_LINES_ALL Table');
1457: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1458: END IF;
1459: --Update those lines to Y who have the approved inventory as 0
1460: UPDATE DPP_TRANSACTION_LINES_ALL
1461: SET SUPP_DIST_CLAIM_STATUS = 'Y',
1462: OBJECT_VERSION_NUMBER = OBJECT_VERSION_NUMBER +1,
1463: last_updated_by = l_user_id,
1464: last_update_date = sysdate,

Line 1614: FROM dpp_transaction_lines_all lines

1610: ||l_exe_dtl_id||'Execution_detail_id,
1611: CURSOR(select transaction_line_id,
1612: inventory_item_id,
1613: UOM
1614: FROM dpp_transaction_lines_all lines
1615: WHERE headers.Transaction_header_id = lines.Transaction_header_id
1616: AND lines.price_change > 0 ) LINES
1617: FROM dpp_transaction_headers_all headers
1618: WHERE headers.Transaction_header_id = ' ||p_txn_hdr_rec.Transaction_Header_ID||

Line 1620: FROM dpp_transaction_lines_all

1616: AND lines.price_change > 0 ) LINES
1617: FROM dpp_transaction_headers_all headers
1618: WHERE headers.Transaction_header_id = ' ||p_txn_hdr_rec.Transaction_Header_ID||
1619: 'AND EXISTS (SELECT Transaction_header_id
1620: FROM dpp_transaction_lines_all
1621: WHERE price_change > 0
1622: AND Transaction_header_id = '||p_txn_hdr_rec.Transaction_Header_ID||')'
1623: );
1624: dbms_xmlquery.setRowTag(l_queryCtx

Line 1647: FROM dpp_transaction_lines_all lines

1643: ||l_user_id||'user_id,'
1644: ||l_exe_dtl_id||'Execution_detail_id,
1645: CURSOR(select transaction_line_id,
1646: inventory_item_id
1647: FROM dpp_transaction_lines_all lines
1648: WHERE headers.Transaction_header_id = lines.Transaction_header_id) LINES
1649: FROM dpp_transaction_headers_all headers
1650: WHERE headers.Transaction_header_id = ' ||p_txn_hdr_rec.Transaction_Header_ID||
1651: 'AND EXISTS (SELECT Transaction_header_id

Line 1652: FROM dpp_transaction_lines_all

1648: WHERE headers.Transaction_header_id = lines.Transaction_header_id) LINES
1649: FROM dpp_transaction_headers_all headers
1650: WHERE headers.Transaction_header_id = ' ||p_txn_hdr_rec.Transaction_Header_ID||
1651: 'AND EXISTS (SELECT Transaction_header_id
1652: FROM dpp_transaction_lines_all
1653: WHERE Transaction_header_id = '||p_txn_hdr_rec.Transaction_Header_ID||')'
1654: );
1655: dbms_xmlquery.setRowTag(l_queryCtx
1656: , 'HEADER'