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_IMPCLC_ANC_CHGS dependencies on IGS_PE_PERSON

Line 45: FUNCTION Check_Person_Id(p_person_id IN igs_pe_person.person_id%TYPE,

41:
42: l_rowid VARCHAR2(25) := NULL;
43:
44: -- Added new parameter p_person_id as part of Enh# 2831569.
45: FUNCTION Check_Person_Id(p_person_id IN igs_pe_person.person_id%TYPE,
46: p_person_id_type IN igs_pe_person.Person_Id_Type%TYPE,
47: p_api_person_id IN igs_pe_person.Api_Person_Id%TYPE) RETURN BOOLEAN;
48:
49: FUNCTION Get_Person_Number(p_person_id IN igs_pe_person.Person_Id%TYPE) RETURN IGS_PE_PERSON.Person_Number%TYPE;

Line 46: p_person_id_type IN igs_pe_person.Person_Id_Type%TYPE,

42: l_rowid VARCHAR2(25) := NULL;
43:
44: -- Added new parameter p_person_id as part of Enh# 2831569.
45: FUNCTION Check_Person_Id(p_person_id IN igs_pe_person.person_id%TYPE,
46: p_person_id_type IN igs_pe_person.Person_Id_Type%TYPE,
47: p_api_person_id IN igs_pe_person.Api_Person_Id%TYPE) RETURN BOOLEAN;
48:
49: FUNCTION Get_Person_Number(p_person_id IN igs_pe_person.Person_Id%TYPE) RETURN IGS_PE_PERSON.Person_Number%TYPE;
50:

Line 47: p_api_person_id IN igs_pe_person.Api_Person_Id%TYPE) RETURN BOOLEAN;

43:
44: -- Added new parameter p_person_id as part of Enh# 2831569.
45: FUNCTION Check_Person_Id(p_person_id IN igs_pe_person.person_id%TYPE,
46: p_person_id_type IN igs_pe_person.Person_Id_Type%TYPE,
47: p_api_person_id IN igs_pe_person.Api_Person_Id%TYPE) RETURN BOOLEAN;
48:
49: FUNCTION Get_Person_Number(p_person_id IN igs_pe_person.Person_Id%TYPE) RETURN IGS_PE_PERSON.Person_Number%TYPE;
50:
51: FUNCTION finp_get_anc_rate(p_fee_cal_type IN igs_fi_anc_rates.Fee_Cal_Type%TYPE,

Line 49: FUNCTION Get_Person_Number(p_person_id IN igs_pe_person.Person_Id%TYPE) RETURN IGS_PE_PERSON.Person_Number%TYPE;

45: FUNCTION Check_Person_Id(p_person_id IN igs_pe_person.person_id%TYPE,
46: p_person_id_type IN igs_pe_person.Person_Id_Type%TYPE,
47: p_api_person_id IN igs_pe_person.Api_Person_Id%TYPE) RETURN BOOLEAN;
48:
49: FUNCTION Get_Person_Number(p_person_id IN igs_pe_person.Person_Id%TYPE) RETURN IGS_PE_PERSON.Person_Number%TYPE;
50:
51: FUNCTION finp_get_anc_rate(p_fee_cal_type IN igs_fi_anc_rates.Fee_Cal_Type%TYPE,
52: p_fee_ci_sequence_number IN igs_fi_anc_rates.Fee_Ci_Sequence_Number%TYPE,
53: p_fee_type IN igs_fi_anc_rates.Fee_Type%TYPE,

Line 192: p_person_id IN igs_pe_person.Person_Id%TYPE ,

188:
189: FUNCTION finp_validate_input_data(p_fee_cal_type IN igs_fi_anc_rates.Fee_Cal_Type%TYPE,
190: p_fee_ci_sequence_number IN igs_fi_anc_rates.Fee_Ci_Sequence_Number%TYPE,
191: p_fee_type IN igs_fi_anc_rates.Fee_Type%TYPE,
192: p_person_id IN igs_pe_person.Person_Id%TYPE ,
193: p_person_id_type IN igs_pe_person.Person_Id_Type%TYPE ,
194: p_api_person_id IN igs_pe_person.Api_Person_Id%TYPE ,
195: p_err_msg_name OUT NOCOPY VARCHAR2) RETURN BOOLEAN AS
196: /***********************************************************************************************

Line 193: p_person_id_type IN igs_pe_person.Person_Id_Type%TYPE ,

189: FUNCTION finp_validate_input_data(p_fee_cal_type IN igs_fi_anc_rates.Fee_Cal_Type%TYPE,
190: p_fee_ci_sequence_number IN igs_fi_anc_rates.Fee_Ci_Sequence_Number%TYPE,
191: p_fee_type IN igs_fi_anc_rates.Fee_Type%TYPE,
192: p_person_id IN igs_pe_person.Person_Id%TYPE ,
193: p_person_id_type IN igs_pe_person.Person_Id_Type%TYPE ,
194: p_api_person_id IN igs_pe_person.Api_Person_Id%TYPE ,
195: p_err_msg_name OUT NOCOPY VARCHAR2) RETURN BOOLEAN AS
196: /***********************************************************************************************
197:

Line 194: p_api_person_id IN igs_pe_person.Api_Person_Id%TYPE ,

190: p_fee_ci_sequence_number IN igs_fi_anc_rates.Fee_Ci_Sequence_Number%TYPE,
191: p_fee_type IN igs_fi_anc_rates.Fee_Type%TYPE,
192: p_person_id IN igs_pe_person.Person_Id%TYPE ,
193: p_person_id_type IN igs_pe_person.Person_Id_Type%TYPE ,
194: p_api_person_id IN igs_pe_person.Api_Person_Id%TYPE ,
195: p_err_msg_name OUT NOCOPY VARCHAR2) RETURN BOOLEAN AS
196: /***********************************************************************************************
197:
198: Created By: Amit Gairola

Line 345: p_person_id IN igs_pe_person.Person_Id%TYPE ,

341: END finp_validate_input_data;
342:
343: PROCEDURE finp_imp_calc_anc_charges(errbuf OUT NOCOPY VARCHAR2,
344: retcode OUT NOCOPY NUMBER,
345: p_person_id IN igs_pe_person.Person_Id%TYPE ,
346: p_person_id_type IN igs_pe_person.Person_Id_Type%TYPE ,
347: p_api_person_id IN igs_pe_person.Api_Person_Id%TYPE ,
348: p_fee_cal_type IN igs_fi_anc_rates.Fee_Cal_Type%TYPE,
349: p_fee_ci_sequence_number IN igs_fi_anc_rates.Fee_Ci_Sequence_Number%TYPE,

Line 346: p_person_id_type IN igs_pe_person.Person_Id_Type%TYPE ,

342:
343: PROCEDURE finp_imp_calc_anc_charges(errbuf OUT NOCOPY VARCHAR2,
344: retcode OUT NOCOPY NUMBER,
345: p_person_id IN igs_pe_person.Person_Id%TYPE ,
346: p_person_id_type IN igs_pe_person.Person_Id_Type%TYPE ,
347: p_api_person_id IN igs_pe_person.Api_Person_Id%TYPE ,
348: p_fee_cal_type IN igs_fi_anc_rates.Fee_Cal_Type%TYPE,
349: p_fee_ci_sequence_number IN igs_fi_anc_rates.Fee_Ci_Sequence_Number%TYPE,
350: p_fee_type IN igs_fi_anc_rates.Fee_Type%TYPE ,

Line 347: p_api_person_id IN igs_pe_person.Api_Person_Id%TYPE ,

343: PROCEDURE finp_imp_calc_anc_charges(errbuf OUT NOCOPY VARCHAR2,
344: retcode OUT NOCOPY NUMBER,
345: p_person_id IN igs_pe_person.Person_Id%TYPE ,
346: p_person_id_type IN igs_pe_person.Person_Id_Type%TYPE ,
347: p_api_person_id IN igs_pe_person.Api_Person_Id%TYPE ,
348: p_fee_cal_type IN igs_fi_anc_rates.Fee_Cal_Type%TYPE,
349: p_fee_ci_sequence_number IN igs_fi_anc_rates.Fee_Ci_Sequence_Number%TYPE,
350: p_fee_type IN igs_fi_anc_rates.Fee_Type%TYPE ,
351: p_org_id IN NUMBER) AS

Line 412: l_person_number igs_pe_person.person_number%TYPE;

408: l_person_id igs_pe_alt_pers_id.pe_person_id%TYPE;
409: l_rec_installed igs_fi_control.rec_installed%TYPE;
410: l_exception_flag VARCHAR2(1);
411: l_message VARCHAR2(2000);
412: l_person_number igs_pe_person.person_number%TYPE;
413:
414: -- Variables of type NUMBER
415: l_diff_amount igs_fi_inv_int.invoice_amount_due%TYPE;
416: l_import_charges_id igs_fi_imp_chgs.import_charges_id%TYPE;

Line 458: CURSOR cur_anc_int(cp_person_id IGS_PE_PERSON.Person_Id%TYPE,

454: l_exception EXCEPTION;
455:
456: l_n_waiver_amount NUMBER;
457: -- Cursor for getting the todo records from the Ancillary Interface table
458: CURSOR cur_anc_int(cp_person_id IGS_PE_PERSON.Person_Id%TYPE,
459: cp_person_id_type IGS_PE_PERSON.Person_Id_Type%TYPE,
460: cp_api_person_id IGS_PE_PERSON.Api_Person_Id%TYPE,
461: cp_fee_cal_type IGS_FI_ANC_RATES.Fee_Cal_Type%TYPE,
462: cp_fee_ci_sequence_number IGS_FI_ANC_RATES.Fee_Ci_Sequence_Number%TYPE,

Line 459: cp_person_id_type IGS_PE_PERSON.Person_Id_Type%TYPE,

455:
456: l_n_waiver_amount NUMBER;
457: -- Cursor for getting the todo records from the Ancillary Interface table
458: CURSOR cur_anc_int(cp_person_id IGS_PE_PERSON.Person_Id%TYPE,
459: cp_person_id_type IGS_PE_PERSON.Person_Id_Type%TYPE,
460: cp_api_person_id IGS_PE_PERSON.Api_Person_Id%TYPE,
461: cp_fee_cal_type IGS_FI_ANC_RATES.Fee_Cal_Type%TYPE,
462: cp_fee_ci_sequence_number IGS_FI_ANC_RATES.Fee_Ci_Sequence_Number%TYPE,
463: cp_fee_type IGS_FI_ANC_RATES.Fee_Type%TYPE) IS

Line 460: cp_api_person_id IGS_PE_PERSON.Api_Person_Id%TYPE,

456: l_n_waiver_amount NUMBER;
457: -- Cursor for getting the todo records from the Ancillary Interface table
458: CURSOR cur_anc_int(cp_person_id IGS_PE_PERSON.Person_Id%TYPE,
459: cp_person_id_type IGS_PE_PERSON.Person_Id_Type%TYPE,
460: cp_api_person_id IGS_PE_PERSON.Api_Person_Id%TYPE,
461: cp_fee_cal_type IGS_FI_ANC_RATES.Fee_Cal_Type%TYPE,
462: cp_fee_ci_sequence_number IGS_FI_ANC_RATES.Fee_Ci_Sequence_Number%TYPE,
463: cp_fee_type IGS_FI_ANC_RATES.Fee_Type%TYPE) IS
464: SELECT rowid,

Line 483: CURSOR cur_person(cp_person_id_type IGS_PE_PERSON.Person_Id_Type%TYPE,

479: OR (cp_fee_type IS NULL));
480:
481: -- Cursor for getting the Person Id from Alternate Person Id table based on the
482: -- Person Id Type and Alternate Person Id
483: CURSOR cur_person(cp_person_id_type IGS_PE_PERSON.Person_Id_Type%TYPE,
484: cp_api_person_id IGS_PE_PERSON.Api_Person_Id%TYPE) IS
485: SELECT pe_person_id
486: FROM igs_pe_alt_pers_id
487: WHERE person_id_type = cp_person_id_type

Line 484: cp_api_person_id IGS_PE_PERSON.Api_Person_Id%TYPE) IS

480:
481: -- Cursor for getting the Person Id from Alternate Person Id table based on the
482: -- Person Id Type and Alternate Person Id
483: CURSOR cur_person(cp_person_id_type IGS_PE_PERSON.Person_Id_Type%TYPE,
484: cp_api_person_id IGS_PE_PERSON.Api_Person_Id%TYPE) IS
485: SELECT pe_person_id
486: FROM igs_pe_alt_pers_id
487: WHERE person_id_type = cp_person_id_type
488: AND api_person_id = cp_api_person_id;

Line 491: CURSOR cur_impchgs(cp_person_id IGS_PE_PERSON.Person_Id%TYPE,

487: WHERE person_id_type = cp_person_id_type
488: AND api_person_id = cp_api_person_id;
489:
490: -- Cursor for checking whether the record exists in the Import Charges table
491: CURSOR cur_impchgs(cp_person_id IGS_PE_PERSON.Person_Id%TYPE,
492: cp_fee_cal_type IGS_FI_F_TYP_CA_INST.Fee_Cal_Type%TYPE,
493: cp_fee_ci_sequence_number IGS_FI_F_TYP_CA_INST.Fee_Ci_Sequence_Number%TYPE,
494: cp_fee_type IGS_FI_F_TYP_CA_INST.Fee_Type%TYPE,
495: cp_transaction_type VARCHAR2) IS

Line 507: CURSOR cur_inv_int(cp_person_id IGS_PE_PERSON.Person_Id%TYPE,

503:
504: -- Cursor for summing up the values from the Invoice Interface table
505: -- Charges that were reversed or declined are not to be
506: -- considered while summing the invoice_amount values.
507: CURSOR cur_inv_int(cp_person_id IGS_PE_PERSON.Person_Id%TYPE,
508: cp_fee_cal_type IGS_FI_F_TYP_CA_INST.Fee_Cal_Type%TYPE,
509: cp_fee_ci_sequence_number IGS_FI_F_TYP_CA_INST.Fee_Ci_Sequence_Number%TYPE,
510: cp_fee_type IGS_FI_F_TYP_CA_INST.Fee_Type%TYPE,
511: cp_transaction_type VARCHAR2) IS

Line 1169: FUNCTION Check_Person_Id(p_person_id IN igs_pe_person.person_id%TYPE,

1165: errbuf := fnd_message.Get;
1166: igs_ge_msg_stack.conc_exception_hndl;
1167: END finp_imp_calc_anc_charges;
1168:
1169: FUNCTION Check_Person_Id(p_person_id IN igs_pe_person.person_id%TYPE,
1170: p_person_id_type IN igs_pe_person.person_id_type%TYPE,
1171: p_api_person_id IN igs_pe_person.api_person_id%TYPE) RETURN BOOLEAN AS
1172: /***********************************************************************************************
1173:

Line 1170: p_person_id_type IN igs_pe_person.person_id_type%TYPE,

1166: igs_ge_msg_stack.conc_exception_hndl;
1167: END finp_imp_calc_anc_charges;
1168:
1169: FUNCTION Check_Person_Id(p_person_id IN igs_pe_person.person_id%TYPE,
1170: p_person_id_type IN igs_pe_person.person_id_type%TYPE,
1171: p_api_person_id IN igs_pe_person.api_person_id%TYPE) RETURN BOOLEAN AS
1172: /***********************************************************************************************
1173:
1174: Created By: Amit Gairola

Line 1171: p_api_person_id IN igs_pe_person.api_person_id%TYPE) RETURN BOOLEAN AS

1167: END finp_imp_calc_anc_charges;
1168:
1169: FUNCTION Check_Person_Id(p_person_id IN igs_pe_person.person_id%TYPE,
1170: p_person_id_type IN igs_pe_person.person_id_type%TYPE,
1171: p_api_person_id IN igs_pe_person.api_person_id%TYPE) RETURN BOOLEAN AS
1172: /***********************************************************************************************
1173:
1174: Created By: Amit Gairola
1175:

Line 1198: CURSOR cur_person(cp_person_id igs_pe_person.person_id%TYPE,

1194: l_ret BOOLEAN;
1195:
1196: -- Cursor for checking the Person Id in IGS_PE_ALT_PERS_ID table for the
1197: -- Person Id Type and the Alternate Person Id exists in the Person table
1198: CURSOR cur_person(cp_person_id igs_pe_person.person_id%TYPE,
1199: cp_person_id_type IGS_PE_PERSON.Person_Id_Type%TYPE,
1200: cp_api_person_id IGS_PE_PERSON.Api_Person_Id%TYPE) IS
1201: SELECT 'x'
1202: FROM igs_pe_person_base_v ppv,

Line 1199: cp_person_id_type IGS_PE_PERSON.Person_Id_Type%TYPE,

1195:
1196: -- Cursor for checking the Person Id in IGS_PE_ALT_PERS_ID table for the
1197: -- Person Id Type and the Alternate Person Id exists in the Person table
1198: CURSOR cur_person(cp_person_id igs_pe_person.person_id%TYPE,
1199: cp_person_id_type IGS_PE_PERSON.Person_Id_Type%TYPE,
1200: cp_api_person_id IGS_PE_PERSON.Api_Person_Id%TYPE) IS
1201: SELECT 'x'
1202: FROM igs_pe_person_base_v ppv,
1203: igs_pe_alt_pers_id api

Line 1200: cp_api_person_id IGS_PE_PERSON.Api_Person_Id%TYPE) IS

1196: -- Cursor for checking the Person Id in IGS_PE_ALT_PERS_ID table for the
1197: -- Person Id Type and the Alternate Person Id exists in the Person table
1198: CURSOR cur_person(cp_person_id igs_pe_person.person_id%TYPE,
1199: cp_person_id_type IGS_PE_PERSON.Person_Id_Type%TYPE,
1200: cp_api_person_id IGS_PE_PERSON.Api_Person_Id%TYPE) IS
1201: SELECT 'x'
1202: FROM igs_pe_person_base_v ppv,
1203: igs_pe_alt_pers_id api
1204: WHERE ppv.person_id = api.pe_person_id

Line 1202: FROM igs_pe_person_base_v ppv,

1198: CURSOR cur_person(cp_person_id igs_pe_person.person_id%TYPE,
1199: cp_person_id_type IGS_PE_PERSON.Person_Id_Type%TYPE,
1200: cp_api_person_id IGS_PE_PERSON.Api_Person_Id%TYPE) IS
1201: SELECT 'x'
1202: FROM igs_pe_person_base_v ppv,
1203: igs_pe_alt_pers_id api
1204: WHERE ppv.person_id = api.pe_person_id
1205: AND ppv.person_id = cp_person_id
1206: AND api.person_id_type = cp_person_id_type

Line 1231: FUNCTION get_person_number(p_person_id IN igs_pe_person.person_id%TYPE) RETURN igs_pe_person.person_number%TYPE AS

1227:
1228: RETURN l_ret;
1229: END check_person_id;
1230:
1231: FUNCTION get_person_number(p_person_id IN igs_pe_person.person_id%TYPE) RETURN igs_pe_person.person_number%TYPE AS
1232:
1233: /***********************************************************************************************
1234:
1235: Created By: Amit Gairola

Line 1249: l_person_number igs_pe_person.person_number%TYPE;

1245: Who When What
1246:
1247: ********************************************************************************************** */
1248:
1249: l_person_number igs_pe_person.person_number%TYPE;
1250:
1251: -- Cursor for geeting the Person Number from the Person Id
1252: CURSOR cur_person(cp_person_id igs_pe_person.person_id%TYPE) IS
1253: SELECT person_number

Line 1252: CURSOR cur_person(cp_person_id igs_pe_person.person_id%TYPE) IS

1248:
1249: l_person_number igs_pe_person.person_number%TYPE;
1250:
1251: -- Cursor for geeting the Person Number from the Person Id
1252: CURSOR cur_person(cp_person_id igs_pe_person.person_id%TYPE) IS
1253: SELECT person_number
1254: FROM igs_pe_person_base_v
1255: WHERE person_id = cp_person_id;
1256: BEGIN

Line 1254: FROM igs_pe_person_base_v

1250:
1251: -- Cursor for geeting the Person Number from the Person Id
1252: CURSOR cur_person(cp_person_id igs_pe_person.person_id%TYPE) IS
1253: SELECT person_number
1254: FROM igs_pe_person_base_v
1255: WHERE person_id = cp_person_id;
1256: BEGIN
1257:
1258: -- Fetch the Person Number based on the Person Id passed