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.17 2008/05/29 06:01:26 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 1689: delete qpr_pn_int_pr_adjs where source_ref_hdr_id = p_header_id

1685:
1686: if b_first then
1687: b_first := false;
1688:
1689: delete qpr_pn_int_pr_adjs where source_ref_hdr_id = p_header_id
1690: and source_id = g_source_id
1691: and erosion_type = t_adj_rec(1).EROSION_TYPE;
1692: end if;
1693:

Line 1710: insert into qpr_pn_int_pr_adjs(pn_int_pr_adj_id,

1706:
1707:
1708: forall i in t_pr_adj_val.src_ref_line_id.first..
1709: t_pr_adj_val.src_ref_line_id.last
1710: insert into qpr_pn_int_pr_adjs(pn_int_pr_adj_id,
1711: source_ref_hdr_id,
1712: source_ref_line_id,
1713: source_id,
1714: erosion_type,

Line 1727: values(qpr_pn_int_pr_adjs_s.nextval,

1723: last_update_login,
1724: program_application_id,
1725: program_id,
1726: request_id)
1727: values(qpr_pn_int_pr_adjs_s.nextval,
1728: t_pr_adj_val.SRC_REF_HDR_ID(i),
1729: t_pr_adj_val.src_ref_line_id(i),
1730: t_pr_adj_val.source_id(i),
1731: t_pr_adj_val.erosion_type(i),