APPS.OZF_CLAIM_ACCRUAL_PVT dependencies on OZF_CLAIM_LINES_UTIL_ALL

Line 2276: FROM ozf_claim_lines_util_all

2272:
2273: /*CURSOR csr_total_util_lines (cv_claim_line_id IN NUMBER)IS
2274: SELECT COUNT(1),
2275: MAX(claim_line_util_id)
2276: FROM ozf_claim_lines_util_all
2277: WHERE claim_line_id = cv_claim_line_id; */
2278:
2279: l_sum_amount NUMBER :=0;
2280: l_last_record_num NUMBER := 0;

Line 2430: INSERT INTO ozf_claim_lines_util_all (

2426: END IF;
2427:
2428: IF l_line_util_tbl.COUNT = G_BULK_LIMIT OR i = p_line_util_tbl.LAST THEN
2429: FORALL i IN NVL(l_line_util_tbl.FIRST, 1) .. NVL(l_line_util_tbl.LAST, 0)
2430: INSERT INTO ozf_claim_lines_util_all (
2431: claim_line_util_id,
2432: object_version_number,
2433: last_update_date,
2434: last_updated_by,

Line 2550: UPDATE ozf_claim_lines_util_all

2546: l_line_util_amount := l_line_util_amount + (l_entered_diff_amount - l_sum_amount);
2547:
2548: -- Round the Last Record
2549: IF l_original_total_amount <> 0 THEN --ninarasi fix for 12.2 bug
2550: UPDATE ozf_claim_lines_util_all
2551: SET amount = l_line_util_amount
2552: WHERE claim_line_util_id = l_last_line_util_id;
2553: END IF;
2554:

Line 2658: SELECT ozf_claim_lines_util_all_s.NEXTVAL

2654: l_convert_exchange_rate NUMBER;
2655: l_counter NUMBER;
2656:
2657: CURSOR csr_line_util_seq IS
2658: SELECT ozf_claim_lines_util_all_s.NEXTVAL
2659: FROM DUAL;
2660:
2661: CURSOR csr_line_util_count(cv_line_util_id IN NUMBER) IS
2662: SELECT COUNT(claim_line_util_id)

Line 2833: /*INSERT INTO ozf_claim_lines_util_all (

2829:
2830: px_line_util_tbl(l_counter) := l_line_util_rec;
2831:
2832: --ninarasi fix for bug 13530939
2833: /*INSERT INTO ozf_claim_lines_util_all (
2834: claim_line_util_id,
2835: object_version_number,
2836: last_update_date,
2837: last_updated_by,

Line 3399: UPDATE ozf_claim_lines_util_all SET

3395: IF OZF_DEBUG_HIGH_ON THEN
3396: OZF_Utility_PVT.debug_message(l_full_name ||': update lines utilized');
3397: END IF;
3398:
3399: UPDATE ozf_claim_lines_util_all SET
3400: object_version_number = l_line_util_rec.object_version_number,
3401: last_update_date = SYSDATE,
3402: last_updated_by = l_line_util_rec.last_updated_by,
3403: last_update_login = l_line_util_rec.last_update_login,

Line 3529: FROM ozf_claim_lines_util_all

3525: l_currency_rec currency_rec_type := p_currency_rec;
3526:
3527: CURSOR csr_util_obj_ver(cv_line_util_id IN NUMBER) IS
3528: SELECT object_version_number
3529: FROM ozf_claim_lines_util_all
3530: WHERE claim_line_util_id = cv_line_util_id;
3531:
3532: BEGIN
3533: --------------------- initialize -----------------------

Line 4094: DELETE FROM ozf_claim_lines_util_all

4090: IF OZF_DEBUG_HIGH_ON THEN
4091: OZF_Utility_PVT.debug_message(l_full_name ||': delete');
4092: END IF;
4093:
4094: DELETE FROM ozf_claim_lines_util_all
4095: WHERE claim_line_util_id = p_line_util_id
4096: AND object_version_number = p_object_version;
4097:
4098: IF (SQL%NOTFOUND) THEN

Line 10291: DELETE FROM ozf_claim_lines_util_all

10287:
10288: END IF; -- p_line_util_rec.utilization_id > 0
10289:
10290: ------------------------ delete ------------------------
10291: DELETE FROM ozf_claim_lines_util_all
10292: WHERE claim_line_util_id = p_line_util_rec.claim_line_util_id;
10293:
10294: IF (SQL%NOTFOUND) THEN
10295: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN

Line 11050: DELETE FROM ozf_claim_lines_util_all

11046: */
11047: END IF;
11048:
11049: -- delete dummy utilizations
11050: DELETE FROM ozf_claim_lines_util_all
11051: WHERE claim_line_util_id = p_claim_line_util_id;
11052:
11053: ---------- Create Group Line Utils -------------------
11054: --Need to check

Line 11200: FROM ozf_claim_lines_util_all lu

11196: -- the coupon count(scan_unit) is independent of the offer and claim uom code
11197: CURSOR csr_line_utils(cv_claim_id IN NUMBER) IS
11198: SELECT SUM(lu.scan_unit * amp.quantity)
11199: ,lu.utilization_id
11200: FROM ozf_claim_lines_util_all lu
11201: ,ozf_claim_lines_all cln
11202: ,ams_act_products amp
11203: WHERE cln.claim_id = cv_claim_id
11204: AND lu.claim_line_id = cln.claim_line_id