APPS.OZF_CLAIM_ACCRUAL_PVT dependencies on OZF_CLAIM_LINES_UTIL_ALL

Line 2102: UPDATE ozf_claim_lines_util_all

2098: OZF_Utility_PVT.debug_message('l_original_total_amount'||l_original_total_amount);
2099: OZF_Utility_PVT.debug_message('l_sum_amount'||l_sum_amount);
2100: END IF;
2101:
2102: UPDATE ozf_claim_lines_util_all
2103: SET amount = l_line_util_amount
2104: WHERE claim_line_util_id = l_last_record_num;
2105:
2106: END IF;

Line 2211: SELECT ozf_claim_lines_util_all_s.NEXTVAL

2207: l_exchange_rate NUMBER;
2208:
2209:
2210: CURSOR csr_line_util_seq IS
2211: SELECT ozf_claim_lines_util_all_s.NEXTVAL
2212: FROM DUAL;
2213:
2214: CURSOR csr_line_util_count(cv_line_util_id IN NUMBER) IS
2215: SELECT COUNT(claim_line_util_id)

Line 2498: INSERT INTO ozf_claim_lines_util_all (

2494: EXIT WHEN l_line_util_count = 0;
2495: END LOOP;
2496: END IF;
2497:
2498: INSERT INTO ozf_claim_lines_util_all (
2499: claim_line_util_id,
2500: object_version_number,
2501: last_update_date,
2502: last_updated_by,

Line 3066: UPDATE ozf_claim_lines_util_all SET

3062: IF OZF_DEBUG_HIGH_ON THEN
3063: OZF_Utility_PVT.debug_message(l_full_name ||': update lines utilized');
3064: END IF;
3065:
3066: UPDATE ozf_claim_lines_util_all SET
3067: object_version_number = l_line_util_rec.object_version_number,
3068: last_update_date = SYSDATE,
3069: last_updated_by = l_line_util_rec.last_updated_by,
3070: last_update_login = l_line_util_rec.last_update_login,

Line 3193: FROM ozf_claim_lines_util_all

3189: l_lu_currency_code VARCHAR2(15);
3190:
3191: CURSOR csr_util_obj_ver(cv_line_util_id IN NUMBER) IS
3192: SELECT object_version_number
3193: FROM ozf_claim_lines_util_all
3194: WHERE claim_line_util_id = cv_line_util_id;
3195:
3196: -- fix for bug 5042046
3197: CURSOR csr_function_currency IS

Line 3735: DELETE FROM ozf_claim_lines_util_all

3731: IF OZF_DEBUG_HIGH_ON THEN
3732: OZF_Utility_PVT.debug_message(l_full_name ||': delete');
3733: END IF;
3734:
3735: DELETE FROM ozf_claim_lines_util_all
3736: WHERE claim_line_util_id = p_line_util_id
3737: AND object_version_number = p_object_version;
3738:
3739: IF (SQL%NOTFOUND) THEN

Line 7953: DELETE FROM ozf_claim_lines_util_all

7949:
7950: END IF; -- p_line_util_rec.utilization_id > 0
7951:
7952: ------------------------ delete ------------------------
7953: DELETE FROM ozf_claim_lines_util_all
7954: WHERE claim_line_util_id = p_line_util_rec.claim_line_util_id;
7955:
7956: IF (SQL%NOTFOUND) THEN
7957: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN

Line 8659: DELETE FROM ozf_claim_lines_util_all

8655: */
8656: END IF;
8657:
8658: -- delete dummy utilizations
8659: DELETE FROM ozf_claim_lines_util_all
8660: WHERE claim_line_util_id = p_claim_line_util_id;
8661:
8662: ---------- Create Group Line Utils -------------------
8663: IF l_counter > 1 THEN

Line 8818: FROM ozf_claim_lines_util_all lu

8814: -- the coupon count(scan_unit) is independent of the offer and claim uom code
8815: CURSOR csr_line_utils(cv_claim_id IN NUMBER) IS
8816: SELECT SUM(lu.scan_unit * amp.quantity)
8817: ,lu.utilization_id
8818: FROM ozf_claim_lines_util_all lu
8819: ,ozf_claim_lines_all cln
8820: ,ams_act_products amp
8821: WHERE cln.claim_id = cv_claim_id
8822: AND lu.claim_line_id = cln.claim_line_id