APPS.OZF_CLAIM_LINE_PVT dependencies on OZF_CLAIM_LINES_ALL

Line 50: WHERE db_table_name = 'OZF_CLAIM_LINES_ALL'

46: CURSOR csr_user_hist_cols(cv_object_attribute IN VARCHAR2) IS
47: SELECT db_column_name
48: --, ak_attribute_code
49: FROM ams_column_rules
50: WHERE db_table_name = 'OZF_CLAIM_LINES_ALL'
51: AND rule_type = 'HISTORY'
52: AND object_type = 'CLAM'
53: AND object_attribute = cv_object_attribute;
54:

Line 1013: FROM ozf_claim_lines_all

1009: , object_version_number
1010: , claim_currency_amount
1011: , tax_code
1012: , earnings_associated_flag
1013: FROM ozf_claim_lines_all
1014: WHERE claim_id = p_claim_id;
1015:
1016: BEGIN
1017: --------------------- initialize -----------------------

Line 1265: select NVL(sum(quantity),0) from ozf_claim_lines_all

1261: FROM ra_customer_trx_lines_all
1262: WHERE customer_trx_line_id = cv_src_obj_line_id;
1263:
1264: CURSOR c_tot_qty(cv_claim_id IN NUMBER, cv_source_object_line_id IN NUMBER) IS
1265: select NVL(sum(quantity),0) from ozf_claim_lines_all
1266: WHERE claim_id = cv_claim_id
1267: and source_object_line_id = cv_source_object_line_id;
1268:
1269: -- Bug#9957893 (-)

Line 1592: SELECT ozf_claim_lines_all_s.NEXTVAL

1588: )
1589: IS
1590: -- Cursor to get the sequence for claim_line_id
1591: CURSOR c_claim_line_seq IS
1592: SELECT ozf_claim_lines_all_s.NEXTVAL
1593: FROM DUAL;
1594:
1595: -- Cursor to validate the uniqueness of the claim_line_id
1596: CURSOR c_claim_line_count(cv_claim_line_id IN NUMBER) IS

Line 2055: INSERT INTO ozf_claim_lines_all (

2051: OZF_Utility_PVT.debug_message('l_claim_line_rec.claim_line_id before insert :' || l_claim_line_rec.claim_line_id);
2052: END IF;
2053:
2054:
2055: INSERT INTO ozf_claim_lines_all (
2056: claim_line_id,
2057: object_version_number,
2058: last_update_date,
2059: last_updated_by,

Line 2728: DELETE FROM ozf_claim_lines_all

2724: OZF_Utility_PVT.debug_message(p_claim_line_id ||': delete : p_claim_line_id');
2725: OZF_Utility_PVT.debug_message(p_object_version ||': delete : p_object_version');
2726: END IF;
2727:
2728: DELETE FROM ozf_claim_lines_all
2729: WHERE claim_line_id = p_claim_line_id
2730: AND object_version_number = p_object_version;
2731:
2732: IF (SQL%NOTFOUND) THEN

Line 2816: FROM ozf_claim_lines_all

2812: l_claim_line_id NUMBER;
2813:
2814: CURSOR c_claim_line IS
2815: SELECT claim_line_id
2816: FROM ozf_claim_lines_all
2817: WHERE claim_line_id = p_claim_line_id
2818: AND object_version_number = p_object_version
2819: FOR UPDATE OF claim_line_id NOWAIT;
2820:

Line 4015: UPDATE ozf_claim_lines_all SET

4011: IF OZF_DEBUG_HIGH_ON THEN
4012: OZF_Utility_PVT.debug_message(l_full_name ||': update');
4013: END IF;
4014:
4015: UPDATE ozf_claim_lines_all SET
4016: object_version_number = l_object_version_number,
4017: last_update_date = SYSDATE,
4018: last_updated_by = l_last_updated_by,
4019: last_update_login = l_last_update_login,

Line 5538: FROM ozf_claim_lines_all

5534: WHERE claim_line_id = cv_claim_line_id;
5535:
5536: CURSOR csr_claim_line_sum(cv_claim_line_id IN NUMBER) IS
5537: SELECT nvl(amount,0), nvl(acctd_amount,0)
5538: FROM ozf_claim_lines_all
5539: WHERE claim_line_id = cv_claim_line_id;
5540:
5541: l_sum_util_amount NUMBER :=0;
5542: l_sum_util_acctd_amount NUMBER :=0;

Line 5808: update ozf_claim_lines_all

5804: OZF_Utility_PVT.debug_message('l_sum_util_amount'||l_sum_util_amount);
5805: END IF;
5806:
5807: IF (l_line_amount = l_sum_util_amount) THEN
5808: update ozf_claim_lines_all
5809: set acctd_amount = l_sum_util_acctd_amount
5810: where claim_line_id = l_claim_line_id;
5811: END IF;
5812: END IF; -- update/create claim line

Line 5909: FROM ozf_claim_lines_all cln, ozf_claim_lines_util_all clu

5905:
5906: --Cursor to fetch the claim line detail
5907: CURSOR claim_line_id_csr(p_id in number) IS
5908: SELECT distinct cln.claim_line_id, cln.object_version_number
5909: FROM ozf_claim_lines_all cln, ozf_claim_lines_util_all clu
5910: WHERE clu.claim_line_id = cln.claim_line_id
5911: AND claim_id = p_id;
5912:
5913: