APPS.QP_BLK_LOAD_UPG_PKG dependencies on QP_LIST_HEADERS_B

Line 35: --Variable for QP_LIST_HEADERS_B updation

31: X_Worker_Id in number,
32: X_Num_Workers in number
33: )
34: IS
35: --Variable for QP_LIST_HEADERS_B updation
36: l_worker_id_hdr number;
37: l_product_hdr varchar2(30) := 'QP';
38: l_table_name_hdr varchar2(30) := 'QP_LIST_HEADERS_B';
39: -- l_update_name_hdr varchar2(30) := 'UPDATE LIST HEADERS';

Line 38: l_table_name_hdr varchar2(30) := 'QP_LIST_HEADERS_B';

34: IS
35: --Variable for QP_LIST_HEADERS_B updation
36: l_worker_id_hdr number;
37: l_product_hdr varchar2(30) := 'QP';
38: l_table_name_hdr varchar2(30) := 'QP_LIST_HEADERS_B';
39: -- l_update_name_hdr varchar2(30) := 'UPDATE LIST HEADERS';
40: l_update_name_hdr varchar2(30) := 'HDR::'||to_char(sysdate,'MM/DD/YYYY:HH:MI:SS'); -- modified by rassharm for unique name
41: l_status_hdr varchar2(30);
42: l_industry_hdr varchar2(30);

Line 173: Update qp_list_headers_b qplh1

169: TRUE);
170: --Update The Header
171: while (l_any_rows_to_process_hdr = TRUE)
172: loop
173: Update qp_list_headers_b qplh1
174: Set qplh1.orig_system_header_ref = 'INT'||to_char(qplh1.list_header_id)
175: where qplh1.orig_system_header_ref is null
176: and qplh1.rowid between l_start_rowid_hdr and l_end_rowid_hdr;
177: l_rows_processed_hdr := SQL%ROWCOUNT;

Line 216: from qp_list_headers_b h

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))
216: from qp_list_headers_b h
217: where h.list_header_id = l.list_header_id
218: )
219: where l.orig_sys_line_ref is null
220: and l.rowid between l_start_rowid_line and l_end_rowid_line;

Line 233: from qp_list_headers_b h

229: UPDATE qp_list_lines l
230: SET l.orig_sys_header_ref=
231: (
232: select nvl(h.orig_system_header_ref,'INT'||to_char(h.list_header_id))
233: from qp_list_headers_b h
234: where h.list_header_id = l.list_header_id
235: )
236: where l.orig_sys_header_ref is null
237: and l.rowid between l_start_rowid_line and l_end_rowid_line;

Line 279: from qp_list_headers_b h

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))
279: from qp_list_headers_b h
280: where h.list_header_id = p.list_header_id
281: ),
282: p.orig_sys_line_ref=
283: (

Line 303: from qp_list_headers_b h

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
304: where h.list_header_id = p.list_header_id
305: )
306: where p.orig_sys_header_ref is null
307: and p.rowid between l_start_rowid_pa and l_end_rowid_pa;

Line 359: from qp_list_headers_b h

355: set q.orig_sys_qualifier_ref=to_char(q.qualifier_id),
356: q.orig_sys_header_ref=
357: (
358: select nvl(h.orig_system_header_ref,'INT'||to_char(h.list_header_id))
359: from qp_list_headers_b h
360: where h.list_header_id = q.list_header_id
361: )
362: where q.orig_sys_qualifier_ref is null
363: and q.list_header_id is not null

Line 377: from qp_list_headers_b h

373: update qp_qualifiers q
374: set q.orig_sys_header_ref=
375: (
376: select nvl(h.orig_system_header_ref,'INT'||to_char(h.list_header_id))
377: from qp_list_headers_b h
378: where h.list_header_id = q.list_header_id
379: )
380: where q.orig_sys_header_ref is null
381: and q.list_header_id is not null