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 255: update qp_pricing_attributes p

251: TRUE);
252: --Update The Pricing Attribute
253: while (l_any_rows_to_process_pa = TRUE)
254: loop
255: update qp_pricing_attributes p
256: set p.ORIG_SYS_PRICING_ATTR_REF=to_char(p.PRICING_ATTRIBUTE_ID),
257: p.orig_sys_header_ref=
258: (
259: select nvl(h.orig_system_header_ref,'INT'||to_char(h.list_header_id))