APPS.QP_BLK_LOAD_UPG_PKG dependencies on QP_PRICING_ATTRIBUTES

Line 69: --Variable for QP_PRICING_ATTRIBUTES updation

65: l_rows_processed_line number;
66:
67:
68:
69: --Variable for QP_PRICING_ATTRIBUTES updation
70: l_worker_id_pa number;
71: l_product_pa varchar2(30) := 'QP';
72: l_table_name_pa varchar2(30) := 'QP_PRICING_ATTRIBUTES';
73: --l_update_name_pa varchar2(30) := 'UPDATE PRICING ATTRIBUTES';

Line 72: l_table_name_pa varchar2(30) := 'QP_PRICING_ATTRIBUTES';

68:
69: --Variable for QP_PRICING_ATTRIBUTES updation
70: l_worker_id_pa number;
71: l_product_pa varchar2(30) := 'QP';
72: l_table_name_pa varchar2(30) := 'QP_PRICING_ATTRIBUTES';
73: --l_update_name_pa varchar2(30) := 'UPDATE PRICING ATTRIBUTES';
74: l_update_name_pa varchar2(30) := 'ATTR::'||to_char(sysdate,'MM/DD/YYYY:HH:MI:SS'); -- modified by rassharm for unique name
75: l_status_pa varchar2(30);
76: l_industry_pa varchar2(30);

Line 274: update qp_pricing_attributes p

270: TRUE);
271: --Update The Pricing Attribute
272: while (l_any_rows_to_process_pa = TRUE)
273: loop
274: update qp_pricing_attributes p
275: set p.ORIG_SYS_PRICING_ATTR_REF=to_char(p.PRICING_ATTRIBUTE_ID),
276: p.orig_sys_header_ref=
277: (
278: select nvl(h.orig_system_header_ref,'INT'||to_char(h.list_header_id))

Line 299: update qp_pricing_attributes p

295: -- list lines which were created post R12 and before running this program since
296: -- ORIG_SYS_PRICING_ATTR_REF will not be null for those lines and orig_sys_header_ref was
297: -- null for corresponding headers.
298:
299: update qp_pricing_attributes p
300: set p.orig_sys_header_ref=
301: (
302: select nvl(h.orig_system_header_ref,'INT'||to_char(h.list_header_id))
303: from qp_list_headers_b h

Line 309: update qp_pricing_attributes p

305: )
306: where p.orig_sys_header_ref is null
307: and p.rowid between l_start_rowid_pa and l_end_rowid_pa;
308:
309: update qp_pricing_attributes p
310: set p.orig_sys_line_ref=
311: (
312: select nvl(l.orig_sys_line_ref,l.list_line_id)
313: from qp_list_lines l