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.

[Home] [Help]

APPS.IGS_FI_PRC_STDNT_DPSTS dependencies on IGS_FI_CREDITS

Line 297: p_c_credit_number igs_fi_credits.credit_number%TYPE,

293: END IF;
294: END check_enrollment;
295:
296: PROCEDURE generate_log(p_n_person_id igs_fi_parties_v.person_id%TYPE,
297: p_c_credit_number igs_fi_credits.credit_number%TYPE,
298: p_n_amount igs_fi_credits.amount%TYPE,
299: p_c_action VARCHAR2,
300: p_c_payment_cr_num igs_fi_credits.credit_number%TYPE,
301: p_c_message_name fnd_new_messages.message_name%TYPE,

Line 298: p_n_amount igs_fi_credits.amount%TYPE,

294: END check_enrollment;
295:
296: PROCEDURE generate_log(p_n_person_id igs_fi_parties_v.person_id%TYPE,
297: p_c_credit_number igs_fi_credits.credit_number%TYPE,
298: p_n_amount igs_fi_credits.amount%TYPE,
299: p_c_action VARCHAR2,
300: p_c_payment_cr_num igs_fi_credits.credit_number%TYPE,
301: p_c_message_name fnd_new_messages.message_name%TYPE,
302: p_c_sca_att_status igs_lookup_values.lookup_code%TYPE) AS

Line 300: p_c_payment_cr_num igs_fi_credits.credit_number%TYPE,

296: PROCEDURE generate_log(p_n_person_id igs_fi_parties_v.person_id%TYPE,
297: p_c_credit_number igs_fi_credits.credit_number%TYPE,
298: p_n_amount igs_fi_credits.amount%TYPE,
299: p_c_action VARCHAR2,
300: p_c_payment_cr_num igs_fi_credits.credit_number%TYPE,
301: p_c_message_name fnd_new_messages.message_name%TYPE,
302: p_c_sca_att_status igs_lookup_values.lookup_code%TYPE) AS
303: /******************************************************************
304: Created By : Vinay Chappidi

Line 855: PROCEDURE take_action(p_n_credit_id igs_fi_credits_all.credit_id%TYPE,

851: p_b_ret_status := FALSE;
852: END IF;
853: END validate_log_parameters;
854:
855: PROCEDURE take_action(p_n_credit_id igs_fi_credits_all.credit_id%TYPE,
856: p_d_gl_date DATE,
857: p_c_action igs_lookup_values.lookup_code%TYPE,
858: p_c_credit_number OUT NOCOPY igs_fi_credits.credit_number%TYPE,
859: p_c_message_name OUT NOCOPY fnd_new_messages.message_name%TYPE)

Line 858: p_c_credit_number OUT NOCOPY igs_fi_credits.credit_number%TYPE,

854:
855: PROCEDURE take_action(p_n_credit_id igs_fi_credits_all.credit_id%TYPE,
856: p_d_gl_date DATE,
857: p_c_action igs_lookup_values.lookup_code%TYPE,
858: p_c_credit_number OUT NOCOPY igs_fi_credits.credit_number%TYPE,
859: p_c_message_name OUT NOCOPY fnd_new_messages.message_name%TYPE)
860: AS
861: /******************************************************************
862: Created By : Vinay Chappidi

Line 874: l_c_receipt_number igs_fi_credits.credit_number%TYPE;

870: ******************************************************************/
871:
872: l_b_ret_status BOOLEAN;
873: l_c_message_name fnd_new_messages.message_name%TYPE;
874: l_c_receipt_number igs_fi_credits.credit_number%TYPE;
875: BEGIN
876: IF p_c_action = g_c_transfer THEN
877: BEGIN
878: SAVEPOINT s_before_action;

Line 939: FROM igs_fi_credits_all crd,

935: cp_c_fee_cal_type igs_ca_inst.cal_type%TYPE,
936: cp_n_fee_seq_num igs_ca_inst.sequence_number%TYPE)
937: IS
938: SELECT crd.*
939: FROM igs_fi_credits_all crd,
940: igs_fi_cr_types crt
941: WHERE crd.party_id = cp_n_person_id AND
942: crd.credit_type_id = crt.credit_type_id AND
943: crt.credit_class = g_c_othdeposit AND

Line 964: l_c_credit_number igs_fi_credits.credit_number%TYPE;

960: ) AND
961: crd.status = 'CLEARED';
962:
963: l_c_message_name fnd_new_messages.message_name%TYPE;
964: l_c_credit_number igs_fi_credits.credit_number%TYPE;
965: l_b_othdep_exists BOOLEAN := FALSE;
966: BEGIN
967: FOR l_rec_c_oth_dpsts IN c_oth_dpsts(p_n_person_id,l_rec_input_param.credit_type_id,l_rec_input_param.fee_cal_type, l_rec_input_param.fee_cal_seq_num)
968: LOOP

Line 1043: FROM igs_fi_credits crd,

1039: SELECT crd.credit_id,crd.credit_type_id,
1040: TO_NUMBER(crd.source_transaction_ref) source_transaction_ref,
1041: crd.credit_number,
1042: crd.amount
1043: FROM igs_fi_credits crd,
1044: igs_fi_cr_types crt
1045: WHERE crd.party_id = cp_n_person_id AND
1046: crd.credit_type_id = crt.credit_type_id AND
1047: (

Line 1173: l_c_credit_number igs_fi_credits.credit_number%TYPE;

1169: l_c_criteria igs_lookup_values.lookup_code%TYPE;
1170: l_c_sca_att_status igs_lookup_values.lookup_code%TYPE;
1171:
1172: l_c_message_name fnd_new_messages.message_name%TYPE;
1173: l_c_credit_number igs_fi_credits.credit_number%TYPE;
1174:
1175: BEGIN
1176:
1177: -- Select all records in the Credits Table with a Credit Class of EnrDeposit and with status as Cleared

Line 1421: END LOOP; -- igs_fi_credits table End Loop

1417: l_c_credit_number,
1418: l_c_message_name,
1419: l_c_sca_att_status);
1420: END IF;
1421: END LOOP; -- igs_fi_credits table End Loop
1422: -- If there are no deposits in Cleared Status then log a message
1423: -- Depending on the test mode parameter call to the generic procedure will be made
1424: -- Irrespective of the test mode parameter, messages have to be logged
1425: IF NOT l_b_dpsts_exist THEN