APPS.OZF_CLAIM_PVT dependencies on OZF_CLAIM_LINES

Line 4355: -- view_name/table_name ozf_claim_lines_b jtf_tasks_v

4351: -- any API to delete these two objects. Checks on these will have to be added later.
4352: -- So here I'm only add line and task information in the dependent objects table.
4353:
4354: --TYPE dependent_objects_rec_type IS RECORD
4355: -- view_name/table_name ozf_claim_lines_b jtf_tasks_v
4356: -- name VARCHAR2(240) line_number Task_number
4357: --type VARCHAR2(30) LINE TASK
4358: --status VARCHAR2(30) NEW Task_status
4359: --owner VARCHAR2(240) ozf_claims_v.owner_id owner

Line 4399: FROM ozf_claim_lines

4395: l_owner_name varchar2(2000);
4396:
4397: CURSOR lines_info_csr(p_id in number)IS
4398: SELECT line_number
4399: FROM ozf_claim_lines
4400: WHERE claim_id = p_id;
4401:
4402: CURSOR line_count_csr(p_id in number)IS
4403: select count(*)

Line 4404: from ozf_claim_lines

4400: WHERE claim_id = p_id;
4401:
4402: CURSOR line_count_csr(p_id in number)IS
4403: select count(*)
4404: from ozf_claim_lines
4405: where claim_id = p_id;
4406: l_line_count number :=0;
4407:
4408: TYPE lines_info_tbl_type is table of lines_info_csr%rowType INDEX BY BINARY_INTEGER;

Line 4643: from ozf_claim_lines_all

4639: l_claim_line_tbl OZF_Claim_Line_PVT.claim_line_tbl_type;
4640:
4641: CURSOR claim_line_id_csr(p_id in number)is
4642: select claim_line_id, object_version_number
4643: from ozf_claim_lines_all
4644: where claim_id = p_id;
4645:
4646: l_claim_line_id number;
4647: l_line_object_version_number number;

Line 4664: from OZF_CLAIM_LINES_HIST_ALL

4660: where claim_id = p_id;
4661:
4662: CURSOR claim_line_his_id_csr(p_id in number) is
4663: select claim_line_history_id, object_version_number
4664: from OZF_CLAIM_LINES_HIST_ALL
4665: where claim_id = p_id;
4666:
4667: TYPE tasks_id_tbl_type is table of tasks_id_csr%rowType index by binary_integer;
4668: l_tasks_id_tbl tasks_id_tbl_type;

Line 5218: from ozf_claim_lines_all

5214: l_open_status_id number;
5215:
5216: CURSOR claim_currency_amount_sum_csr(p_id in NUMBER) IS
5217: select NVL(sum(claim_currency_amount), 0)
5218: from ozf_claim_lines_all
5219: where claim_id = p_id;
5220:
5221: CURSOR object_version_number_csr (p_id in number) is
5222: select object_version_number

Line 5282: FROM ozf_claim_lines_all

5278: l_old_write_off_flag varchar2(1);
5279:
5280: CURSOR claim_lines_csr(p_id in number)IS
5281: SELECT *
5282: FROM ozf_claim_lines_all
5283: WHERE claim_id = p_id;
5284:
5285: TYPE Claim_Lines_Type IS TABLE OF claim_lines_csr%rowtype
5286: INDEX BY BINARY_INTEGER;