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.IGF_SE_GEN_001 dependencies on IGF_SE_PAYMENT

Line 173: PROCEDURE display_payroll_params(p_batch_id IN igf_se_payment_int.batch_id%TYPE,

169:
170: END display_auth_process_log;
171:
172:
173: PROCEDURE display_payroll_params(p_batch_id IN igf_se_payment_int.batch_id%TYPE,
174: p_auth_id IN igf_se_auth.auth_id%TYPE,
175: p_validation_lvl IN VARCHAR2
176: ) IS
177: ------------------------------------------------------------------------------------

Line 968: p_batch_id IN igf_se_payment_int.batch_id%TYPE,

964:
965:
966: PROCEDURE payroll_uplaod(errbuf OUT NOCOPY VARCHAR2,
967: retcode OUT NOCOPY NUMBER,
968: p_batch_id IN igf_se_payment_int.batch_id%TYPE,
969: p_auth_id IN igf_se_auth.auth_id%TYPE,
970: p_level IN VARCHAR2) IS
971: ------------------------------------------------------------------------------------
972: --Created by : ssawhney ( Oracle IDC)

Line 985: CURSOR c_payment(cv_batch_id igf_se_payment_int.batch_id%TYPE,

981: -- Added check to by pass the validation of not null columns
982: -------------------------------------------------------------------------------------
983:
984: -- if auth_id is NULL then take all records for the corresponding batch_id
985: CURSOR c_payment(cv_batch_id igf_se_payment_int.batch_id%TYPE,
986: cv_auth_id igf_se_auth.auth_id%TYPE) IS
987: SELECT rowid, sei.*
988: FROM IGF_SE_PAYMENT_INT sei
989: WHERE sei.batch_id = cv_batch_id

Line 988: FROM IGF_SE_PAYMENT_INT sei

984: -- if auth_id is NULL then take all records for the corresponding batch_id
985: CURSOR c_payment(cv_batch_id igf_se_payment_int.batch_id%TYPE,
986: cv_auth_id igf_se_auth.auth_id%TYPE) IS
987: SELECT rowid, sei.*
988: FROM IGF_SE_PAYMENT_INT sei
989: WHERE sei.batch_id = cv_batch_id
990: AND sei.auth_id = NVL(cv_auth_id,sei.auth_id)
991: AND sei.status IN ('NEW', 'UPLOAD')
992: ORDER BY auth_id, person_id

Line 1005: CURSOR c_get_se_errors(c_error_cd igf_se_payment_int.error_code%TYPE) IS

1001: AND a.base_id = b.base_id
1002: AND b.person_id = cv_person_id
1003: AND flag = 'A';
1004:
1005: CURSOR c_get_se_errors(c_error_cd igf_se_payment_int.error_code%TYPE) IS
1006: SELECT meaning
1007: FROM igf_lookups_view
1008: WHERE lookup_type = 'IGF_STUD_EMP_ERROR'
1009: AND lookup_code = c_error_cd;

Line 1013: FROM igf_se_payment_int pint, hz_parties hz

1009: AND lookup_code = c_error_cd;
1010:
1011: CURSOR cur_pymt_int IS
1012: SELECT pint.status, pint.error_code, hz.party_number, pint.auth_id
1013: FROM igf_se_payment_int pint, hz_parties hz
1014: WHERE pint.status IN ('DONE','ERROR')
1015: AND pint.person_id = hz.party_id
1016: AND pint.batch_id = p_batch_id;
1017:

Line 1019: l_source igf_se_payment.source%TYPE;

1015: AND pint.person_id = hz.party_id
1016: AND pint.batch_id = p_batch_id;
1017:
1018: payment_rec c_payment%ROWTYPE;
1019: l_source igf_se_payment.source%TYPE;
1020: l_error_cd igf_se_payment_int.error_code%TYPE DEFAULT NULL;
1021: l_transaction_id igf_se_payment_int.transaction_id%TYPE;
1022: l_batch_id igf_se_payment_int.batch_id%TYPE;
1023: l_auth_id igf_se_payment_int.auth_id%TYPE;

Line 1020: l_error_cd igf_se_payment_int.error_code%TYPE DEFAULT NULL;

1016: AND pint.batch_id = p_batch_id;
1017:
1018: payment_rec c_payment%ROWTYPE;
1019: l_source igf_se_payment.source%TYPE;
1020: l_error_cd igf_se_payment_int.error_code%TYPE DEFAULT NULL;
1021: l_transaction_id igf_se_payment_int.transaction_id%TYPE;
1022: l_batch_id igf_se_payment_int.batch_id%TYPE;
1023: l_auth_id igf_se_payment_int.auth_id%TYPE;
1024: l_ld_cal_type igs_ca_inst.cal_type%TYPE;

Line 1021: l_transaction_id igf_se_payment_int.transaction_id%TYPE;

1017:
1018: payment_rec c_payment%ROWTYPE;
1019: l_source igf_se_payment.source%TYPE;
1020: l_error_cd igf_se_payment_int.error_code%TYPE DEFAULT NULL;
1021: l_transaction_id igf_se_payment_int.transaction_id%TYPE;
1022: l_batch_id igf_se_payment_int.batch_id%TYPE;
1023: l_auth_id igf_se_payment_int.auth_id%TYPE;
1024: l_ld_cal_type igs_ca_inst.cal_type%TYPE;
1025: l_ld_sequence_number igs_ca_inst.sequence_number%TYPE;

Line 1022: l_batch_id igf_se_payment_int.batch_id%TYPE;

1018: payment_rec c_payment%ROWTYPE;
1019: l_source igf_se_payment.source%TYPE;
1020: l_error_cd igf_se_payment_int.error_code%TYPE DEFAULT NULL;
1021: l_transaction_id igf_se_payment_int.transaction_id%TYPE;
1022: l_batch_id igf_se_payment_int.batch_id%TYPE;
1023: l_auth_id igf_se_payment_int.auth_id%TYPE;
1024: l_ld_cal_type igs_ca_inst.cal_type%TYPE;
1025: l_ld_sequence_number igs_ca_inst.sequence_number%TYPE;
1026: l_error_meaming igf_lookups_view.meaning%TYPE;

Line 1023: l_auth_id igf_se_payment_int.auth_id%TYPE;

1019: l_source igf_se_payment.source%TYPE;
1020: l_error_cd igf_se_payment_int.error_code%TYPE DEFAULT NULL;
1021: l_transaction_id igf_se_payment_int.transaction_id%TYPE;
1022: l_batch_id igf_se_payment_int.batch_id%TYPE;
1023: l_auth_id igf_se_payment_int.auth_id%TYPE;
1024: l_ld_cal_type igs_ca_inst.cal_type%TYPE;
1025: l_ld_sequence_number igs_ca_inst.sequence_number%TYPE;
1026: l_error_meaming igf_lookups_view.meaning%TYPE;
1027: l_level VARCHAR2(1);

Line 1034: p_error_cd IN igf_se_payment_int.error_code%TYPE) IS

1030: skip_record EXCEPTION;
1031: l_rec_count NUMBER DEFAULT 0;
1032:
1033: PROCEDURE update_record(payment_rec IN c_payment%ROWTYPE,
1034: p_error_cd IN igf_se_payment_int.error_code%TYPE) IS
1035: --------------------------------------------------------
1036: --Created by : ssawhney on 2nd Jan
1037: --Purpose : local procedure to update IGF_SE_PAYMENT_INT based on p_error_cd
1038: --Change History :

Line 1037: --Purpose : local procedure to update IGF_SE_PAYMENT_INT based on p_error_cd

1033: PROCEDURE update_record(payment_rec IN c_payment%ROWTYPE,
1034: p_error_cd IN igf_se_payment_int.error_code%TYPE) IS
1035: --------------------------------------------------------
1036: --Created by : ssawhney on 2nd Jan
1037: --Purpose : local procedure to update IGF_SE_PAYMENT_INT based on p_error_cd
1038: --Change History :
1039: --Who When What
1040: ----------------------------------------------------------------
1041:

Line 1043: l_error_cd igf_se_payment_int.error_code%TYPE;

1039: --Who When What
1040: ----------------------------------------------------------------
1041:
1042:
1043: l_error_cd igf_se_payment_int.error_code%TYPE;
1044: l_status igf_se_payment_int.status%TYPE;
1045: l_source igf_se_payment.source%TYPE;
1046:
1047: BEGIN

Line 1044: l_status igf_se_payment_int.status%TYPE;

1040: ----------------------------------------------------------------
1041:
1042:
1043: l_error_cd igf_se_payment_int.error_code%TYPE;
1044: l_status igf_se_payment_int.status%TYPE;
1045: l_source igf_se_payment.source%TYPE;
1046:
1047: BEGIN
1048:

Line 1045: l_source igf_se_payment.source%TYPE;

1041:
1042:
1043: l_error_cd igf_se_payment_int.error_code%TYPE;
1044: l_status igf_se_payment_int.status%TYPE;
1045: l_source igf_se_payment.source%TYPE;
1046:
1047: BEGIN
1048:
1049: -- update is being called 2 times, if the error code passed is NULL then

Line 1058: igf_se_payment_int_pkg.update_row(

1054: ELSIF l_error_cd IS NOT NULL THEN
1055: l_status :='ERROR';
1056: END IF;
1057:
1058: igf_se_payment_int_pkg.update_row(
1059: x_rowid => payment_rec.rowid,
1060: x_transaction_id => payment_rec.transaction_id,
1061: x_batch_id => payment_rec.batch_id,
1062: x_payroll_id => payment_rec.payroll_id,

Line 1076: FND_MESSAGE.SET_TOKEN('NAME','igf_se_gen_001.payroll_upload:igf_se_payment_int.update');

1072:
1073: EXCEPTION
1074: WHEN OTHERS THEN
1075: FND_MESSAGE.SET_NAME('IGF','IGF_GE_UNHANDLED_EXP');
1076: FND_MESSAGE.SET_TOKEN('NAME','igf_se_gen_001.payroll_upload:igf_se_payment_int.update');
1077: FND_FILE.PUT_LINE(FND_FILE.LOG,fnd_message.get);
1078: IGS_GE_MSG_STACK.ADD;
1079: -- app_exception.raise_exception;
1080:

Line 1121: igf_se_payment_pkg.insert_row(

1117: -- move record from SE_PAYMENT_INT to SE_PAYMENT once the validation was done
1118: BEGIN
1119: SAVEPOINT se_adjust;
1120: -- validate threshold will not be called from here.
1121: igf_se_payment_pkg.insert_row(
1122: x_rowid => l_rowid,
1123: x_transaction_id => l_transaction_id,
1124: x_payroll_id => payment_rec.payroll_id,
1125: x_payroll_date => payment_rec.payroll_date,

Line 1176: DELETE FROM igf_se_payment_int

1172:
1173: END IF;
1174: END LOOP;
1175:
1176: DELETE FROM igf_se_payment_int
1177: WHERE status = 'DONE'
1178: AND batch_id = l_batch_id;
1179:
1180: EXCEPTION

Line 1217: p_payment_rec IN igf_se_payment%ROWTYPE,

1213: END payroll_uplaod;
1214:
1215:
1216: PROCEDURE payroll_adjust(
1217: p_payment_rec IN igf_se_payment%ROWTYPE,
1218: p_status OUT NOCOPY igf_se_payment_int.status%TYPE,
1219: p_error_cd OUT NOCOPY igf_se_payment_int.error_code%TYPE
1220: )IS
1221: ------------------------------------------------------------------------------------

Line 1218: p_status OUT NOCOPY igf_se_payment_int.status%TYPE,

1214:
1215:
1216: PROCEDURE payroll_adjust(
1217: p_payment_rec IN igf_se_payment%ROWTYPE,
1218: p_status OUT NOCOPY igf_se_payment_int.status%TYPE,
1219: p_error_cd OUT NOCOPY igf_se_payment_int.error_code%TYPE
1220: )IS
1221: ------------------------------------------------------------------------------------
1222: -- Created by : ssawhney ( Oracle IDC)

Line 1219: p_error_cd OUT NOCOPY igf_se_payment_int.error_code%TYPE

1215:
1216: PROCEDURE payroll_adjust(
1217: p_payment_rec IN igf_se_payment%ROWTYPE,
1218: p_status OUT NOCOPY igf_se_payment_int.status%TYPE,
1219: p_error_cd OUT NOCOPY igf_se_payment_int.error_code%TYPE
1220: )IS
1221: ------------------------------------------------------------------------------------
1222: -- Created by : ssawhney ( Oracle IDC)
1223: -- Date created: 2nd jan

Line 1225: -- This will be used at the time of moving record from IGF_SE_PAYMENT_INT to IGF_SE_PAYMENT

1221: ------------------------------------------------------------------------------------
1222: -- Created by : ssawhney ( Oracle IDC)
1223: -- Date created: 2nd jan
1224: -- Purpose: This procedure will be used to adjust the payroll amount into IGF_AW_AWD_DISB
1225: -- This will be used at the time of moving record from IGF_SE_PAYMENT_INT to IGF_SE_PAYMENT
1226: -- Hence it will be present in the TBH of IGF_SE_PAYMENT
1227: -- Known limitations/enhancements and/or remarks:
1228: -- Change History:
1229: -- Who When What

Line 1226: -- Hence it will be present in the TBH of IGF_SE_PAYMENT

1222: -- Created by : ssawhney ( Oracle IDC)
1223: -- Date created: 2nd jan
1224: -- Purpose: This procedure will be used to adjust the payroll amount into IGF_AW_AWD_DISB
1225: -- This will be used at the time of moving record from IGF_SE_PAYMENT_INT to IGF_SE_PAYMENT
1226: -- Hence it will be present in the TBH of IGF_SE_PAYMENT
1227: -- Known limitations/enhancements and/or remarks:
1228: -- Change History:
1229: -- Who When What
1230: --veramach July 2004 bug 3709292 FA 151 HR integration changes

Line 1235: l_payroll_date igf_se_payment_int.payroll_date%TYPE;

1231: -- brajendr 18-Jul-2002 Bug # 2450456
1232: -- Added a check for negative adjustments
1233: -------------------------------------------------------------------------------------
1234: l_auth_id igf_se_auth.auth_id%TYPE;
1235: l_payroll_date igf_se_payment_int.payroll_date%TYPE;
1236: l_paid_amount igf_se_payment_int.paid_amount%TYPE;
1237: l_status igf_se_payment_int.status%TYPE;
1238: l_error_cd igf_se_payment_int.error_code%TYPE;
1239: l_disb_amount igf_aw_awd_disb.disb_accepted_amt%TYPE DEFAULT 0;

Line 1236: l_paid_amount igf_se_payment_int.paid_amount%TYPE;

1232: -- Added a check for negative adjustments
1233: -------------------------------------------------------------------------------------
1234: l_auth_id igf_se_auth.auth_id%TYPE;
1235: l_payroll_date igf_se_payment_int.payroll_date%TYPE;
1236: l_paid_amount igf_se_payment_int.paid_amount%TYPE;
1237: l_status igf_se_payment_int.status%TYPE;
1238: l_error_cd igf_se_payment_int.error_code%TYPE;
1239: l_disb_amount igf_aw_awd_disb.disb_accepted_amt%TYPE DEFAULT 0;
1240: l_sys_awd_status igf_ap_batch_aw_map.award_year_status_code%TYPE;

Line 1237: l_status igf_se_payment_int.status%TYPE;

1233: -------------------------------------------------------------------------------------
1234: l_auth_id igf_se_auth.auth_id%TYPE;
1235: l_payroll_date igf_se_payment_int.payroll_date%TYPE;
1236: l_paid_amount igf_se_payment_int.paid_amount%TYPE;
1237: l_status igf_se_payment_int.status%TYPE;
1238: l_error_cd igf_se_payment_int.error_code%TYPE;
1239: l_disb_amount igf_aw_awd_disb.disb_accepted_amt%TYPE DEFAULT 0;
1240: l_sys_awd_status igf_ap_batch_aw_map.award_year_status_code%TYPE;
1241:

Line 1238: l_error_cd igf_se_payment_int.error_code%TYPE;

1234: l_auth_id igf_se_auth.auth_id%TYPE;
1235: l_payroll_date igf_se_payment_int.payroll_date%TYPE;
1236: l_paid_amount igf_se_payment_int.paid_amount%TYPE;
1237: l_status igf_se_payment_int.status%TYPE;
1238: l_error_cd igf_se_payment_int.error_code%TYPE;
1239: l_disb_amount igf_aw_awd_disb.disb_accepted_amt%TYPE DEFAULT 0;
1240: l_sys_awd_status igf_ap_batch_aw_map.award_year_status_code%TYPE;
1241:
1242: CURSOR c_auth (cv_auth_id igf_se_auth.auth_id%TYPE) IS

Line 1278: FROM igf_se_payment

1274: AND auth.award_id = awd.award_id;
1275:
1276: CURSOR c_payment_total(cv_auth_id igf_se_auth.auth_id%TYPE) IS
1277: SELECT SUM( NVL(paid_amount, 0))
1278: FROM igf_se_payment
1279: WHERE auth_id = cv_auth_id;
1280:
1281: sum_rec c_sum%ROWTYPE;
1282: l_award c_award%ROWTYPE;

Line 1286: ln_total_paid_amount igf_se_payment.paid_amount%TYPE;

1282: l_award c_award%ROWTYPE;
1283: auth_rec c_auth%ROWTYPE;
1284: l_fund_id igf_aw_fund_mast.fund_id%TYPE;
1285: l_person_id igs_pe_person.person_id%TYPE;
1286: ln_total_paid_amount igf_se_payment.paid_amount%TYPE;
1287: l_notification_date igf_se_auth.notification_date%TYPE;
1288:
1289: -----------local function begin
1290: FUNCTION validate_threshold(