APPS.QPR_LOAD_MEAS_DATA dependencies on QPR_PN_INT_LINES

Line 5: type qpr_src_qtn_line_type is table of QPR_PN_INT_LINES%rowtype;

1: PACKAGE BODY QPR_LOAD_MEAS_DATA AS
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;

Line 43: DEAL_LINE_TBL CONSTANT varchar2(30) := 'QPR_PN_INT_LINES';

39: MEAS_TYPE_OFFADJ CONSTANT varchar2(30) := 'OFFADJDATA';
40: OM_MEAS_TYPE_DEALINT CONSTANT varchar2(30) := 'OM_DEALINT';
41: ASO_MEAS_TYPE_DEALINT CONSTANT varchar2(30) := 'ASO_DEALINT';
42: DEAL_HEADER_TBL CONSTANT varchar2(30) := 'QPR_PN_INT_HEADERS';
43: DEAL_LINE_TBL CONSTANT varchar2(30) := 'QPR_PN_INT_LINES';
44: SEEDED_INSTANCE_ID CONSTANT number := 1;
45:
46: NO_TBL_DEF exception;
47:

Line 1365: insert into qpr_pn_int_lines(PN_INT_LINE_ID,

1361: begin
1362: log_debug('Inserting deal interface lines ....');
1363: forall i in g_r_ins_deal.SOURCE_REF_HDR_ID.first..
1364: g_r_ins_deal.SOURCE_REF_HDR_ID.last
1365: insert into qpr_pn_int_lines(PN_INT_LINE_ID,
1366: -- PN_INT_HEADER_ID,
1367: SOURCE_REF_HDR_ID,
1368: SOURCE_REF_LINE_ID,
1369: SOURCE_REQUEST_LINE_NUMBER,

Line 1430: values(qpr_pn_int_lines_s.nextval,

1426: LAST_UPDATE_LOGIN,
1427: PROGRAM_APPLICATION_ID,
1428: PROGRAM_ID ,
1429: REQUEST_ID)
1430: values(qpr_pn_int_lines_s.nextval,
1431: -- p_int_hdr_id,
1432: g_r_ins_deal.SOURCE_REF_HDR_ID(i) ,
1433: g_r_ins_deal.SOURCE_REF_LINE_ID(i) ,
1434: g_r_ins_deal.SOURCE_REQ_LINE_NO(i),

Line 1504: update qpr_pn_int_lines set

1500: begin
1501: log_debug('Updating deal interface lines ....');
1502: forall i in g_r_upd_deal.SOURCE_REF_HDR_ID.first..
1503: g_r_upd_deal.SOURCE_REF_HDR_ID.last
1504: update qpr_pn_int_lines set
1505: SOURCE_REQUEST_LINE_NUMBER = g_r_upd_deal.SOURCE_REQ_LINE_NO(i),
1506: SOURCE_ID = g_r_upd_deal.SOURCE_ID(i),
1507: ORG_ID = g_r_upd_deal.ORG_ID(i),
1508: ORG_SHORT_DESC = g_r_upd_deal.ORG_SHORT_DESC(i) ,

Line 1594: from qpr_pn_int_lines l, qpr_pn_int_headers h

1590: log_debug('In Deal Line method..');
1591:
1592: select l.SOURCE_REF_LINE_ID, l.PN_INT_LINE_ID, l.PN_REQ_LINE_STATUS_FLAG
1593: bulk collect into t_src_line_id, t_int_line_id, t_status
1594: from qpr_pn_int_lines l, qpr_pn_int_headers h
1595: where h.source_ref_header_id = p_header_id
1596: and h.instance_id = g_instance_id
1597: and h.source_id = g_source_id
1598: and h.source_ref_header_short_desc = g_quote_hdr_sd

Line 2014: r_lines qpr_pn_int_lines%rowtype;

2010: l_resp_sales_rep qpr_pn_request_hdrs_b.sales_rep_id%type;
2011: l_resp_sc qpr_pn_request_hdrs_b.sales_channel_code%type;
2012: l_request_hdr_id qpr_pn_request_hdrs_b.request_header_id%type;
2013: r_hdr qpr_pn_int_headers%rowtype;
2014: r_lines qpr_pn_int_lines%rowtype;
2015: l_hdr_matching boolean := false;
2016: l_line_matching boolean := false;
2017: l_org_id qpr_pn_lines.ORG_ID%type;
2018: l_item_id qpr_pn_lines.inventory_item_id%type;