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_UTIL_PVT dependencies on OZF_SD_BATCH_LINES_ALL

Line 30: select UTILIZATION_ID,CLAIM_AMOUNT_CURRENCY_CODE into l_util_id,l_from_currency from OZF_SD_BATCH_LINES_ALL where batch_line_id=p_batch_line_id;

26: l_util_id NUMBER;
27: x_return_status VARCHAR2(200);
28: begin
29:
30: select UTILIZATION_ID,CLAIM_AMOUNT_CURRENCY_CODE into l_util_id,l_from_currency from OZF_SD_BATCH_LINES_ALL where batch_line_id=p_batch_line_id;
31:
32: -- select currency_code into l_from_currency from OZF_FUNDS_UTILIZED_ALL_B where utilization_id=l_util_id;
33:
34: select currency_code into l_to_currency from ozf_sd_batch_headers_all

Line 35: where batch_id=(select batch_id from ozf_sd_batch_lines_all

31:
32: -- select currency_code into l_from_currency from OZF_FUNDS_UTILIZED_ALL_B where utilization_id=l_util_id;
33:
34: select currency_code into l_to_currency from ozf_sd_batch_headers_all
35: where batch_id=(select batch_id from ozf_sd_batch_lines_all
36: where batch_line_id = p_batch_line_id);
37:
38: -- select exchange_rate_date into l_conv_date from OZF_FUNDS_UTILIZED_ALL_B where utilization_id=l_util_id;
39:

Line 161: from OZF_SD_BATCH_LINES_ALL

157: begin
158:
159: select UTILIZATION_ID ,claim_amount,acctd_amount_remaining,univ_curr_amount_remaining,fund_request_amount_remaining,amount_remaining
160: into l_util_id, l_claim_amount ,l_acctd_amount_remaining,l_univ_curr_amount_remaining,l_fund_req_amount_remaining,l_amount_remaining
161: from OZF_SD_BATCH_LINES_ALL
162: where batch_line_id=p_batch_line_id;
163:
164:
165:

Line 175: DELETE FROM OZF_SD_BATCH_LINES_ALL WHERE batch_line_id=p_batch_line_id;

171: fund_request_amount_remaining=fund_request_amount_remaining+l_fund_req_amount_remaining
172:
173: WHERE UTILIZATION_ID=l_util_id;
174:
175: DELETE FROM OZF_SD_BATCH_LINES_ALL WHERE batch_line_id=p_batch_line_id;
176: x_return_status := FND_API.G_RET_STS_SUCCESS;
177: x_meaning := NULL;
178:
179:

Line 824: UPDATE OZF_SD_BATCH_LINES_ALL

820: --If partial approved is allowed for a batch then on batch closure we just do adjustments
821: IF l_imd_claim_flag ='Y' THEN
822:
823:
824: UPDATE OZF_SD_BATCH_LINES_ALL
825: SET status_code ='APPROVED'
826: WHERE BATCH_ID = p_batch_header_id
827: AND COMPLETE_FLAG ='Y'
828: AND PURGE_FLAG <>'Y'

Line 880: from OZF_SD_BATCH_LINES_ALL line

876: WHEN (QUANTITY_APPROVED is not null and quantity_approved <> 0 and approved_amount is not null and approved_amount <> 0 AND DISCOUNT_TYPE IN ('NEWPRICE','%')) THEN ((list_price - approved_amount) )
877: WHEN (QUANTITY_APPROVED is not null and quantity_approved <> 0 and approved_amount is not null and approved_amount <> 0 AND DISCOUNT_TYPE IN ('AMT')) THEN (approved_amount)
878: END approved_unit_claim_amount
879:
880: from OZF_SD_BATCH_LINES_ALL line
881: WHERE line.complete_flag ='Y'
882: AND line.batch_id = p_batch_header_id
883: AND line.purge_flag <>'Y'
884: AND line.ORIGINAL_CLAIM_AMOUNT >0

Line 897: FROM OZF_SD_BATCH_LINES_ALL

893: all_lines.total_count
894: INTO l_orig_app_line_count, l_orig_total_line_count
895: FROM
896: (SELECT COUNT(1) total_count
897: FROM OZF_SD_BATCH_LINES_ALL
898: WHERE batch_id = p_batch_header_id
899: ) all_lines,
900: (SELECT COUNT(1) app_count
901: FROM OZF_SD_BATCH_LINES_ALL

Line 901: FROM OZF_SD_BATCH_LINES_ALL

897: FROM OZF_SD_BATCH_LINES_ALL
898: WHERE batch_id = p_batch_header_id
899: ) all_lines,
900: (SELECT COUNT(1) app_count
901: FROM OZF_SD_BATCH_LINES_ALL
902: WHERE batch_id = p_batch_header_id
903: AND status_code IN ('APPROVED')
904: ) app_lines ;
905:

Line 910: UPDATE OZF_SD_BATCH_LINES_ALL

906:
907:
908: IF (l_total_app_claim_amt>0) THEN
909:
910: UPDATE OZF_SD_BATCH_LINES_ALL
911: SET status_code ='APPROVED'
912: WHERE batch_id = p_batch_header_id
913: AND batch_line_id IN
914: (

Line 916: from OZF_SD_BATCH_LINES_ALL line

912: WHERE batch_id = p_batch_header_id
913: AND batch_line_id IN
914: (
915: select line.batch_line_id
916: from OZF_SD_BATCH_LINES_ALL line
917: WHERE line.complete_flag ='Y'
918: AND line.batch_id = p_batch_header_id
919: AND line.purge_flag <>'Y'
920: AND line.ORIGINAL_CLAIM_AMOUNT >0

Line 945: FROM OZF_SD_BATCH_LINES_ALL

941: all_lines.total_count
942: INTO l_unapproved_line_count, l_approved_line_count, l_total_line_count
943: FROM
944: (SELECT COUNT(1) total_count
945: FROM OZF_SD_BATCH_LINES_ALL
946: WHERE batch_id = p_batch_header_id
947: ) all_lines,
948: (SELECT COUNT(1) app_count
949: FROM OZF_SD_BATCH_LINES_ALL

Line 949: FROM OZF_SD_BATCH_LINES_ALL

945: FROM OZF_SD_BATCH_LINES_ALL
946: WHERE batch_id = p_batch_header_id
947: ) all_lines,
948: (SELECT COUNT(1) app_count
949: FROM OZF_SD_BATCH_LINES_ALL
950: WHERE batch_id = p_batch_header_id
951: AND status_code IN ('APPROVED')
952: ) app_lines ;
953:

Line 1076: FROM OZF_SD_BATCH_LINES_ALL

1072: SELECT (all_lines.total_count - (app_lines.app_count + com_lines.com_count + rma_lines.rma_count))
1073: INTO l_unapproved_line_count
1074: FROM
1075: (SELECT COUNT(1) total_count
1076: FROM OZF_SD_BATCH_LINES_ALL
1077: WHERE batch_id = p_batch_header_id
1078: ) all_lines,
1079: (SELECT COUNT(1) app_count
1080: FROM OZF_SD_BATCH_LINES_ALL

Line 1080: FROM OZF_SD_BATCH_LINES_ALL

1076: FROM OZF_SD_BATCH_LINES_ALL
1077: WHERE batch_id = p_batch_header_id
1078: ) all_lines,
1079: (SELECT COUNT(1) app_count
1080: FROM OZF_SD_BATCH_LINES_ALL
1081: WHERE batch_id = p_batch_header_id
1082: AND status_code = 'APPROVED'
1083: ) app_lines,
1084: (SELECT COUNT(1) com_count

Line 1085: FROM OZF_SD_BATCH_LINES_ALL

1081: WHERE batch_id = p_batch_header_id
1082: AND status_code = 'APPROVED'
1083: ) app_lines,
1084: (SELECT COUNT(1) com_count
1085: FROM OZF_SD_BATCH_LINES_ALL
1086: WHERE batch_id = p_batch_header_id
1087: AND status_code = 'COMPLETED'
1088: ) com_lines,
1089: (SELECT COUNT(1) rma_count

Line 1090: FROM OZF_SD_BATCH_LINES_ALL

1086: WHERE batch_id = p_batch_header_id
1087: AND status_code = 'COMPLETED'
1088: ) com_lines,
1089: (SELECT COUNT(1) rma_count
1090: FROM OZF_SD_BATCH_LINES_ALL
1091: WHERE batch_id = p_batch_header_id
1092: AND ORIGINAL_CLAIM_AMOUNT < 0
1093: ) rma_lines ;
1094:

Line 1179: FROM OZF_SD_BATCH_LINES_ALL lines ,

1175: util.plan_currency_code,
1176: util.plan_type,
1177: util.plan_id,
1178: util.exchange_rate_date
1179: FROM OZF_SD_BATCH_LINES_ALL lines ,
1180: ozf_funds_utilized_all_b util,
1181: ozf_claim_types_all_vl adj
1182:
1183: WHERE lines.batch_id = p_batch_header_id

Line 1294: UPDATE OZF_SD_BATCH_LINES_ALL

1290: -- If complete write off, then change the line status to COMPLETE and update the new utlization iD
1291: -- Else update the utilization id but the line status
1292: IF (p_comp_wrt_off = fnd_api.g_true) THEN
1293:
1294: UPDATE OZF_SD_BATCH_LINES_ALL
1295: SET ADJ_UTILIZATION_ID = l_new_util_id,
1296: status_code = 'COMPLETED'
1297: WHERE batch_line_id = adj_rec.batch_line_id ;
1298:

Line 1300: UPDATE OZF_SD_BATCH_LINES_ALL

1296: status_code = 'COMPLETED'
1297: WHERE batch_line_id = adj_rec.batch_line_id ;
1298:
1299: ELSE
1300: UPDATE OZF_SD_BATCH_LINES_ALL
1301: SET ADJ_UTILIZATION_ID = l_new_util_id
1302: WHERE batch_line_id = adj_rec.batch_line_id;
1303:
1304: END IF;

Line 1430: UPDATE OZF_SD_BATCH_LINES_ALL

1426: BEGIN
1427:
1428: x_return_status := FND_API.G_RET_STS_SUCCESS ;
1429:
1430: UPDATE OZF_SD_BATCH_LINES_ALL
1431: SET complete_flag='Y'
1432: WHERE batch_id=p_batch_header_id ;
1433:
1434: COMMIT;

Line 1470: FROM OZF_SD_BATCH_LINES_ALL

1466: BEGIN
1467: x_return_status := FND_API.G_RET_STS_SUCCESS ;
1468:
1469: SELECT COUNT(1) INTO l_incomplete_count
1470: FROM OZF_SD_BATCH_LINES_ALL
1471: WHERE status_code IN( 'REJECTED','SUBMITTED')
1472: AND NVL(complete_flag,'N')<>'Y'
1473: AND batch_id=p_batch_header_id ;
1474: