eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.IGS_FI_GEN_004 dependencies on IGS_CA_INST_ALL

Line 459: l_v_load_cal_type igs_ca_inst_all.cal_type%TYPE;

455: l_v_msg_data VARCHAR2(1000);
456:
457: l_v_include_audit VARCHAR2(1);
458: l_v_message fnd_new_messages.message_name%TYPE;
459: l_v_load_cal_type igs_ca_inst_all.cal_type%TYPE;
460: l_n_load_ci_seq_num igs_ca_inst_all.sequence_number%TYPE;
461:
462: CURSOR c_fee_cal_instance (
463: cp_fee_cal_type IGS_FI_F_TYP_CA_INST.fee_cal_type%TYPE,

Line 460: l_n_load_ci_seq_num igs_ca_inst_all.sequence_number%TYPE;

456:
457: l_v_include_audit VARCHAR2(1);
458: l_v_message fnd_new_messages.message_name%TYPE;
459: l_v_load_cal_type igs_ca_inst_all.cal_type%TYPE;
460: l_n_load_ci_seq_num igs_ca_inst_all.sequence_number%TYPE;
461:
462: CURSOR c_fee_cal_instance (
463: cp_fee_cal_type IGS_FI_F_TYP_CA_INST.fee_cal_type%TYPE,
464: cp_fee_ci_sequence_number IGS_FI_F_TYP_CA_INST.fee_ci_sequence_number%TYPE)

Line 504: p_v_load_cal_type IN igs_ca_inst_all.cal_type%TYPE,

500: p_fee_cal_type IN igs_pe_std_todo_ref.cal_type%TYPE,
501: p_fee_ci_sequence_number IN igs_pe_std_todo_ref.ci_sequence_number%TYPE,
502: x_return_status OUT NOCOPY VARCHAR2,
503: x_msg_data OUT NOCOPY VARCHAR2,
504: p_v_load_cal_type IN igs_ca_inst_all.cal_type%TYPE,
505: p_n_load_ci_seq_num IN igs_ca_inst_all.sequence_number%TYPE
506: ) AS
507: /*************************************************************
508: Who When What

Line 505: p_n_load_ci_seq_num IN igs_ca_inst_all.sequence_number%TYPE

501: p_fee_ci_sequence_number IN igs_pe_std_todo_ref.ci_sequence_number%TYPE,
502: x_return_status OUT NOCOPY VARCHAR2,
503: x_msg_data OUT NOCOPY VARCHAR2,
504: p_v_load_cal_type IN igs_ca_inst_all.cal_type%TYPE,
505: p_n_load_ci_seq_num IN igs_ca_inst_all.sequence_number%TYPE
506: ) AS
507: /*************************************************************
508: Who When What
509:

Line 525: cp_v_load_cal_type igs_ca_inst_all.cal_type%TYPE,

521: l_v_person_number hz_parties.party_number%TYPE;
522:
523: CURSOR c_get_todo_ref_csr(cp_person_id igs_pe_std_todo_ref.person_id%TYPE,
524: cp_sequence_number igs_pe_std_todo_ref.sequence_number%TYPE,
525: cp_v_load_cal_type igs_ca_inst_all.cal_type%TYPE,
526: cp_n_load_ci_seq_num igs_ca_inst_all.sequence_number%TYPE ) IS
527: SELECT rowid,
528: person_id,
529: s_student_todo_type,

Line 526: cp_n_load_ci_seq_num igs_ca_inst_all.sequence_number%TYPE ) IS

522:
523: CURSOR c_get_todo_ref_csr(cp_person_id igs_pe_std_todo_ref.person_id%TYPE,
524: cp_sequence_number igs_pe_std_todo_ref.sequence_number%TYPE,
525: cp_v_load_cal_type igs_ca_inst_all.cal_type%TYPE,
526: cp_n_load_ci_seq_num igs_ca_inst_all.sequence_number%TYPE ) IS
527: SELECT rowid,
528: person_id,
529: s_student_todo_type,
530: sequence_number,

Line 896: l_v_fee_cal_type igs_ca_inst_all.cal_type%TYPE;

892: v_record_found BOOLEAN := FALSE;
893: v_create_dt DATE;
894: l_c_closing_status igs_fi_gl_periods_v.closing_status%TYPE;
895: l_n_person_id hz_parties.party_id%TYPE;
896: l_v_fee_cal_type igs_ca_inst_all.cal_type%TYPE;
897: l_n_fee_ci_sequence_number igs_ca_inst_all.sequence_number%TYPE;
898: l_n_person_grp_id igs_pe_prsid_grp_mem_v.group_id%TYPE;
899: l_d_gl_date DATE;
900: l_v_load_cal_type igs_ca_inst_all.cal_type%TYPE;

Line 897: l_n_fee_ci_sequence_number igs_ca_inst_all.sequence_number%TYPE;

893: v_create_dt DATE;
894: l_c_closing_status igs_fi_gl_periods_v.closing_status%TYPE;
895: l_n_person_id hz_parties.party_id%TYPE;
896: l_v_fee_cal_type igs_ca_inst_all.cal_type%TYPE;
897: l_n_fee_ci_sequence_number igs_ca_inst_all.sequence_number%TYPE;
898: l_n_person_grp_id igs_pe_prsid_grp_mem_v.group_id%TYPE;
899: l_d_gl_date DATE;
900: l_v_load_cal_type igs_ca_inst_all.cal_type%TYPE;
901: l_n_load_ci_sequence_number igs_ca_inst_all.sequence_number%TYPE;

Line 900: l_v_load_cal_type igs_ca_inst_all.cal_type%TYPE;

896: l_v_fee_cal_type igs_ca_inst_all.cal_type%TYPE;
897: l_n_fee_ci_sequence_number igs_ca_inst_all.sequence_number%TYPE;
898: l_n_person_grp_id igs_pe_prsid_grp_mem_v.group_id%TYPE;
899: l_d_gl_date DATE;
900: l_v_load_cal_type igs_ca_inst_all.cal_type%TYPE;
901: l_n_load_ci_sequence_number igs_ca_inst_all.sequence_number%TYPE;
902: l_b_fci_lci BOOLEAN := FALSE;
903: l_org_id VARCHAR2(15);
904:

Line 901: l_n_load_ci_sequence_number igs_ca_inst_all.sequence_number%TYPE;

897: l_n_fee_ci_sequence_number igs_ca_inst_all.sequence_number%TYPE;
898: l_n_person_grp_id igs_pe_prsid_grp_mem_v.group_id%TYPE;
899: l_d_gl_date DATE;
900: l_v_load_cal_type igs_ca_inst_all.cal_type%TYPE;
901: l_n_load_ci_sequence_number igs_ca_inst_all.sequence_number%TYPE;
902: l_b_fci_lci BOOLEAN := FALSE;
903: l_org_id VARCHAR2(15);
904:
905: CURSOR c_fee_cal_instance (