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.OZF_SD_BATCH_FEED_PVT dependencies on OZF_SD_BATCH_LINES_ALL

Line 980: FROM ozf_sd_batch_lines_int_all bint, ozf_sd_batch_lines_all lines, ozf_claim_types_all_vl clm

976: WHERE fu.utilization_id = lines.utilization_id
977: AND lines.batch_id = p_batch_number),
978: lines.claim_amount)
979: END computed_batch_curr_claim_amt
980: FROM ozf_sd_batch_lines_int_all bint, ozf_sd_batch_lines_all lines, ozf_claim_types_all_vl clm
981: WHERE ship_frm_sd_claim_request_id = p_batch_number
982: AND processed_flag = 'N'
983: AND bint.ship_frm_sd_claim_request_id = lines.batch_id
984: AND bint.batch_line_number = lines.batch_line_number

Line 1072: FROM ozf_sd_batch_lines_all bl, ozf_sd_batch_lines_int_all intr

1068: BEGIN
1069: DELETE ozf_sd_batch_line_disputes
1070: WHERE batch_id = l_batch_id
1071: AND batch_line_id IN (SELECT bl.batch_line_id
1072: FROM ozf_sd_batch_lines_all bl, ozf_sd_batch_lines_int_all intr
1073: WHERE bl.batch_id = l_batch_id
1074: AND bl.batch_id = intr.ship_frm_sd_claim_request_id
1075: AND bl.batch_line_number = intr.batch_line_number
1076: AND intr.processed_flag = 'N'

Line 1127: ozf_sd_batch_lines_all bl

1123: ( SELECT intr.batch_id,
1124: intr.batch_line_id,
1125: 'OZF_SD_MISSING_REJ_CODE' dispute_code
1126: FROM ozf_sd_batch_lines_int_all intr,
1127: ozf_sd_batch_lines_all bl
1128: WHERE intr.ship_frm_sd_claim_request_id = p_batch_number
1129: AND intr.processed_flag = 'N'
1130: AND bl.purge_flag <> 'Y'
1131: AND intr.gbl_claim_disposition_code = 'REJECTED'

Line 1162: ozf_sd_batch_lines_all bl

1158: SELECT intr.batch_id,
1159: intr.batch_line_id,
1160: 'OZF_SD_CURR_CODE_MISMATCH' dispute_code
1161: FROM ozf_sd_batch_lines_int_all intr,
1162: ozf_sd_batch_lines_all bl
1163: WHERE intr.ship_frm_sd_claim_request_id = p_batch_number
1164: AND intr.processed_flag = 'N'
1165: AND bl.purge_flag <> 'Y'
1166: AND intr.gbl_claim_disposition_code = 'REJECTED'

Line 1177: ozf_sd_batch_lines_all bl

1173: SELECT intr.batch_id,
1174: intr.batch_line_id,
1175: 'OZF_SD_VENDOR_AUTH_AMT_NGTVE' dispute_code
1176: FROM ozf_sd_batch_lines_int_all intr,
1177: ozf_sd_batch_lines_all bl
1178: WHERE intr.ship_frm_sd_claim_request_id = p_batch_number
1179: AND intr.processed_flag = 'N'
1180: AND bl.purge_flag <> 'Y'
1181: AND intr.gbl_claim_disposition_code = 'REJECTED'

Line 1192: ozf_sd_batch_lines_all bl

1188: SELECT intr.batch_id,
1189: intr.batch_line_id,
1190: 'OZF_SD_VENDOR_AUTH_QTY_NGTVE' dispute_code
1191: FROM ozf_sd_batch_lines_int_all intr,
1192: ozf_sd_batch_lines_all bl
1193: WHERE intr.ship_frm_sd_claim_request_id = p_batch_number
1194: AND intr.processed_flag = 'N'
1195: AND bl.purge_flag <> 'Y'
1196: AND intr.gbl_claim_disposition_code = 'REJECTED'

Line 1208: ozf_sd_batch_lines_all bl

1204: SELECT intr.batch_id,
1205: intr.batch_line_id,
1206: 'OZF_SD_AUTH_AMT_QTY_NULL' dispute_code
1207: FROM ozf_sd_batch_lines_int_all intr,
1208: ozf_sd_batch_lines_all bl
1209: WHERE intr.ship_frm_sd_claim_request_id = p_batch_number
1210: AND intr.processed_flag = 'N'
1211: AND bl.purge_flag <> 'Y'
1212: AND intr.gbl_claim_disposition_code = 'REJECTED'

Line 1237: UPDATE ozf_sd_batch_lines_all

1233: LOOP
1234: ozf_utility_pvt.debug_message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW, 'OZF_SD_BATCH_FEED_PVT::update_data', ' In For loop for V_MISS_REJ_APP_REC.batch_line_number'||V_MISS_REJ_APP_REC.batch_line_number);
1235:
1236:
1237: UPDATE ozf_sd_batch_lines_all
1238: SET status_code = V_MISS_REJ_APP_REC.stat_code,
1239: approved_amount = V_MISS_REJ_APP_REC.auth_cost,
1240: approved_currency_code = V_MISS_REJ_APP_REC.auth_curr_code,
1241: object_version_number = object_version_number + 1,

Line 1315: FROM ozf_sd_batch_lines_all

1311:
1312: --get total number of lines
1313: SELECT COUNT(1)
1314: INTO l_cnt_tot_line
1315: FROM ozf_sd_batch_lines_all
1316: WHERE batch_id = l_batch_id
1317: AND purge_flag <> 'Y';
1318:
1319: --get number of approved lines

Line 1322: FROM ozf_sd_batch_lines_all

1318:
1319: --get number of approved lines
1320: SELECT COUNT(1)
1321: INTO l_cnt_approved_lines
1322: FROM ozf_sd_batch_lines_all
1323: WHERE batch_id = l_batch_id
1324: AND status_code = 'APPROVED'
1325: AND purge_flag <> 'Y';
1326:

Line 1330: FROM ozf_sd_batch_lines_all

1326:
1327: --get number of rejected lines
1328: SELECT COUNT(1)
1329: INTO l_cnt_rejected_lines
1330: FROM ozf_sd_batch_lines_all
1331: WHERE batch_id = l_batch_id
1332: AND status_code = 'REJECTED'
1333: AND purge_flag <> 'Y';
1334:

Line 1374: UPDATE ozf_sd_batch_lines_all

1370: AND processed_flag = 'N';
1371:
1372: -- Update status_code,claim amount,batch_curr_claim_amount and quantity_shipped for over approved lines
1373: --For batch Currency Claim Amount 2 step Conversion i.e accrual date to sysdate is taken care by OZF_SD_UTIL_PVT.GET_CONVERTED_CURRENCY API
1374: UPDATE ozf_sd_batch_lines_all
1375: SET status_code = 'APPROVED',
1376: claim_amount = ozf_utility_pvt.currround(CASE
1377: WHEN((approved_amount is null and quantity_approved is null) OR ( approved_currency_code <> CLAIM_AMOUNT_CURRENCY_CODE ) OR approved_amount < 0 OR (original_claim_amount > 0 and quantity_approved < 0) ) then 0
1378:

Line 1412: WHERE fu.utilization_id = ozf_sd_batch_lines_all.utilization_id

1408: l_batch_currency,
1409: l_func_currency,
1410: (SELECT fu.exchange_rate_type
1411: FROM ozf_funds_utilized_all_b fu
1412: WHERE fu.utilization_id = ozf_sd_batch_lines_all.utilization_id
1413: AND ozf_sd_batch_lines_all.batch_id = l_batch_id),
1414: NULL,
1415: sysdate,
1416: CASE

Line 1413: AND ozf_sd_batch_lines_all.batch_id = l_batch_id),

1409: l_func_currency,
1410: (SELECT fu.exchange_rate_type
1411: FROM ozf_funds_utilized_all_b fu
1412: WHERE fu.utilization_id = ozf_sd_batch_lines_all.utilization_id
1413: AND ozf_sd_batch_lines_all.batch_id = l_batch_id),
1414: NULL,
1415: sysdate,
1416: CASE
1417: WHEN((approved_amount is null and quantity_approved is null) OR ( approved_currency_code <> CLAIM_AMOUNT_CURRENCY_CODE ) OR approved_amount < 0 OR (original_claim_amount > 0 and quantity_approved < 0) ) then 0

Line 1436: WHERE fu.utilization_id = ozf_sd_batch_lines_all.utilization_id

1432: l_batch_currency,
1433: l_func_currency,
1434: (SELECT fu.exchange_rate_type
1435: FROM ozf_funds_utilized_all_b fu
1436: WHERE fu.utilization_id = ozf_sd_batch_lines_all.utilization_id
1437: AND ozf_sd_batch_lines_all.batch_id = l_batch_id),
1438: NULL,
1439: (SELECT fu.exchange_rate_date
1440: FROM ozf_funds_utilized_all_b fu

Line 1437: AND ozf_sd_batch_lines_all.batch_id = l_batch_id),

1433: l_func_currency,
1434: (SELECT fu.exchange_rate_type
1435: FROM ozf_funds_utilized_all_b fu
1436: WHERE fu.utilization_id = ozf_sd_batch_lines_all.utilization_id
1437: AND ozf_sd_batch_lines_all.batch_id = l_batch_id),
1438: NULL,
1439: (SELECT fu.exchange_rate_date
1440: FROM ozf_funds_utilized_all_b fu
1441: WHERE fu.utilization_id = ozf_sd_batch_lines_all.utilization_id

Line 1441: WHERE fu.utilization_id = ozf_sd_batch_lines_all.utilization_id

1437: AND ozf_sd_batch_lines_all.batch_id = l_batch_id),
1438: NULL,
1439: (SELECT fu.exchange_rate_date
1440: FROM ozf_funds_utilized_all_b fu
1441: WHERE fu.utilization_id = ozf_sd_batch_lines_all.utilization_id
1442: AND ozf_sd_batch_lines_all.batch_id = l_batch_id),
1443: CASE
1444: WHEN((approved_amount is null and quantity_approved is null) OR ( approved_currency_code <> CLAIM_AMOUNT_CURRENCY_CODE ) OR approved_amount < 0 OR (original_claim_amount > 0 and quantity_approved < 0) ) then 0
1445:

Line 1442: AND ozf_sd_batch_lines_all.batch_id = l_batch_id),

1438: NULL,
1439: (SELECT fu.exchange_rate_date
1440: FROM ozf_funds_utilized_all_b fu
1441: WHERE fu.utilization_id = ozf_sd_batch_lines_all.utilization_id
1442: AND ozf_sd_batch_lines_all.batch_id = l_batch_id),
1443: CASE
1444: WHEN((approved_amount is null and quantity_approved is null) OR ( approved_currency_code <> CLAIM_AMOUNT_CURRENCY_CODE ) OR approved_amount < 0 OR (original_claim_amount > 0 and quantity_approved < 0) ) then 0
1445:
1446: WHEN (approved_amount is null and quantity_approved IS NOT NULL AND DISCOUNT_TYPE IN ('NEWPRICE','%')) THEN ((list_price-agreement_price) * quantity_approved)

Line 1518: UPDATE ozf_sd_batch_lines_all

1514: LOOP
1515:
1516: ozf_utility_pvt.debug_message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW, 'OZF_SD_BATCH_FEED_PVT::update_data', ' In if l_batch_und_appr_lines_tbl(i) '||l_batch_und_appr_lines_tbl(i));
1517:
1518: UPDATE ozf_sd_batch_lines_all
1519: SET status_code = 'PARTIALLY_APPROVED',
1520: claim_amount = claim_amount - ozf_utility_pvt.currround(CASE
1521: WHEN((approved_amount is null and quantity_approved is null) OR ( approved_currency_code <> CLAIM_AMOUNT_CURRENCY_CODE ) OR approved_amount < 0 OR (original_claim_amount > 0 and quantity_approved < 0) ) then 0
1522:

Line 1556: WHERE fu.utilization_id = ozf_sd_batch_lines_all.utilization_id

1552: l_batch_currency,
1553: l_func_currency,
1554: (SELECT fu.exchange_rate_type
1555: FROM ozf_funds_utilized_all_b fu
1556: WHERE fu.utilization_id = ozf_sd_batch_lines_all.utilization_id
1557: AND ozf_sd_batch_lines_all.batch_id = l_batch_id),
1558: NULL,
1559: sysdate,
1560: claim_amount - ozf_utility_pvt.currround(CASE

Line 1557: AND ozf_sd_batch_lines_all.batch_id = l_batch_id),

1553: l_func_currency,
1554: (SELECT fu.exchange_rate_type
1555: FROM ozf_funds_utilized_all_b fu
1556: WHERE fu.utilization_id = ozf_sd_batch_lines_all.utilization_id
1557: AND ozf_sd_batch_lines_all.batch_id = l_batch_id),
1558: NULL,
1559: sysdate,
1560: claim_amount - ozf_utility_pvt.currround(CASE
1561: WHEN((approved_amount is null and quantity_approved is null) OR ( approved_currency_code <> CLAIM_AMOUNT_CURRENCY_CODE ) OR approved_amount < 0 OR (original_claim_amount > 0 and quantity_approved < 0) ) then 0

Line 1581: WHERE fu.utilization_id = ozf_sd_batch_lines_all.utilization_id

1577: l_batch_currency,
1578: l_func_currency,
1579: (SELECT fu.exchange_rate_type
1580: FROM ozf_funds_utilized_all_b fu
1581: WHERE fu.utilization_id = ozf_sd_batch_lines_all.utilization_id
1582: AND ozf_sd_batch_lines_all.batch_id = l_batch_id),
1583: NULL,
1584: (SELECT fu.exchange_rate_date
1585: FROM ozf_funds_utilized_all_b fu

Line 1582: AND ozf_sd_batch_lines_all.batch_id = l_batch_id),

1578: l_func_currency,
1579: (SELECT fu.exchange_rate_type
1580: FROM ozf_funds_utilized_all_b fu
1581: WHERE fu.utilization_id = ozf_sd_batch_lines_all.utilization_id
1582: AND ozf_sd_batch_lines_all.batch_id = l_batch_id),
1583: NULL,
1584: (SELECT fu.exchange_rate_date
1585: FROM ozf_funds_utilized_all_b fu
1586: WHERE fu.utilization_id = ozf_sd_batch_lines_all.utilization_id

Line 1586: WHERE fu.utilization_id = ozf_sd_batch_lines_all.utilization_id

1582: AND ozf_sd_batch_lines_all.batch_id = l_batch_id),
1583: NULL,
1584: (SELECT fu.exchange_rate_date
1585: FROM ozf_funds_utilized_all_b fu
1586: WHERE fu.utilization_id = ozf_sd_batch_lines_all.utilization_id
1587: AND ozf_sd_batch_lines_all.batch_id = l_batch_id),
1588: claim_amount - ozf_utility_pvt.currround(CASE
1589: WHEN((approved_amount is null and quantity_approved is null) OR ( approved_currency_code <> CLAIM_AMOUNT_CURRENCY_CODE ) OR approved_amount < 0 OR (original_claim_amount > 0 and quantity_approved < 0) ) then 0
1590:

Line 1587: AND ozf_sd_batch_lines_all.batch_id = l_batch_id),

1583: NULL,
1584: (SELECT fu.exchange_rate_date
1585: FROM ozf_funds_utilized_all_b fu
1586: WHERE fu.utilization_id = ozf_sd_batch_lines_all.utilization_id
1587: AND ozf_sd_batch_lines_all.batch_id = l_batch_id),
1588: claim_amount - ozf_utility_pvt.currround(CASE
1589: WHEN((approved_amount is null and quantity_approved is null) OR ( approved_currency_code <> CLAIM_AMOUNT_CURRENCY_CODE ) OR approved_amount < 0 OR (original_claim_amount > 0 and quantity_approved < 0) ) then 0
1590:
1591: WHEN (approved_amount is null and quantity_approved IS NOT NULL AND DISCOUNT_TYPE IN ('NEWPRICE','%')) THEN ((list_price-agreement_price) * quantity_approved)

Line 1771: UPDATE ozf_sd_batch_lines_all

1767: FOR i IN 0..l_batch_comp_appr_lines_tbl.COUNT-1
1768: LOOP
1769: ozf_utility_pvt.debug_message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW, 'OZF_SD_BATCH_FEED_PVT::UPDATE_DATA',
1770: 'In completely approved lines if loop for batch line id '||l_batch_comp_appr_lines_tbl(i));
1771: UPDATE ozf_sd_batch_lines_all
1772: SET status_code = 'APPROVED',
1773: claim_amount = ozf_utility_pvt.currround(CASE
1774: WHEN((approved_amount is null and quantity_approved is null) OR ( approved_currency_code <> CLAIM_AMOUNT_CURRENCY_CODE ) OR approved_amount < 0 OR (original_claim_amount > 0 and quantity_approved < 0) ) then 0
1775:

Line 1809: WHERE fu.utilization_id = ozf_sd_batch_lines_all.utilization_id

1805: l_batch_currency,
1806: l_func_currency,
1807: (SELECT fu.exchange_rate_type
1808: FROM ozf_funds_utilized_all_b fu
1809: WHERE fu.utilization_id = ozf_sd_batch_lines_all.utilization_id
1810: AND ozf_sd_batch_lines_all.batch_id = l_batch_id),
1811: NULL,
1812: sysdate,
1813: CASE

Line 1810: AND ozf_sd_batch_lines_all.batch_id = l_batch_id),

1806: l_func_currency,
1807: (SELECT fu.exchange_rate_type
1808: FROM ozf_funds_utilized_all_b fu
1809: WHERE fu.utilization_id = ozf_sd_batch_lines_all.utilization_id
1810: AND ozf_sd_batch_lines_all.batch_id = l_batch_id),
1811: NULL,
1812: sysdate,
1813: CASE
1814: WHEN((approved_amount is null and quantity_approved is null) OR ( approved_currency_code <> CLAIM_AMOUNT_CURRENCY_CODE ) OR approved_amount < 0 OR (original_claim_amount > 0 and quantity_approved < 0) ) then 0

Line 1833: WHERE fu.utilization_id = ozf_sd_batch_lines_all.utilization_id

1829: l_batch_currency,
1830: l_func_currency,
1831: (SELECT fu.exchange_rate_type
1832: FROM ozf_funds_utilized_all_b fu
1833: WHERE fu.utilization_id = ozf_sd_batch_lines_all.utilization_id
1834: AND ozf_sd_batch_lines_all.batch_id = l_batch_id),
1835: NULL,
1836: (SELECT fu.exchange_rate_date
1837: FROM ozf_funds_utilized_all_b fu

Line 1834: AND ozf_sd_batch_lines_all.batch_id = l_batch_id),

1830: l_func_currency,
1831: (SELECT fu.exchange_rate_type
1832: FROM ozf_funds_utilized_all_b fu
1833: WHERE fu.utilization_id = ozf_sd_batch_lines_all.utilization_id
1834: AND ozf_sd_batch_lines_all.batch_id = l_batch_id),
1835: NULL,
1836: (SELECT fu.exchange_rate_date
1837: FROM ozf_funds_utilized_all_b fu
1838: WHERE fu.utilization_id = ozf_sd_batch_lines_all.utilization_id

Line 1838: WHERE fu.utilization_id = ozf_sd_batch_lines_all.utilization_id

1834: AND ozf_sd_batch_lines_all.batch_id = l_batch_id),
1835: NULL,
1836: (SELECT fu.exchange_rate_date
1837: FROM ozf_funds_utilized_all_b fu
1838: WHERE fu.utilization_id = ozf_sd_batch_lines_all.utilization_id
1839: AND ozf_sd_batch_lines_all.batch_id = l_batch_id),
1840: CASE
1841: WHEN((approved_amount is null and quantity_approved is null) OR ( approved_currency_code <> CLAIM_AMOUNT_CURRENCY_CODE ) OR approved_amount < 0 OR (original_claim_amount > 0 and quantity_approved < 0) ) then 0
1842:

Line 1839: AND ozf_sd_batch_lines_all.batch_id = l_batch_id),

1835: NULL,
1836: (SELECT fu.exchange_rate_date
1837: FROM ozf_funds_utilized_all_b fu
1838: WHERE fu.utilization_id = ozf_sd_batch_lines_all.utilization_id
1839: AND ozf_sd_batch_lines_all.batch_id = l_batch_id),
1840: CASE
1841: WHEN((approved_amount is null and quantity_approved is null) OR ( approved_currency_code <> CLAIM_AMOUNT_CURRENCY_CODE ) OR approved_amount < 0 OR (original_claim_amount > 0 and quantity_approved < 0) ) then 0
1842:
1843: WHEN (approved_amount is null and quantity_approved IS NOT NULL AND DISCOUNT_TYPE IN ('NEWPRICE','%')) THEN ((list_price-agreement_price) * quantity_approved)

Line 1881: UPDATE ozf_sd_batch_lines_all

1877: LOOP
1878: ozf_utility_pvt.debug_message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW, 'OZF_SD_BATCH_FEED_PVT::PROCESS_CHILD_BATCH',
1879: 'In over approved lines if loop for batch line id '||l_batch_over_appr_lines_tbl(i));
1880:
1881: UPDATE ozf_sd_batch_lines_all
1882: SET status_code = 'APPROVED',
1883: claim_amount = ozf_utility_pvt.currround(CASE
1884: WHEN((approved_amount is null and quantity_approved is null) OR ( approved_currency_code <> CLAIM_AMOUNT_CURRENCY_CODE ) OR approved_amount < 0 OR (original_claim_amount > 0 and quantity_approved < 0) ) then 0
1885:

Line 1919: WHERE fu.utilization_id = ozf_sd_batch_lines_all.utilization_id

1915: l_batch_currency,
1916: l_func_currency,
1917: (SELECT fu.exchange_rate_type
1918: FROM ozf_funds_utilized_all_b fu
1919: WHERE fu.utilization_id = ozf_sd_batch_lines_all.utilization_id
1920: AND ozf_sd_batch_lines_all.batch_id = l_batch_id),
1921: NULL,
1922: sysdate,
1923: CASE

Line 1920: AND ozf_sd_batch_lines_all.batch_id = l_batch_id),

1916: l_func_currency,
1917: (SELECT fu.exchange_rate_type
1918: FROM ozf_funds_utilized_all_b fu
1919: WHERE fu.utilization_id = ozf_sd_batch_lines_all.utilization_id
1920: AND ozf_sd_batch_lines_all.batch_id = l_batch_id),
1921: NULL,
1922: sysdate,
1923: CASE
1924: WHEN((approved_amount is null and quantity_approved is null) OR ( approved_currency_code <> CLAIM_AMOUNT_CURRENCY_CODE ) OR approved_amount < 0 OR (original_claim_amount > 0 and quantity_approved < 0) ) then 0

Line 1943: WHERE fu.utilization_id = ozf_sd_batch_lines_all.utilization_id

1939: l_batch_currency,
1940: l_func_currency,
1941: (SELECT fu.exchange_rate_type
1942: FROM ozf_funds_utilized_all_b fu
1943: WHERE fu.utilization_id = ozf_sd_batch_lines_all.utilization_id
1944: AND ozf_sd_batch_lines_all.batch_id = l_batch_id),
1945: NULL,
1946: (SELECT fu.exchange_rate_date
1947: FROM ozf_funds_utilized_all_b fu

Line 1944: AND ozf_sd_batch_lines_all.batch_id = l_batch_id),

1940: l_func_currency,
1941: (SELECT fu.exchange_rate_type
1942: FROM ozf_funds_utilized_all_b fu
1943: WHERE fu.utilization_id = ozf_sd_batch_lines_all.utilization_id
1944: AND ozf_sd_batch_lines_all.batch_id = l_batch_id),
1945: NULL,
1946: (SELECT fu.exchange_rate_date
1947: FROM ozf_funds_utilized_all_b fu
1948: WHERE fu.utilization_id = ozf_sd_batch_lines_all.utilization_id

Line 1948: WHERE fu.utilization_id = ozf_sd_batch_lines_all.utilization_id

1944: AND ozf_sd_batch_lines_all.batch_id = l_batch_id),
1945: NULL,
1946: (SELECT fu.exchange_rate_date
1947: FROM ozf_funds_utilized_all_b fu
1948: WHERE fu.utilization_id = ozf_sd_batch_lines_all.utilization_id
1949: AND ozf_sd_batch_lines_all.batch_id = l_batch_id),
1950: CASE
1951: WHEN((approved_amount is null and quantity_approved is null) OR ( approved_currency_code <> CLAIM_AMOUNT_CURRENCY_CODE ) OR approved_amount < 0 OR (original_claim_amount > 0 and quantity_approved < 0) ) then 0
1952:

Line 1949: AND ozf_sd_batch_lines_all.batch_id = l_batch_id),

1945: NULL,
1946: (SELECT fu.exchange_rate_date
1947: FROM ozf_funds_utilized_all_b fu
1948: WHERE fu.utilization_id = ozf_sd_batch_lines_all.utilization_id
1949: AND ozf_sd_batch_lines_all.batch_id = l_batch_id),
1950: CASE
1951: WHEN((approved_amount is null and quantity_approved is null) OR ( approved_currency_code <> CLAIM_AMOUNT_CURRENCY_CODE ) OR approved_amount < 0 OR (original_claim_amount > 0 and quantity_approved < 0) ) then 0
1952:
1953: WHEN (approved_amount is null and quantity_approved IS NOT NULL AND DISCOUNT_TYPE IN ('NEWPRICE','%')) THEN ((list_price-agreement_price) * quantity_approved)

Line 2022: UPDATE ozf_sd_batch_lines_all

2018: -- Status code of the under approved line has to be set as partially approved
2019: IF((l_batch_und_appr_lines_tbl IS NOT NULL) AND (l_batch_und_appr_lines_tbl.COUNT > 0)) THEN
2020: FOR i IN 0..l_batch_und_appr_lines_tbl.COUNT-1
2021: LOOP
2022: UPDATE ozf_sd_batch_lines_all
2023: SET status_code = 'PARTIALLY_APPROVED',
2024: claim_amount = claim_amount - ozf_utility_pvt.currround(CASE
2025: WHEN((approved_amount is null and quantity_approved is null) OR ( approved_currency_code <> CLAIM_AMOUNT_CURRENCY_CODE ) OR approved_amount < 0 OR (original_claim_amount > 0 and quantity_approved < 0) ) then 0
2026:

Line 2060: WHERE fu.utilization_id = ozf_sd_batch_lines_all.utilization_id

2056: l_batch_currency,
2057: l_func_currency,
2058: (SELECT fu.exchange_rate_type
2059: FROM ozf_funds_utilized_all_b fu
2060: WHERE fu.utilization_id = ozf_sd_batch_lines_all.utilization_id
2061: AND ozf_sd_batch_lines_all.batch_id = l_batch_id),
2062: NULL,
2063: sysdate,
2064: claim_amount - ozf_utility_pvt.currround(CASE

Line 2061: AND ozf_sd_batch_lines_all.batch_id = l_batch_id),

2057: l_func_currency,
2058: (SELECT fu.exchange_rate_type
2059: FROM ozf_funds_utilized_all_b fu
2060: WHERE fu.utilization_id = ozf_sd_batch_lines_all.utilization_id
2061: AND ozf_sd_batch_lines_all.batch_id = l_batch_id),
2062: NULL,
2063: sysdate,
2064: claim_amount - ozf_utility_pvt.currround(CASE
2065: WHEN((approved_amount is null and quantity_approved is null) OR ( approved_currency_code <> CLAIM_AMOUNT_CURRENCY_CODE ) OR approved_amount < 0 OR (original_claim_amount > 0 and quantity_approved < 0) ) then 0

Line 2085: WHERE fu.utilization_id = ozf_sd_batch_lines_all.utilization_id

2081: l_batch_currency,
2082: l_func_currency,
2083: (SELECT fu.exchange_rate_type
2084: FROM ozf_funds_utilized_all_b fu
2085: WHERE fu.utilization_id = ozf_sd_batch_lines_all.utilization_id
2086: AND ozf_sd_batch_lines_all.batch_id = l_batch_id),
2087: NULL,
2088: (SELECT fu.exchange_rate_date
2089: FROM ozf_funds_utilized_all_b fu

Line 2086: AND ozf_sd_batch_lines_all.batch_id = l_batch_id),

2082: l_func_currency,
2083: (SELECT fu.exchange_rate_type
2084: FROM ozf_funds_utilized_all_b fu
2085: WHERE fu.utilization_id = ozf_sd_batch_lines_all.utilization_id
2086: AND ozf_sd_batch_lines_all.batch_id = l_batch_id),
2087: NULL,
2088: (SELECT fu.exchange_rate_date
2089: FROM ozf_funds_utilized_all_b fu
2090: WHERE fu.utilization_id = ozf_sd_batch_lines_all.utilization_id

Line 2090: WHERE fu.utilization_id = ozf_sd_batch_lines_all.utilization_id

2086: AND ozf_sd_batch_lines_all.batch_id = l_batch_id),
2087: NULL,
2088: (SELECT fu.exchange_rate_date
2089: FROM ozf_funds_utilized_all_b fu
2090: WHERE fu.utilization_id = ozf_sd_batch_lines_all.utilization_id
2091: AND ozf_sd_batch_lines_all.batch_id = l_batch_id),
2092: claim_amount - ozf_utility_pvt.currround(CASE
2093: WHEN((approved_amount is null and quantity_approved is null) OR ( approved_currency_code <> CLAIM_AMOUNT_CURRENCY_CODE ) OR approved_amount < 0 OR (original_claim_amount > 0 and quantity_approved < 0) ) then 0
2094:

Line 2091: AND ozf_sd_batch_lines_all.batch_id = l_batch_id),

2087: NULL,
2088: (SELECT fu.exchange_rate_date
2089: FROM ozf_funds_utilized_all_b fu
2090: WHERE fu.utilization_id = ozf_sd_batch_lines_all.utilization_id
2091: AND ozf_sd_batch_lines_all.batch_id = l_batch_id),
2092: claim_amount - ozf_utility_pvt.currround(CASE
2093: WHEN((approved_amount is null and quantity_approved is null) OR ( approved_currency_code <> CLAIM_AMOUNT_CURRENCY_CODE ) OR approved_amount < 0 OR (original_claim_amount > 0 and quantity_approved < 0) ) then 0
2094:
2095: WHEN (approved_amount is null and quantity_approved IS NOT NULL AND DISCOUNT_TYPE IN ('NEWPRICE','%')) THEN ((list_price-agreement_price) * quantity_approved)

Line 2211: UPDATE ozf_sd_batch_lines_all

2207: FOR V_MISS_REJ_APP_REC IN C_MISS_REJ_APP
2208:
2209: LOOP
2210:
2211: UPDATE ozf_sd_batch_lines_all
2212: SET status_code = V_MISS_REJ_APP_REC.stat_code,
2213: approved_amount = (case when (original_claim_amount > 0) THEN V_MISS_REJ_APP_REC.auth_cost
2214: when (original_claim_amount < 0 AND V_MISS_REJ_APP_REC.line_status_code = 'APPROVED') then V_MISS_REJ_APP_REC.auth_cost end),
2215:

Line 2250: FROM ozf_sd_batch_lines_all

2246:
2247: --get total number of lines
2248: SELECT COUNT(1)
2249: INTO l_cnt_tot_line
2250: FROM ozf_sd_batch_lines_all
2251: WHERE batch_id = l_batch_id
2252: AND purge_flag <> 'Y';
2253:
2254: --get number of approved lines

Line 2257: FROM ozf_sd_batch_lines_all

2253:
2254: --get number of approved lines
2255: SELECT COUNT(1)
2256: INTO l_cnt_approved_lines
2257: FROM ozf_sd_batch_lines_all
2258: WHERE batch_id = l_batch_id
2259: AND status_code = 'APPROVED'
2260: AND purge_flag <> 'Y';
2261:

Line 2265: FROM ozf_sd_batch_lines_all

2261:
2262: --get number of rejected lines
2263: SELECT COUNT(1)
2264: INTO l_cnt_rejected_lines
2265: FROM ozf_sd_batch_lines_all
2266: WHERE batch_id = l_batch_id
2267: AND status_code = 'REJECTED'
2268: AND purge_flag <> 'Y';
2269:

Line 2408: l_batch_line_tbl_rec OZF_SD_BATCH_LINES_ALL%ROWTYPE;

2404: p_batch_comp_appr_lines_tbl IN number_tbl,
2405: x_return_status OUT nocopy VARCHAR2,
2406: x_msg_data OUT nocopy VARCHAR2) IS
2407:
2408: l_batch_line_tbl_rec OZF_SD_BATCH_LINES_ALL%ROWTYPE;
2409: l_cnt_total_line NUMBER;
2410: l_cnt_rejected_line NUMBER;
2411: l_new_batch_id NUMBER := NULL;
2412: l_message VARCHAR2(1000);

Line 2497: UPDATE ozf_sd_batch_lines_all

2493: l_par_batch_owner_id);
2494:
2495: -- if there are approved lines update the batch_id of the approved lines to the new batch id
2496: IF((p_batch_appr_lines_tbl IS NOT NULL) AND (p_batch_appr_lines_tbl.COUNT > 0)) THEN
2497: UPDATE ozf_sd_batch_lines_all
2498: SET batch_id = l_new_batch_id,
2499: object_version_number = object_version_number + 1,
2500: last_update_date = sysdate,
2501: last_updated_by = fnd_global.user_id

Line 2512: UPDATE ozf_sd_batch_lines_all

2508: FOR i IN 0..p_batch_comp_appr_lines_tbl.COUNT-1
2509: LOOP
2510: ozf_utility_pvt.debug_message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW, 'OZF_SD_BATCH_FEED_PVT::PROCESS_CHILD_BATCH',
2511: 'In completely approved lines if loop for batch line id '||p_batch_comp_appr_lines_tbl(i));
2512: UPDATE ozf_sd_batch_lines_all
2513: SET batch_id = l_new_batch_id,
2514: status_code = 'APPROVED',
2515: claim_amount = ozf_utility_pvt.currround(CASE
2516: WHEN((approved_amount is null and quantity_approved is null) OR ( approved_currency_code <> CLAIM_AMOUNT_CURRENCY_CODE ) OR approved_amount < 0 OR (original_claim_amount > 0 and quantity_approved < 0) ) then 0

Line 2551: WHERE fu.utilization_id = ozf_sd_batch_lines_all.utilization_id

2547: l_batch_currency,
2548: l_func_currency,
2549: (SELECT fu.exchange_rate_type
2550: FROM ozf_funds_utilized_all_b fu
2551: WHERE fu.utilization_id = ozf_sd_batch_lines_all.utilization_id
2552: AND ozf_sd_batch_lines_all.batch_id = p_batch_id),
2553: NULL,
2554: sysdate,
2555: CASE

Line 2552: AND ozf_sd_batch_lines_all.batch_id = p_batch_id),

2548: l_func_currency,
2549: (SELECT fu.exchange_rate_type
2550: FROM ozf_funds_utilized_all_b fu
2551: WHERE fu.utilization_id = ozf_sd_batch_lines_all.utilization_id
2552: AND ozf_sd_batch_lines_all.batch_id = p_batch_id),
2553: NULL,
2554: sysdate,
2555: CASE
2556: WHEN((approved_amount is null and quantity_approved is null) OR ( approved_currency_code <> CLAIM_AMOUNT_CURRENCY_CODE ) OR approved_amount < 0 OR (original_claim_amount > 0 and quantity_approved < 0) ) then 0

Line 2575: WHERE fu.utilization_id = ozf_sd_batch_lines_all.utilization_id

2571: l_batch_currency,
2572: l_func_currency,
2573: (SELECT fu.exchange_rate_type
2574: FROM ozf_funds_utilized_all_b fu
2575: WHERE fu.utilization_id = ozf_sd_batch_lines_all.utilization_id
2576: AND ozf_sd_batch_lines_all.batch_id = p_batch_id),
2577: NULL,
2578: (SELECT fu.exchange_rate_date
2579: FROM ozf_funds_utilized_all_b fu

Line 2576: AND ozf_sd_batch_lines_all.batch_id = p_batch_id),

2572: l_func_currency,
2573: (SELECT fu.exchange_rate_type
2574: FROM ozf_funds_utilized_all_b fu
2575: WHERE fu.utilization_id = ozf_sd_batch_lines_all.utilization_id
2576: AND ozf_sd_batch_lines_all.batch_id = p_batch_id),
2577: NULL,
2578: (SELECT fu.exchange_rate_date
2579: FROM ozf_funds_utilized_all_b fu
2580: WHERE fu.utilization_id = ozf_sd_batch_lines_all.utilization_id

Line 2580: WHERE fu.utilization_id = ozf_sd_batch_lines_all.utilization_id

2576: AND ozf_sd_batch_lines_all.batch_id = p_batch_id),
2577: NULL,
2578: (SELECT fu.exchange_rate_date
2579: FROM ozf_funds_utilized_all_b fu
2580: WHERE fu.utilization_id = ozf_sd_batch_lines_all.utilization_id
2581: AND ozf_sd_batch_lines_all.batch_id = p_batch_id),
2582: CASE
2583: WHEN((approved_amount is null and quantity_approved is null) OR ( approved_currency_code <> CLAIM_AMOUNT_CURRENCY_CODE ) OR approved_amount < 0 OR (original_claim_amount > 0 and quantity_approved < 0) ) then 0
2584:

Line 2581: AND ozf_sd_batch_lines_all.batch_id = p_batch_id),

2577: NULL,
2578: (SELECT fu.exchange_rate_date
2579: FROM ozf_funds_utilized_all_b fu
2580: WHERE fu.utilization_id = ozf_sd_batch_lines_all.utilization_id
2581: AND ozf_sd_batch_lines_all.batch_id = p_batch_id),
2582: CASE
2583: WHEN((approved_amount is null and quantity_approved is null) OR ( approved_currency_code <> CLAIM_AMOUNT_CURRENCY_CODE ) OR approved_amount < 0 OR (original_claim_amount > 0 and quantity_approved < 0) ) then 0
2584:
2585: WHEN (approved_amount is null and quantity_approved IS NOT NULL AND DISCOUNT_TYPE IN ('NEWPRICE','%')) THEN ((list_price-agreement_price) * quantity_approved)

Line 2626: FROM OZF_SD_BATCH_LINES_ALL

2622: ozf_utility_pvt.debug_message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW, 'OZF_SD_BATCH_FEED_PVT::PROCESS_CHILD_BATCH',
2623: 'In under approved lines if loop for batch line id '||p_batch_undr_appr_lines_tbl(i));
2624:
2625: SELECT * INTO l_batch_line_tbl_rec
2626: FROM OZF_SD_BATCH_LINES_ALL
2627: WHERE batch_id = p_batch_id
2628: AND batch_line_id =p_batch_undr_appr_lines_tbl(i);
2629:
2630: l_line_clm_amt := ozf_utility_pvt.currround(CASE

Line 2714: ozf_sd_batch_lines_all

2710: l_batch_currency,
2711: l_func_currency,
2712: (SELECT fu.exchange_rate_type
2713: FROM ozf_funds_utilized_all_b fu,
2714: ozf_sd_batch_lines_all
2715: WHERE fu.utilization_id = ozf_sd_batch_lines_all.utilization_id
2716: AND ozf_sd_batch_lines_all.batch_line_id =l_batch_line_tbl_rec.batch_line_id),
2717: NULL,
2718: sysdate,

Line 2715: WHERE fu.utilization_id = ozf_sd_batch_lines_all.utilization_id

2711: l_func_currency,
2712: (SELECT fu.exchange_rate_type
2713: FROM ozf_funds_utilized_all_b fu,
2714: ozf_sd_batch_lines_all
2715: WHERE fu.utilization_id = ozf_sd_batch_lines_all.utilization_id
2716: AND ozf_sd_batch_lines_all.batch_line_id =l_batch_line_tbl_rec.batch_line_id),
2717: NULL,
2718: sysdate,
2719: CASE WHEN((l_batch_line_tbl_rec.approved_amount is null

Line 2716: AND ozf_sd_batch_lines_all.batch_line_id =l_batch_line_tbl_rec.batch_line_id),

2712: (SELECT fu.exchange_rate_type
2713: FROM ozf_funds_utilized_all_b fu,
2714: ozf_sd_batch_lines_all
2715: WHERE fu.utilization_id = ozf_sd_batch_lines_all.utilization_id
2716: AND ozf_sd_batch_lines_all.batch_line_id =l_batch_line_tbl_rec.batch_line_id),
2717: NULL,
2718: sysdate,
2719: CASE WHEN((l_batch_line_tbl_rec.approved_amount is null
2720: and l_batch_line_tbl_rec.quantity_approved is null)

Line 2762: ozf_sd_batch_lines_all

2758: l_batch_currency,
2759: l_func_currency,
2760: (SELECT fu.exchange_rate_type
2761: FROM ozf_funds_utilized_all_b fu,
2762: ozf_sd_batch_lines_all
2763: WHERE fu.utilization_id = ozf_sd_batch_lines_all.utilization_id
2764: AND ozf_sd_batch_lines_all.batch_line_id =l_batch_line_tbl_rec.batch_line_id),
2765: NULL,
2766: (SELECT fu.exchange_rate_date

Line 2763: WHERE fu.utilization_id = ozf_sd_batch_lines_all.utilization_id

2759: l_func_currency,
2760: (SELECT fu.exchange_rate_type
2761: FROM ozf_funds_utilized_all_b fu,
2762: ozf_sd_batch_lines_all
2763: WHERE fu.utilization_id = ozf_sd_batch_lines_all.utilization_id
2764: AND ozf_sd_batch_lines_all.batch_line_id =l_batch_line_tbl_rec.batch_line_id),
2765: NULL,
2766: (SELECT fu.exchange_rate_date
2767: FROM ozf_funds_utilized_all_b fu,

Line 2764: AND ozf_sd_batch_lines_all.batch_line_id =l_batch_line_tbl_rec.batch_line_id),

2760: (SELECT fu.exchange_rate_type
2761: FROM ozf_funds_utilized_all_b fu,
2762: ozf_sd_batch_lines_all
2763: WHERE fu.utilization_id = ozf_sd_batch_lines_all.utilization_id
2764: AND ozf_sd_batch_lines_all.batch_line_id =l_batch_line_tbl_rec.batch_line_id),
2765: NULL,
2766: (SELECT fu.exchange_rate_date
2767: FROM ozf_funds_utilized_all_b fu,
2768: ozf_sd_batch_lines_all

Line 2768: ozf_sd_batch_lines_all

2764: AND ozf_sd_batch_lines_all.batch_line_id =l_batch_line_tbl_rec.batch_line_id),
2765: NULL,
2766: (SELECT fu.exchange_rate_date
2767: FROM ozf_funds_utilized_all_b fu,
2768: ozf_sd_batch_lines_all
2769: WHERE fu.utilization_id = ozf_sd_batch_lines_all.utilization_id
2770: AND ozf_sd_batch_lines_all.batch_line_id =l_batch_line_tbl_rec.batch_line_id),
2771: CASE WHEN((l_batch_line_tbl_rec.approved_amount is null
2772: and l_batch_line_tbl_rec.quantity_approved is null)

Line 2769: WHERE fu.utilization_id = ozf_sd_batch_lines_all.utilization_id

2765: NULL,
2766: (SELECT fu.exchange_rate_date
2767: FROM ozf_funds_utilized_all_b fu,
2768: ozf_sd_batch_lines_all
2769: WHERE fu.utilization_id = ozf_sd_batch_lines_all.utilization_id
2770: AND ozf_sd_batch_lines_all.batch_line_id =l_batch_line_tbl_rec.batch_line_id),
2771: CASE WHEN((l_batch_line_tbl_rec.approved_amount is null
2772: and l_batch_line_tbl_rec.quantity_approved is null)
2773: OR ( l_batch_line_tbl_rec.approved_currency_code <> l_batch_line_tbl_rec.CLAIM_AMOUNT_CURRENCY_CODE )

Line 2770: AND ozf_sd_batch_lines_all.batch_line_id =l_batch_line_tbl_rec.batch_line_id),

2766: (SELECT fu.exchange_rate_date
2767: FROM ozf_funds_utilized_all_b fu,
2768: ozf_sd_batch_lines_all
2769: WHERE fu.utilization_id = ozf_sd_batch_lines_all.utilization_id
2770: AND ozf_sd_batch_lines_all.batch_line_id =l_batch_line_tbl_rec.batch_line_id),
2771: CASE WHEN((l_batch_line_tbl_rec.approved_amount is null
2772: and l_batch_line_tbl_rec.quantity_approved is null)
2773: OR ( l_batch_line_tbl_rec.approved_currency_code <> l_batch_line_tbl_rec.CLAIM_AMOUNT_CURRENCY_CODE )
2774: OR l_batch_line_tbl_rec.approved_amount < 0 OR (l_batch_line_tbl_rec.original_claim_amount > 0

Line 2812: INSERT INTO OZF_SD_BATCH_LINES_ALL

2808:
2809: ozf_utility_pvt.debug_message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW, 'OZF_SD_BATCH_FEED_PVT::PROCESS_CHILD_BATCH',
2810: 'In under approved lines if loop for batch line id '||p_batch_undr_appr_lines_tbl(i) ||' claim amount in batch currency l_line_batch_curr_clm_amt: '||l_line_batch_curr_clm_amt);
2811:
2812: INSERT INTO OZF_SD_BATCH_LINES_ALL
2813: (batch_line_id,
2814: object_version_number,
2815: batch_id,
2816: batch_line_number,

Line 2907: (OZF_SD_BATCH_LINES_ALL_S.NEXTVAL,

2903: ATTRIBUTE30,
2904: process_feed_flag
2905:
2906: )values
2907: (OZF_SD_BATCH_LINES_ALL_S.NEXTVAL,
2908: 1,
2909: l_new_batch_id,
2910: l_batch_line_tbl_rec.batch_line_number,
2911: l_batch_line_tbl_rec.utilization_id,

Line 3018: UPDATE ozf_sd_batch_lines_all

3014: LOOP
3015: ozf_utility_pvt.debug_message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW, 'OZF_SD_BATCH_FEED_PVT::PROCESS_CHILD_BATCH',
3016: 'In over approved lines if loop for batch line id '||p_batch_over_appr_lines_tbl(i));
3017:
3018: UPDATE ozf_sd_batch_lines_all
3019: SET batch_id = l_new_batch_id,
3020: status_code = 'APPROVED',
3021: claim_amount = ozf_utility_pvt.currround(CASE
3022: WHEN((approved_amount is null and quantity_approved is null) OR ( approved_currency_code <> CLAIM_AMOUNT_CURRENCY_CODE ) OR approved_amount < 0 OR (original_claim_amount > 0 and quantity_approved < 0) ) then 0

Line 3057: WHERE fu.utilization_id = ozf_sd_batch_lines_all.utilization_id

3053: l_batch_currency,
3054: l_func_currency,
3055: (SELECT fu.exchange_rate_type
3056: FROM ozf_funds_utilized_all_b fu
3057: WHERE fu.utilization_id = ozf_sd_batch_lines_all.utilization_id
3058: AND ozf_sd_batch_lines_all.batch_id = p_batch_id),
3059: NULL,
3060: sysdate,
3061: CASE

Line 3058: AND ozf_sd_batch_lines_all.batch_id = p_batch_id),

3054: l_func_currency,
3055: (SELECT fu.exchange_rate_type
3056: FROM ozf_funds_utilized_all_b fu
3057: WHERE fu.utilization_id = ozf_sd_batch_lines_all.utilization_id
3058: AND ozf_sd_batch_lines_all.batch_id = p_batch_id),
3059: NULL,
3060: sysdate,
3061: CASE
3062: WHEN((approved_amount is null and quantity_approved is null) OR ( approved_currency_code <> CLAIM_AMOUNT_CURRENCY_CODE ) OR approved_amount < 0 OR (original_claim_amount > 0 and quantity_approved < 0) ) then 0

Line 3081: WHERE fu.utilization_id = ozf_sd_batch_lines_all.utilization_id

3077: l_batch_currency,
3078: l_func_currency,
3079: (SELECT fu.exchange_rate_type
3080: FROM ozf_funds_utilized_all_b fu
3081: WHERE fu.utilization_id = ozf_sd_batch_lines_all.utilization_id
3082: AND ozf_sd_batch_lines_all.batch_id = p_batch_id),
3083: NULL,
3084: (SELECT fu.exchange_rate_date
3085: FROM ozf_funds_utilized_all_b fu

Line 3082: AND ozf_sd_batch_lines_all.batch_id = p_batch_id),

3078: l_func_currency,
3079: (SELECT fu.exchange_rate_type
3080: FROM ozf_funds_utilized_all_b fu
3081: WHERE fu.utilization_id = ozf_sd_batch_lines_all.utilization_id
3082: AND ozf_sd_batch_lines_all.batch_id = p_batch_id),
3083: NULL,
3084: (SELECT fu.exchange_rate_date
3085: FROM ozf_funds_utilized_all_b fu
3086: WHERE fu.utilization_id = ozf_sd_batch_lines_all.utilization_id

Line 3086: WHERE fu.utilization_id = ozf_sd_batch_lines_all.utilization_id

3082: AND ozf_sd_batch_lines_all.batch_id = p_batch_id),
3083: NULL,
3084: (SELECT fu.exchange_rate_date
3085: FROM ozf_funds_utilized_all_b fu
3086: WHERE fu.utilization_id = ozf_sd_batch_lines_all.utilization_id
3087: AND ozf_sd_batch_lines_all.batch_id = p_batch_id),
3088: CASE
3089: WHEN((approved_amount is null and quantity_approved is null) OR ( approved_currency_code <> CLAIM_AMOUNT_CURRENCY_CODE ) OR approved_amount < 0 OR (original_claim_amount > 0 and quantity_approved < 0) ) then 0
3090:

Line 3087: AND ozf_sd_batch_lines_all.batch_id = p_batch_id),

3083: NULL,
3084: (SELECT fu.exchange_rate_date
3085: FROM ozf_funds_utilized_all_b fu
3086: WHERE fu.utilization_id = ozf_sd_batch_lines_all.utilization_id
3087: AND ozf_sd_batch_lines_all.batch_id = p_batch_id),
3088: CASE
3089: WHEN((approved_amount is null and quantity_approved is null) OR ( approved_currency_code <> CLAIM_AMOUNT_CURRENCY_CODE ) OR approved_amount < 0 OR (original_claim_amount > 0 and quantity_approved < 0) ) then 0
3090:
3091: WHEN (approved_amount is null and quantity_approved IS NOT NULL AND DISCOUNT_TYPE IN ('NEWPRICE','%')) THEN ((list_price-agreement_price) * quantity_approved)

Line 3204: UPDATE ozf_sd_batch_lines_all

3200: l_new_batch_id,
3201: l_batch_type,
3202: l_par_batch_owner_id);
3203:
3204: UPDATE ozf_sd_batch_lines_all
3205: SET batch_id = l_new_batch_id,
3206: object_version_number = object_version_number + 1,
3207: last_update_date = sysdate,
3208: last_updated_by = fnd_global.user_id

Line 3223: from ozf_sd_batch_lines_all

3219: --to get claim number
3220: -- Check if the child batch is having -ve claim sum
3221: select sum(batch_curr_claim_amount)
3222: INTO l_tot_app_claim_amt
3223: from ozf_sd_batch_lines_all
3224: where batch_id=l_new_batch_id ;
3225:
3226:
3227:

Line 3350: select sum(batch_curr_claim_amount) INTO l_tot_app_claim_amt from ozf_sd_batch_lines_all

3346: -- Check if the batch is negative
3347: --Start:Fix for Bug#10628160 - Create a Claim with new custom setup for -ve amount
3348: --to get claim number
3349:
3350: select sum(batch_curr_claim_amount) INTO l_tot_app_claim_amt from ozf_sd_batch_lines_all
3351: where batch_id=p_batch_id ;
3352:
3353: ozf_utility_pvt.debug_message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW, 'OZF_SD_BATCH_FEED_PVT::UPDATE_DATA',
3354: ' l_tot_app_claim_amt = ' || l_tot_app_claim_amt);

Line 3462: FROM ozf_sd_batch_lines_all bl,

3458: bint.gbl_claim_rej_code7,
3459: bint.gbl_claim_rej_code8,
3460: bint.gbl_claim_rej_code9,
3461: bint.gbl_claim_rej_code10
3462: FROM ozf_sd_batch_lines_all bl,
3463: ozf_sd_batch_lines_int_all bint
3464: WHERE bl.batch_id = bint.ship_frm_sd_claim_request_id
3465: AND bl.batch_line_number = bint.batch_line_number
3466: AND bint.GBL_CLAIM_DISPOSITION_CODE = 'REJECTED'