APPS.IGF_AW_COA_ITM_TERMS_PKG dependencies on IGS_CA_INST

Line 109: ELSIF NOT igs_ca_inst_pkg.get_pk_for_validation (

105: (old_references.ld_sequence_number = new_references.ld_sequence_number)) OR
106: ((new_references.ld_cal_type IS NULL) OR
107: (new_references.ld_sequence_number IS NULL))) THEN
108: NULL;
109: ELSIF NOT igs_ca_inst_pkg.get_pk_for_validation (
110: new_references.ld_cal_type,
111: new_references.ld_sequence_number
112: ) THEN
113: fnd_message.set_name ('FND', 'FORM_RECORD_DELETED');

Line 199: PROCEDURE get_fk_igs_ca_inst (

195:
196: END get_fk_igf_aw_coa_items;
197:
198:
199: PROCEDURE get_fk_igs_ca_inst (
200: x_cal_type IN VARCHAR2,
201: x_sequence_number IN NUMBER
202: ) AS
203: /*

Line 233: END get_fk_igs_ca_inst;

229: RETURN;
230: END IF;
231: CLOSE cur_rowid;
232:
233: END get_fk_igs_ca_inst;
234:
235:
236: PROCEDURE before_dml (
237: p_action IN VARCHAR2,

Line 331: l_ld_cal_type igs_ca_inst.cal_type%TYPE;

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;
334:
335: BEGIN

Line 332: l_ld_seq_num igs_ca_inst.sequence_number%TYPE;

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;
334:
335: BEGIN
336: IF p_updating THEN