APPS.QP_BLK_LOAD_UPG_PKG dependencies on QP_LIST_LINES

Line 52: --Variable for QP_LIST_LINES updation

48: l_rows_processed_hdr number;
49:
50:
51:
52: --Variable for QP_LIST_LINES updation
53: l_worker_id_line number;
54: l_product_line varchar2(30) := 'QP';
55: l_table_name_line varchar2(30) := 'QP_LIST_LINES';
56: -- l_update_name_line varchar2(30) := 'UPDATE LIST LINES';

Line 55: l_table_name_line varchar2(30) := 'QP_LIST_LINES';

51:
52: --Variable for QP_LIST_LINES updation
53: l_worker_id_line number;
54: l_product_line varchar2(30) := 'QP';
55: l_table_name_line varchar2(30) := 'QP_LIST_LINES';
56: -- l_update_name_line varchar2(30) := 'UPDATE LIST LINES';
57: l_update_name_line varchar2(30) := 'LINE::'||to_char(sysdate,'MM/DD/YYYY:HH:MI:SS'); -- modified by rassharm for unique name
58: l_status_line varchar2(30);
59: l_industry_line varchar2(30);

Line 211: update qp_list_lines l

207: TRUE);
208: --Update The Line
209: while (l_any_rows_to_process_line = TRUE)
210: loop
211: update qp_list_lines l
212: set l.orig_sys_line_ref=to_char(l.list_line_id),
213: l.orig_sys_header_ref=
214: (
215: select nvl(h.orig_system_header_ref,'INT'||to_char(h.list_header_id))

Line 266: from qp_list_lines l

262: ),
263: p.orig_sys_line_ref=
264: (
265: select nvl(l.orig_sys_line_ref,l.list_line_id)
266: from qp_list_lines l
267: where l.list_line_id = p.list_line_id
268: )
269: where p.ORIG_SYS_PRICING_ATTR_REF is null
270: and p.rowid between l_start_rowid_pa and l_end_rowid_pa;