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_PRC_SP_FEES dependencies on IGS_CA_INST

Line 42: g_v_alternatecode igs_ca_inst.alternate_code%TYPE;

38: g_v_special CONSTANT VARCHAR2(10) := 'SPECIAL';
39: g_v_yes CONSTANT VARCHAR2(1) := 'Y';
40: g_v_no CONSTANT VARCHAR2(1) := 'N';
41: g_v_sua_status CONSTANT VARCHAR2(20) := 'UNIT_ATTEMPT_STATUS';
42: g_v_alternatecode igs_ca_inst.alternate_code%TYPE;
43:
44: FUNCTION fisp_lock_records(p_n_person_id IN igs_fi_spa_fee_prds.person_id%TYPE,
45: p_v_course_cd IN igs_fi_spa_fee_prds.course_cd%TYPE,
46: p_v_fee_cal_type IN igs_fi_spa_fee_prds.fee_cal_type%TYPE,

Line 815: p_v_fee_cal_type OUT NOCOPY igs_ca_inst.cal_type%TYPE,

811: p_n_person_grp_id IN igs_pe_persid_group_v.group_id%TYPE,
812: p_v_fee_period IN VARCHAR2,
813: p_v_test_run IN VARCHAR2,
814: p_d_gl_date IN VARCHAR2,
815: p_v_fee_cal_type OUT NOCOPY igs_ca_inst.cal_type%TYPE,
816: p_n_fee_ci_sequence_number OUT NOCOPY igs_ca_inst.sequence_number%TYPE,
817: p_v_ld_cal_type OUT NOCOPY igs_ca_inst.cal_type%TYPE,
818: p_n_ld_ci_sequence_number OUT NOCOPY igs_ca_inst.sequence_number%TYPE,
819: p_val_status OUT NOCOPY BOOLEAN) IS

Line 816: p_n_fee_ci_sequence_number OUT NOCOPY igs_ca_inst.sequence_number%TYPE,

812: p_v_fee_period IN VARCHAR2,
813: p_v_test_run IN VARCHAR2,
814: p_d_gl_date IN VARCHAR2,
815: p_v_fee_cal_type OUT NOCOPY igs_ca_inst.cal_type%TYPE,
816: p_n_fee_ci_sequence_number OUT NOCOPY igs_ca_inst.sequence_number%TYPE,
817: p_v_ld_cal_type OUT NOCOPY igs_ca_inst.cal_type%TYPE,
818: p_n_ld_ci_sequence_number OUT NOCOPY igs_ca_inst.sequence_number%TYPE,
819: p_val_status OUT NOCOPY BOOLEAN) IS
820: ------------------------------------------------------------------

Line 817: p_v_ld_cal_type OUT NOCOPY igs_ca_inst.cal_type%TYPE,

813: p_v_test_run IN VARCHAR2,
814: p_d_gl_date IN VARCHAR2,
815: p_v_fee_cal_type OUT NOCOPY igs_ca_inst.cal_type%TYPE,
816: p_n_fee_ci_sequence_number OUT NOCOPY igs_ca_inst.sequence_number%TYPE,
817: p_v_ld_cal_type OUT NOCOPY igs_ca_inst.cal_type%TYPE,
818: p_n_ld_ci_sequence_number OUT NOCOPY igs_ca_inst.sequence_number%TYPE,
819: p_val_status OUT NOCOPY BOOLEAN) IS
820: ------------------------------------------------------------------
821: --Created by :Umesh Udayaprakash, Oracle India (in)

Line 818: p_n_ld_ci_sequence_number OUT NOCOPY igs_ca_inst.sequence_number%TYPE,

814: p_d_gl_date IN VARCHAR2,
815: p_v_fee_cal_type OUT NOCOPY igs_ca_inst.cal_type%TYPE,
816: p_n_fee_ci_sequence_number OUT NOCOPY igs_ca_inst.sequence_number%TYPE,
817: p_v_ld_cal_type OUT NOCOPY igs_ca_inst.cal_type%TYPE,
818: p_n_ld_ci_sequence_number OUT NOCOPY igs_ca_inst.sequence_number%TYPE,
819: p_val_status OUT NOCOPY BOOLEAN) IS
820: ------------------------------------------------------------------
821: --Created by :Umesh Udayaprakash, Oracle India (in)
822: --Date created: 17-OCT-2003

Line 856: l_v_ld_cal_type igs_ca_inst.cal_type%TYPE;

852: l_b_parameter_val_status BOOLEAN;
853: l_person_id c_person_id%ROWTYPE;
854: l_person_grp_id c_person_grp_id%ROWTYPE;
855:
856: l_v_ld_cal_type igs_ca_inst.cal_type%TYPE;
857: l_n_ld_ci_sequence_number igs_ca_inst.sequence_number%TYPE;
858: l_v_message_name fnd_new_messages.message_name%TYPE;
859: l_b_return_stat BOOLEAN;
860: l_v_closing_status igs_fi_gl_periods_v.closing_status%TYPE;

Line 857: l_n_ld_ci_sequence_number igs_ca_inst.sequence_number%TYPE;

853: l_person_id c_person_id%ROWTYPE;
854: l_person_grp_id c_person_grp_id%ROWTYPE;
855:
856: l_v_ld_cal_type igs_ca_inst.cal_type%TYPE;
857: l_n_ld_ci_sequence_number igs_ca_inst.sequence_number%TYPE;
858: l_v_message_name fnd_new_messages.message_name%TYPE;
859: l_b_return_stat BOOLEAN;
860: l_v_closing_status igs_fi_gl_periods_v.closing_status%TYPE;
861:

Line 862: l_v_fee_cal_type igs_ca_inst.cal_type%TYPE;

858: l_v_message_name fnd_new_messages.message_name%TYPE;
859: l_b_return_stat BOOLEAN;
860: l_v_closing_status igs_fi_gl_periods_v.closing_status%TYPE;
861:
862: l_v_fee_cal_type igs_ca_inst.cal_type%TYPE;
863: l_n_fee_ci_sequence_number igs_ca_inst.sequence_number%TYPE;
864:
865: BEGIN
866:

Line 863: l_n_fee_ci_sequence_number igs_ca_inst.sequence_number%TYPE;

859: l_b_return_stat BOOLEAN;
860: l_v_closing_status igs_fi_gl_periods_v.closing_status%TYPE;
861:
862: l_v_fee_cal_type igs_ca_inst.cal_type%TYPE;
863: l_n_fee_ci_sequence_number igs_ca_inst.sequence_number%TYPE;
864:
865: BEGIN
866:
867: l_b_parameter_val_status := TRUE;

Line 1009: l_v_fee_cal_type igs_ca_inst.cal_type%TYPE;

1005: l_b_recs_found BOOLEAN;
1006: l_b_person_grp_data_found BOOLEAN;
1007: l_v_return_status VARCHAR2(1);
1008: l_b_validate_parm_status BOOLEAN;
1009: l_v_fee_cal_type igs_ca_inst.cal_type%TYPE;
1010: l_n_fee_ci_seq_number igs_ca_inst.sequence_number%TYPE;
1011: l_v_load_cal_type igs_ca_inst.cal_type%TYPE;
1012: l_n_load_ci_seq_number igs_ca_inst.sequence_number%TYPE;
1013: l_org_id VARCHAR2(15);

Line 1010: l_n_fee_ci_seq_number igs_ca_inst.sequence_number%TYPE;

1006: l_b_person_grp_data_found BOOLEAN;
1007: l_v_return_status VARCHAR2(1);
1008: l_b_validate_parm_status BOOLEAN;
1009: l_v_fee_cal_type igs_ca_inst.cal_type%TYPE;
1010: l_n_fee_ci_seq_number igs_ca_inst.sequence_number%TYPE;
1011: l_v_load_cal_type igs_ca_inst.cal_type%TYPE;
1012: l_n_load_ci_seq_number igs_ca_inst.sequence_number%TYPE;
1013: l_org_id VARCHAR2(15);
1014: --Cursor For Getting The Alternate Code and Description For The Fee Period.

Line 1011: l_v_load_cal_type igs_ca_inst.cal_type%TYPE;

1007: l_v_return_status VARCHAR2(1);
1008: l_b_validate_parm_status BOOLEAN;
1009: l_v_fee_cal_type igs_ca_inst.cal_type%TYPE;
1010: l_n_fee_ci_seq_number igs_ca_inst.sequence_number%TYPE;
1011: l_v_load_cal_type igs_ca_inst.cal_type%TYPE;
1012: l_n_load_ci_seq_number igs_ca_inst.sequence_number%TYPE;
1013: l_org_id VARCHAR2(15);
1014: --Cursor For Getting The Alternate Code and Description For The Fee Period.
1015: CURSOR c_get_alt_code_desc(cp_v_cal_type igs_ca_inst.cal_type%TYPE,

Line 1012: l_n_load_ci_seq_number igs_ca_inst.sequence_number%TYPE;

1008: l_b_validate_parm_status BOOLEAN;
1009: l_v_fee_cal_type igs_ca_inst.cal_type%TYPE;
1010: l_n_fee_ci_seq_number igs_ca_inst.sequence_number%TYPE;
1011: l_v_load_cal_type igs_ca_inst.cal_type%TYPE;
1012: l_n_load_ci_seq_number igs_ca_inst.sequence_number%TYPE;
1013: l_org_id VARCHAR2(15);
1014: --Cursor For Getting The Alternate Code and Description For The Fee Period.
1015: CURSOR c_get_alt_code_desc(cp_v_cal_type igs_ca_inst.cal_type%TYPE,
1016: cp_n_sequence_number igs_ca_inst.sequence_number%TYPE) IS

Line 1015: CURSOR c_get_alt_code_desc(cp_v_cal_type igs_ca_inst.cal_type%TYPE,

1011: l_v_load_cal_type igs_ca_inst.cal_type%TYPE;
1012: l_n_load_ci_seq_number igs_ca_inst.sequence_number%TYPE;
1013: l_org_id VARCHAR2(15);
1014: --Cursor For Getting The Alternate Code and Description For The Fee Period.
1015: CURSOR c_get_alt_code_desc(cp_v_cal_type igs_ca_inst.cal_type%TYPE,
1016: cp_n_sequence_number igs_ca_inst.sequence_number%TYPE) IS
1017: SELECT alternate_code, description
1018: FROM igs_ca_inst
1019: WHERE cal_type = cp_v_cal_type

Line 1016: cp_n_sequence_number igs_ca_inst.sequence_number%TYPE) IS

1012: l_n_load_ci_seq_number igs_ca_inst.sequence_number%TYPE;
1013: l_org_id VARCHAR2(15);
1014: --Cursor For Getting The Alternate Code and Description For The Fee Period.
1015: CURSOR c_get_alt_code_desc(cp_v_cal_type igs_ca_inst.cal_type%TYPE,
1016: cp_n_sequence_number igs_ca_inst.sequence_number%TYPE) IS
1017: SELECT alternate_code, description
1018: FROM igs_ca_inst
1019: WHERE cal_type = cp_v_cal_type
1020: AND sequence_number = cp_n_sequence_number;

Line 1018: FROM igs_ca_inst

1014: --Cursor For Getting The Alternate Code and Description For The Fee Period.
1015: CURSOR c_get_alt_code_desc(cp_v_cal_type igs_ca_inst.cal_type%TYPE,
1016: cp_n_sequence_number igs_ca_inst.sequence_number%TYPE) IS
1017: SELECT alternate_code, description
1018: FROM igs_ca_inst
1019: WHERE cal_type = cp_v_cal_type
1020: AND sequence_number = cp_n_sequence_number;
1021: l_c_alt_code_desc c_get_alt_code_desc%ROWTYPE;
1022: --Cursor For Getting The Group Code For The Group Id

Line 1306: CURSOR c_get_alt_code_desc(cp_v_cal_type igs_ca_inst.cal_type%TYPE,

1302: (cp_n_ld_seq_number IS NULL)
1303: );
1304:
1305: --Cursor To Get The Alternate Code For The Cal_type And sequence number
1306: CURSOR c_get_alt_code_desc(cp_v_cal_type igs_ca_inst.cal_type%TYPE,
1307: cp_n_sequence_number igs_ca_inst.sequence_number%TYPE) IS
1308: SELECT alternate_code,description
1309: FROM igs_ca_inst
1310: WHERE cal_type = cp_v_cal_type

Line 1307: cp_n_sequence_number igs_ca_inst.sequence_number%TYPE) IS

1303: );
1304:
1305: --Cursor To Get The Alternate Code For The Cal_type And sequence number
1306: CURSOR c_get_alt_code_desc(cp_v_cal_type igs_ca_inst.cal_type%TYPE,
1307: cp_n_sequence_number igs_ca_inst.sequence_number%TYPE) IS
1308: SELECT alternate_code,description
1309: FROM igs_ca_inst
1310: WHERE cal_type = cp_v_cal_type
1311: AND sequence_number = cp_n_sequence_number;

Line 1309: FROM igs_ca_inst

1305: --Cursor To Get The Alternate Code For The Cal_type And sequence number
1306: CURSOR c_get_alt_code_desc(cp_v_cal_type igs_ca_inst.cal_type%TYPE,
1307: cp_n_sequence_number igs_ca_inst.sequence_number%TYPE) IS
1308: SELECT alternate_code,description
1309: FROM igs_ca_inst
1310: WHERE cal_type = cp_v_cal_type
1311: AND sequence_number = cp_n_sequence_number;
1312: CURSOR c_check_child_exists(cp_n_person_id igs_pe_std_todo.person_id%TYPE,
1313: cp_n_sequence_number igs_pe_std_todo_ref.sequence_number%TYPE,

Line 1325: l_v_alt_code_desc igs_ca_inst.alternate_code%TYPE;

1321: l_check_child_exists c_check_child_exists%ROWTYPE;
1322: l_c_get_todo_recs c_get_todo_recs%ROWTYPE;
1323: l_c_get_todo_ref_recs c_get_todo_ref_recs%ROWTYPE;
1324: l_c_alt_code_desc c_get_alt_code_desc%ROWTYPE;
1325: l_v_alt_code_desc igs_ca_inst.alternate_code%TYPE;
1326: l_v_ci_desc igs_ca_inst.description%TYPE;
1327:
1328: l_v_person_number hz_parties.party_number%TYPE;
1329: l_unit_section VARCHAR2(4000);

Line 1326: l_v_ci_desc igs_ca_inst.description%TYPE;

1322: l_c_get_todo_recs c_get_todo_recs%ROWTYPE;
1323: l_c_get_todo_ref_recs c_get_todo_ref_recs%ROWTYPE;
1324: l_c_alt_code_desc c_get_alt_code_desc%ROWTYPE;
1325: l_v_alt_code_desc igs_ca_inst.alternate_code%TYPE;
1326: l_v_ci_desc igs_ca_inst.description%TYPE;
1327:
1328: l_v_person_number hz_parties.party_number%TYPE;
1329: l_unit_section VARCHAR2(4000);
1330:

Line 1336: l_v_fee_cal_type igs_ca_inst.cal_type%TYPE;

1332: -- To identify whether any records are found for given the input criteria.
1333: l_v_return_status VARCHAR2(1);
1334: l_count NUMBER(5);
1335: l_msg VARCHAR2(2000);
1336: l_v_fee_cal_type igs_ca_inst.cal_type%TYPE;
1337: l_n_fee_ci_sequence_number PLS_INTEGER;
1338: l_n_msg_count NUMBER;
1339: l_v_msg_data VARCHAR2(32767);
1340: l_b_rel_exists BOOLEAN;