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 260: from qp_list_headers_b h

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))
260: from qp_list_headers_b h
261: where h.list_header_id = p.list_header_id
262: ),
263: p.orig_sys_line_ref=
264: (

Line 310: from qp_list_headers_b h

306: set q.orig_sys_qualifier_ref=to_char(q.qualifier_id),
307: q.orig_sys_header_ref=
308: (
309: select nvl(h.orig_system_header_ref,'INT'||to_char(h.list_header_id))
310: from qp_list_headers_b h
311: where h.list_header_id = q.list_header_id
312: )
313: where q.orig_sys_qualifier_ref is null
314: and q.list_header_id is not null