DBA Data[Home] [Help]

APPS.HZ_IMP_LOAD_FINNUMBERS_PKG dependencies on HZ_FINANCIAL_NUMBERS

Line 225: into hz_financial_numbers (

221: and fin_num_name_err is not null
222: and action_mismatch_error is not null
223: and createdby_error is not null
224: and tca_fr_id is not null) then
225: into hz_financial_numbers (
226: created_by,
227: creation_date,
228: last_updated_by,
229: last_update_date,

Line 569: update hz_financial_numbers set

565: close c_update_cursor;
566:
567: --begin
568: forall j in 1..l_fn_id.count
569: update hz_financial_numbers set
570: PROGRAM_APPLICATION_ID = PROGRAM_APPLICATION_ID ,
571: PROGRAM_ID = PROGRAM_ID ,
572: PROGRAM_UPDATE_DATE = P_DML_RECORD.SYSDATE,
573: FINANCIAL_NUMBER = decode(l_fin_num(j), P_DML_RECORD.GMISS_CHAR, null, l_fin_num(j)),