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.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;

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 1369: insert into qpr_pn_int_lines(PN_INT_LINE_ID,

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

Line 1434: values(qpr_pn_int_lines_s.nextval,

1430: LAST_UPDATE_LOGIN,
1431: PROGRAM_APPLICATION_ID,
1432: PROGRAM_ID ,
1433: REQUEST_ID)
1434: values(qpr_pn_int_lines_s.nextval,
1435: -- p_int_hdr_id,
1436: g_r_ins_deal.SOURCE_REF_HDR_ID(i) ,
1437: g_r_ins_deal.SOURCE_REF_LINE_ID(i) ,
1438: g_r_ins_deal.SOURCE_REQ_LINE_NO(i),

Line 1508: update qpr_pn_int_lines set

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

Line 1598: from qpr_pn_int_lines l, qpr_pn_int_headers h

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

Line 2027: r_lines qpr_pn_int_lines%rowtype;

2023: l_resp_sales_rep qpr_pn_request_hdrs_b.sales_rep_id%type;
2024: l_resp_sc qpr_pn_request_hdrs_b.sales_channel_code%type;
2025: l_request_hdr_id qpr_pn_request_hdrs_b.request_header_id%type;
2026: r_hdr qpr_pn_int_headers%rowtype;
2027: r_lines qpr_pn_int_lines%rowtype;
2028: l_hdr_matching boolean := false;
2029: l_line_matching boolean := false;
2030: l_org_id qpr_pn_lines.ORG_ID%type;
2031: l_item_id qpr_pn_lines.inventory_item_id%type;