APPS.QPR_LOAD_MEAS_DATA dependencies on QPR_PN_INT_PR_ADJS

Line 6: type qpr_src_qtn_adj_type is table of qpr_pn_int_pr_adjs%rowtype;

2: /* $Header: QPRUFMDB.pls 120.25 2012/01/03 06:30:37 vinnaray ship $ */
3:
4: type char_type is table of varchar2(30) index by varchar2(30);
5: type qpr_src_qtn_line_type is table of QPR_PN_INT_LINES%rowtype;
6: type qpr_src_qtn_adj_type is table of qpr_pn_int_pr_adjs%rowtype;
7:
8: g_request_id number;
9: g_instance_id number;
10: g_meas_type varchar2(30);

Line 1702: delete qpr_pn_int_pr_adjs where source_ref_hdr_id = p_header_id

1698:
1699: if b_first then
1700: b_first := false;
1701:
1702: delete qpr_pn_int_pr_adjs where source_ref_hdr_id = p_header_id
1703: and source_id = g_source_id
1704: and erosion_type = t_adj_rec(1).EROSION_TYPE;
1705: end if;
1706:

Line 1723: insert into qpr_pn_int_pr_adjs(pn_int_pr_adj_id,

1719:
1720:
1721: forall i in t_pr_adj_val.src_ref_line_id.first..
1722: t_pr_adj_val.src_ref_line_id.last
1723: insert into qpr_pn_int_pr_adjs(pn_int_pr_adj_id,
1724: source_ref_hdr_id,
1725: source_ref_line_id,
1726: source_id,
1727: erosion_type,

Line 1740: values(qpr_pn_int_pr_adjs_s.nextval,

1736: last_update_login,
1737: program_application_id,
1738: program_id,
1739: request_id)
1740: values(qpr_pn_int_pr_adjs_s.nextval,
1741: t_pr_adj_val.SRC_REF_HDR_ID(i),
1742: t_pr_adj_val.src_ref_line_id(i),
1743: t_pr_adj_val.source_id(i),
1744: t_pr_adj_val.erosion_type(i),