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

Line 407: p_fee_cal_type igs_ca_inst.cal_type%TYPE ;

403: 'ACTUAL' is passed instead of NULL, re-initialized the process next record variable
404: to FASLE, it might have been set to TRUE while processing the previously fetched record
405: */
406:
407: p_fee_cal_type igs_ca_inst.cal_type%TYPE ;
408: p_fee_ci_sequence_num igs_ca_inst.sequence_number%TYPE ;
409:
410: l_v_message_name fnd_new_messages.message_name%TYPE;
411: l_v_manage_accounts igs_fi_control.manage_accounts%TYPE;

Line 408: p_fee_ci_sequence_num igs_ca_inst.sequence_number%TYPE ;

404: to FASLE, it might have been set to TRUE while processing the previously fetched record
405: */
406:
407: p_fee_cal_type igs_ca_inst.cal_type%TYPE ;
408: p_fee_ci_sequence_num igs_ca_inst.sequence_number%TYPE ;
409:
410: l_v_message_name fnd_new_messages.message_name%TYPE;
411: l_v_manage_accounts igs_fi_control.manage_accounts%TYPE;
412: l_n_waiver_amount NUMBER;

Line 450: l_fee_cal_type igs_ca_inst.cal_type%TYPE;

446: v_message_name VARCHAR2(30);
447: l_rpt_person_id hz_parties.party_id%TYPE;
448: l_return_status VARCHAR2(1);
449: l_msg_data fnd_new_messages.message_name%TYPE;
450: l_fee_cal_type igs_ca_inst.cal_type%TYPE;
451: l_fee_ci_sequence_number igs_ca_inst.sequence_number%TYPE;
452: l_d_gl_date DATE;
453: l_c_closing_status igs_fi_gl_periods_v.closing_status%TYPE;
454: l_n_msg_count NUMBER(10);

Line 451: l_fee_ci_sequence_number igs_ca_inst.sequence_number%TYPE;

447: l_rpt_person_id hz_parties.party_id%TYPE;
448: l_return_status VARCHAR2(1);
449: l_msg_data fnd_new_messages.message_name%TYPE;
450: l_fee_cal_type igs_ca_inst.cal_type%TYPE;
451: l_fee_ci_sequence_number igs_ca_inst.sequence_number%TYPE;
452: l_d_gl_date DATE;
453: l_c_closing_status igs_fi_gl_periods_v.closing_status%TYPE;
454: l_n_msg_count NUMBER(10);
455: l_v_msg_data VARCHAR2(1000);

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 516: rpt_load_cal_type igs_ca_inst.cal_type%TYPE;

512: Modified cursor c_get_todo_ref_csr to add join with
513: cal_type and sequence_number
514: **************************************************************/
515:
516: rpt_load_cal_type igs_ca_inst.cal_type%TYPE;
517: rpt_load_ci_sequence_number igs_ca_inst.sequence_number%TYPE;
518: l_message fnd_new_messages.message_name%TYPE;
519: l_message_name fnd_new_messages.message_name%TYPE;
520: l_n_waiver_amount NUMBER;

Line 517: rpt_load_ci_sequence_number igs_ca_inst.sequence_number%TYPE;

513: cal_type and sequence_number
514: **************************************************************/
515:
516: rpt_load_cal_type igs_ca_inst.cal_type%TYPE;
517: rpt_load_ci_sequence_number igs_ca_inst.sequence_number%TYPE;
518: l_message fnd_new_messages.message_name%TYPE;
519: l_message_name fnd_new_messages.message_name%TYPE;
520: l_n_waiver_amount NUMBER;
521: l_v_person_number hz_parties.party_number%TYPE;

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 (

Line 1299: p_fee_cal_type igs_ca_inst.cal_type%TYPE ;

1295: p_upfront_payment_option IGS_FI_HECS_PAY_OPTN.hecs_payment_option%TYPE,
1296: p_org_id NUMBER
1297: ) AS
1298: p_effective_dt DATE;
1299: p_fee_cal_type igs_ca_inst.cal_type%TYPE ;
1300: p_fee_ci_sequence_number igs_ca_inst.sequence_number%TYPE;
1301: BEGIN
1302: -- finp_prc_hecs_pymnt_optn
1303: -- Routine to control processing student's IGS_PS_COURSE attempt HECS payment option

Line 1300: p_fee_ci_sequence_number igs_ca_inst.sequence_number%TYPE;

1296: p_org_id NUMBER
1297: ) AS
1298: p_effective_dt DATE;
1299: p_fee_cal_type igs_ca_inst.cal_type%TYPE ;
1300: p_fee_ci_sequence_number igs_ca_inst.sequence_number%TYPE;
1301: BEGIN
1302: -- finp_prc_hecs_pymnt_optn
1303: -- Routine to control processing student's IGS_PS_COURSE attempt HECS payment option
1304: -- on the basis of their assessed liability and any up front payments made