APPS.IGF_AW_COA_ITM_TERMS_PKG dependencies on IGF_AW_COA_HIST

Line 328: l_coah_id igf_aw_coa_hist.coah_id%TYPE;

324: || Who When What
325: || (reverse chronological order - newest change first)
326: --------------------------------------------------------------------*/
327: lv_rowid ROWID;
328: l_coah_id igf_aw_coa_hist.coah_id%TYPE;
329: l_operation_txt igf_aw_coa_hist.operation_txt%TYPE;
330: l_base_id igf_ap_fa_base_rec_all.base_id%TYPE;
331: l_ld_cal_type igs_ca_inst.cal_type%TYPE;
332: l_ld_seq_num igs_ca_inst.sequence_number%TYPE;

Line 329: l_operation_txt igf_aw_coa_hist.operation_txt%TYPE;

325: || (reverse chronological order - newest change first)
326: --------------------------------------------------------------------*/
327: lv_rowid ROWID;
328: l_coah_id igf_aw_coa_hist.coah_id%TYPE;
329: l_operation_txt igf_aw_coa_hist.operation_txt%TYPE;
330: l_base_id igf_ap_fa_base_rec_all.base_id%TYPE;
331: l_ld_cal_type igs_ca_inst.cal_type%TYPE;
332: l_ld_seq_num igs_ca_inst.sequence_number%TYPE;
333: l_item_code igf_aw_item.item_code%TYPE;

Line 358: igf_aw_coa_hist_pkg.insert_row(

354: END IF;
355: lv_rowid := NULL;
356: l_coah_id := NULL;
357: IF NVL(old_references.amount,-1) <> NVL(new_references.amount,-1) THEN
358: igf_aw_coa_hist_pkg.insert_row(
359: x_rowid => lv_rowid,
360: x_coah_id => l_coah_id,
361: x_base_id => l_base_id,
362: x_tran_date => SYSDATE,

Line 389: l_coah_id igf_aw_coa_hist.coah_id%TYPE;

385: || Who When What
386: || (reverse chronological order - newest change first)
387: --------------------------------------------------------------------*/
388: lv_rowid ROWID;
389: l_coah_id igf_aw_coa_hist.coah_id%TYPE;
390: l_operation_txt igf_aw_coa_hist.operation_txt%TYPE;
391:
392: BEGIN
393: IF NVL(old_references.lock_flag,'N') <> NVL(new_references.lock_flag,'N') AND NVL(old_references.lock_flag,'N') = 'Y' THEN

Line 390: l_operation_txt igf_aw_coa_hist.operation_txt%TYPE;

386: || (reverse chronological order - newest change first)
387: --------------------------------------------------------------------*/
388: lv_rowid ROWID;
389: l_coah_id igf_aw_coa_hist.coah_id%TYPE;
390: l_operation_txt igf_aw_coa_hist.operation_txt%TYPE;
391:
392: BEGIN
393: IF NVL(old_references.lock_flag,'N') <> NVL(new_references.lock_flag,'N') AND NVL(old_references.lock_flag,'N') = 'Y' THEN
394: l_operation_txt := 'UNLOCK';

Line 402: igf_aw_coa_hist_pkg.insert_row(

398: RETURN;
399: END IF;
400: lv_rowid := NULL;
401: l_coah_id := NULL;
402: igf_aw_coa_hist_pkg.insert_row(
403: x_rowid => lv_rowid,
404: x_coah_id => l_coah_id,
405: x_base_id => NVL(old_references.base_id,new_references.base_id),
406: x_tran_date => SYSDATE,