APPS.QP_BLK_LOAD_UPG_PKG dependencies on QP_QUALIFIERS

Line 86: --Variable for QP_QUALIFIERS updation

82: l_rows_processed_pa number;
83:
84:
85:
86: --Variable for QP_QUALIFIERS updation
87: l_worker_id_qual number;
88: l_product_qual varchar2(30) := 'QP';
89: l_table_name_qual varchar2(30) := 'QP_QUALIFIERS';
90: l_update_name_qual varchar2(30) := 'QUAL::'||to_char(sysdate,'MM/DD/YYYY:HH:MI:SS'); -- modified by rassharm for unique name

Line 89: l_table_name_qual varchar2(30) := 'QP_QUALIFIERS';

85:
86: --Variable for QP_QUALIFIERS updation
87: l_worker_id_qual number;
88: l_product_qual varchar2(30) := 'QP';
89: l_table_name_qual varchar2(30) := 'QP_QUALIFIERS';
90: l_update_name_qual varchar2(30) := 'QUAL::'||to_char(sysdate,'MM/DD/YYYY:HH:MI:SS'); -- modified by rassharm for unique name
91: l_status_qual varchar2(30);
92: l_industry_qual varchar2(30);
93: l_retstatus_qual boolean;

Line 354: update qp_qualifiers q

350: TRUE);
351: --Update The Qualifier
352: while (l_any_rows_to_process_qual = TRUE)
353: loop
354: update qp_qualifiers q
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))

Line 373: update qp_qualifiers q

369: -- orig_sys_header_ref could still be null for those qualifier rows which were created post R12
370: -- and before running this program since orig_sys_qualifier_ref will not be null for those lines and
371: -- orig_sys_header_ref was null for corresponding headers.
372:
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