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 305: update qp_qualifiers q

301: TRUE);
302: --Update The Qualifier
303: while (l_any_rows_to_process_qual = TRUE)
304: loop
305: update qp_qualifiers q
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))