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 1290: SELECT ozf_claim_lines_all_s.NEXTVAL

1286: )
1287: IS
1288: -- Cursor to get the sequence for claim_line_id
1289: CURSOR c_claim_line_seq IS
1290: SELECT ozf_claim_lines_all_s.NEXTVAL
1291: FROM DUAL;
1292:
1293: -- Cursor to validate the uniqueness of the claim_line_id
1294: CURSOR c_claim_line_count(cv_claim_line_id IN NUMBER) IS

Line 1718: INSERT INTO ozf_claim_lines_all (

1714: OZF_Utility_PVT.debug_message(l_full_name ||': insert');
1715: END IF;
1716:
1717:
1718: INSERT INTO ozf_claim_lines_all (
1719: claim_line_id,
1720: object_version_number,
1721: last_update_date,
1722: last_updated_by,

Line 2376: DELETE FROM ozf_claim_lines_all

2372: IF OZF_DEBUG_HIGH_ON THEN
2373: OZF_Utility_PVT.debug_message(l_full_name ||': delete');
2374: END IF;
2375:
2376: DELETE FROM ozf_claim_lines_all
2377: WHERE claim_line_id = p_claim_line_id
2378: AND object_version_number = p_object_version;
2379:
2380: IF (SQL%NOTFOUND) THEN

Line 2464: FROM ozf_claim_lines_all

2460: l_claim_line_id NUMBER;
2461:
2462: CURSOR c_claim_line IS
2463: SELECT claim_line_id
2464: FROM ozf_claim_lines_all
2465: WHERE claim_line_id = p_claim_line_id
2466: AND object_version_number = p_object_version
2467: FOR UPDATE OF claim_line_id NOWAIT;
2468:

Line 3583: UPDATE ozf_claim_lines_all SET

3579: IF OZF_DEBUG_HIGH_ON THEN
3580: OZF_Utility_PVT.debug_message(l_full_name ||': update');
3581: END IF;
3582:
3583: UPDATE ozf_claim_lines_all SET
3584: object_version_number = l_object_version_number,
3585: last_update_date = SYSDATE,
3586: last_updated_by = l_last_updated_by,
3587: last_update_login = l_last_update_login,

Line 5105: FROM ozf_claim_lines_all

5101: WHERE claim_line_id = cv_claim_line_id;
5102:
5103: CURSOR csr_claim_line_sum(cv_claim_line_id IN NUMBER) IS
5104: SELECT nvl(amount,0), nvl(acctd_amount,0)
5105: FROM ozf_claim_lines_all
5106: WHERE claim_line_id = cv_claim_line_id;
5107:
5108: l_sum_util_amount NUMBER :=0;
5109: l_sum_util_acctd_amount NUMBER :=0;

Line 5375: update ozf_claim_lines_all

5371: OZF_Utility_PVT.debug_message('l_sum_util_amount'||l_sum_util_amount);
5372: END IF;
5373:
5374: IF (l_line_amount = l_sum_util_amount) THEN
5375: update ozf_claim_lines_all
5376: set acctd_amount = l_sum_util_acctd_amount
5377: where claim_line_id = l_claim_line_id;
5378: END IF;
5379: END IF; -- update/create claim line