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_AUTH

Line 174: p_auth_id IN igf_se_auth.auth_id%TYPE,

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: ------------------------------------------------------------------------------------
178: --Created by : brajendr

Line 337: SELECT igf_se_auth_s1.NEXTVAL

333: FROM igf_aw_award awd
334: WHERE awd.award_id = cp_award_id;
335:
336: CURSOR c_next_auth IS
337: SELECT igf_se_auth_s1.NEXTVAL
338: FROM dual;
339:
340: CURSOR c_auth_check(cv_award_id igf_aw_award.award_id%TYPE,
341: cv_ld_cal_type igs_ca_inst.cal_type%TYPE,

Line 345: FROM igf_se_auth

341: cv_ld_cal_type igs_ca_inst.cal_type%TYPE,
342: cv_ld_seq_no igs_ca_inst.sequence_number%TYPE
343: ) IS
344: SELECT auth_id
345: FROM igf_se_auth
346: WHERE award_id = cv_award_id
347: AND auth_id IS NOT NULL
348: AND flag = 'A';
349:

Line 351: CURSOR c_old_auth (cv_auth_id igf_se_auth.auth_id%TYPE) IS

347: AND auth_id IS NOT NULL
348: AND flag = 'A';
349:
350:
351: CURSOR c_old_auth (cv_auth_id igf_se_auth.auth_id%TYPE) IS
352: SELECT rowid, sai.*
353: FROM igf_se_auth sai
354: WHERE sai.auth_id = cv_auth_id
355: AND sai.flag ='A'

Line 353: FROM igf_se_auth sai

349:
350:
351: CURSOR c_old_auth (cv_auth_id igf_se_auth.auth_id%TYPE) IS
352: SELECT rowid, sai.*
353: FROM igf_se_auth sai
354: WHERE sai.auth_id = cv_auth_id
355: AND sai.flag ='A'
356: FOR UPDATE NOWAIT;
357:

Line 377: l_auth_id igf_se_auth.auth_id%TYPE := 0;

373: l_person_id hz_parties.party_id%TYPE;
374: l_fund_id igf_aw_fund_mast.fund_id%TYPE;
375: l_ld_cal_type igs_ca_inst.cal_type%TYPE;
376: l_ld_seq_no igs_ca_inst.sequence_number%TYPE;
377: l_auth_id igf_se_auth.auth_id%TYPE := 0;
378: l_sequence_no igf_se_auth.sequence_no%TYPE := 0;
379: l_rowid VARCHAR2(30) := 0;
380: l_visa_type igf_se_auth.visa_type%TYPE;
381: l_visa_category igf_se_auth.visa_category%TYPE;

Line 378: l_sequence_no igf_se_auth.sequence_no%TYPE := 0;

374: l_fund_id igf_aw_fund_mast.fund_id%TYPE;
375: l_ld_cal_type igs_ca_inst.cal_type%TYPE;
376: l_ld_seq_no igs_ca_inst.sequence_number%TYPE;
377: l_auth_id igf_se_auth.auth_id%TYPE := 0;
378: l_sequence_no igf_se_auth.sequence_no%TYPE := 0;
379: l_rowid VARCHAR2(30) := 0;
380: l_visa_type igf_se_auth.visa_type%TYPE;
381: l_visa_category igf_se_auth.visa_category%TYPE;
382: l_visa_number igf_se_auth.visa_number%TYPE;

Line 380: l_visa_type igf_se_auth.visa_type%TYPE;

376: l_ld_seq_no igs_ca_inst.sequence_number%TYPE;
377: l_auth_id igf_se_auth.auth_id%TYPE := 0;
378: l_sequence_no igf_se_auth.sequence_no%TYPE := 0;
379: l_rowid VARCHAR2(30) := 0;
380: l_visa_type igf_se_auth.visa_type%TYPE;
381: l_visa_category igf_se_auth.visa_category%TYPE;
382: l_visa_number igf_se_auth.visa_number%TYPE;
383: l_visa_expiry_dt igf_se_auth.visa_expiry_dt%TYPE;
384: l_entry_date igf_se_auth.entry_date%TYPE;

Line 381: l_visa_category igf_se_auth.visa_category%TYPE;

377: l_auth_id igf_se_auth.auth_id%TYPE := 0;
378: l_sequence_no igf_se_auth.sequence_no%TYPE := 0;
379: l_rowid VARCHAR2(30) := 0;
380: l_visa_type igf_se_auth.visa_type%TYPE;
381: l_visa_category igf_se_auth.visa_category%TYPE;
382: l_visa_number igf_se_auth.visa_number%TYPE;
383: l_visa_expiry_dt igf_se_auth.visa_expiry_dt%TYPE;
384: l_entry_date igf_se_auth.entry_date%TYPE;
385: l_warning VARCHAR2(200);

Line 382: l_visa_number igf_se_auth.visa_number%TYPE;

378: l_sequence_no igf_se_auth.sequence_no%TYPE := 0;
379: l_rowid VARCHAR2(30) := 0;
380: l_visa_type igf_se_auth.visa_type%TYPE;
381: l_visa_category igf_se_auth.visa_category%TYPE;
382: l_visa_number igf_se_auth.visa_number%TYPE;
383: l_visa_expiry_dt igf_se_auth.visa_expiry_dt%TYPE;
384: l_entry_date igf_se_auth.entry_date%TYPE;
385: l_warning VARCHAR2(200);
386:

Line 383: l_visa_expiry_dt igf_se_auth.visa_expiry_dt%TYPE;

379: l_rowid VARCHAR2(30) := 0;
380: l_visa_type igf_se_auth.visa_type%TYPE;
381: l_visa_category igf_se_auth.visa_category%TYPE;
382: l_visa_number igf_se_auth.visa_number%TYPE;
383: l_visa_expiry_dt igf_se_auth.visa_expiry_dt%TYPE;
384: l_entry_date igf_se_auth.entry_date%TYPE;
385: l_warning VARCHAR2(200);
386:
387: PROCEDURE insert_auth IS

Line 384: l_entry_date igf_se_auth.entry_date%TYPE;

380: l_visa_type igf_se_auth.visa_type%TYPE;
381: l_visa_category igf_se_auth.visa_category%TYPE;
382: l_visa_number igf_se_auth.visa_number%TYPE;
383: l_visa_expiry_dt igf_se_auth.visa_expiry_dt%TYPE;
384: l_entry_date igf_se_auth.entry_date%TYPE;
385: l_warning VARCHAR2(200);
386:
387: PROCEDURE insert_auth IS
388: --------------------------------------------------------

Line 390: --Purpose : local procedure to insert into igf_se_auth table

386:
387: PROCEDURE insert_auth IS
388: --------------------------------------------------------
389: --Created by : ssawhney on 2nd Jan
390: --Purpose : local procedure to insert into igf_se_auth table
391: --Change History :
392: --Who When What
393: ----------------------------------------------------------------
394: l_rowid VARCHAR2(30);

Line 395: l_sequence_no igf_se_auth.sequence_no%TYPE;

391: --Change History :
392: --Who When What
393: ----------------------------------------------------------------
394: l_rowid VARCHAR2(30);
395: l_sequence_no igf_se_auth.sequence_no%TYPE;
396: BEGIN
397: -- insert a new auth rec
398:
399: l_rowid := NULL;

Line 436: igf_se_auth_pkg.insert_row(

432: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_se_gen_001.send_work_auth.insert_auth','x_award_id =>' || awd_rec.award_id);
433: END IF;
434:
435:
436: igf_se_auth_pkg.insert_row(
437: x_rowid => l_rowid,
438: x_sequence_no => l_sequence_no,
439: x_auth_id => l_auth_id,
440: x_flag => 'A', -- this is the active record now.

Line 480: FND_MESSAGE.SET_TOKEN('NAME','igf_se_gen_001.send_work_auth:igf_se_auth.insert') ;

476: fnd_log.string(fnd_log.level_exception,'igf.plsql.igf_se_gen_001.send_work_auth.insert_auth',' Unhandled Exception ->' || SQLERRM);
477: END IF;
478:
479: FND_MESSAGE.SET_NAME('IGF','IGF_GE_UNHANDLED_EXP');
480: FND_MESSAGE.SET_TOKEN('NAME','igf_se_gen_001.send_work_auth:igf_se_auth.insert') ;
481: IGS_GE_MSG_STACK.ADD;
482:
483: IF p_call = 'JOB' THEN -- continue for next student dont stop
484: RAISE NEXT_RECORD; -- user defined exception

Line 653: igf_se_auth_pkg.update_row (

649: CLOSE c_old_auth;
650:
651: BEGIN
652:
653: igf_se_auth_pkg.update_row (
654: old_auth_rec.rowid,
655: old_auth_rec.sequence_no,
656: old_auth_rec.auth_id,
657: 'I', -- this record is inactive now

Line 691: -- insert a new auth rec with the updated information in the igf_se_auth table.

687: old_auth_rec.authorization_date,
688: old_auth_rec.notification_date
689: );
690:
691: -- insert a new auth rec with the updated information in the igf_se_auth table.
692: -- this will be the active record now.
693: insert_auth;
694:
695: EXCEPTION

Line 702: FND_MESSAGE.SET_TOKEN('NAME','igf_se_gen_001.send_work_auth:igf_se_auth.update');

698: CLOSE c_auth_check;
699: END IF;
700:
701: FND_MESSAGE.SET_NAME('IGF','IGF_GE_UNHANDLED_EXP');
702: FND_MESSAGE.SET_TOKEN('NAME','igf_se_gen_001.send_work_auth:igf_se_auth.update');
703: IGS_GE_MSG_STACK.ADD;
704:
705: IF p_call = 'JOB' THEN -- continue for next student dont stop
706: RAISE next_record; -- user defined exception

Line 849: FROM igf_se_auth

845: CURSOR c_auth_exists(
846: cp_award_id igf_aw_award_all.award_id%TYPE
847: ) IS
848: SELECT 'x'
849: FROM igf_se_auth
850: WHERE award_id = cp_award_id
851: AND flag = 'A';
852: l_auth_exists c_auth_exists%ROWTYPE;
853:

Line 861: igf_se_auth auth

857: ) IS
858: SELECT awd.accepted_amt accepted_amt,
859: auth.accepted_amnt accepted_amnt
860: FROM igf_aw_award_all awd,
861: igf_se_auth auth
862: WHERE awd.award_id = auth.award_id
863: AND awd.award_id = cp_award_id
864: AND auth.flag = 'A';
865: l_amounts c_amounts%ROWTYPE;

Line 915: fnd_message.set_name('IGF','IGF_SE_AUTH_GENERATED');

911:
912: IF l_amounts.accepted_amt = l_amounts.accepted_amnt THEN
913: --no need to recreate authorization
914: --log a message
915: fnd_message.set_name('IGF','IGF_SE_AUTH_GENERATED');
916: fnd_file.put_line(fnd_file.log,fnd_message.get);
917: ELSE
918: igf_se_gen_001.send_work_auth(
919: auth_rec.base_id,

Line 969: p_auth_id IN igf_se_auth.auth_id%TYPE,

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)
973: --Date created: 2nd jan

Line 986: cv_auth_id igf_se_auth.auth_id%TYPE) IS

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
990: AND sei.auth_id = NVL(cv_auth_id,sei.auth_id)

Line 995: CURSOR c_auth_count(cv_auth_id igf_se_auth.auth_id%TYPE,

991: AND sei.status IN ('NEW', 'UPLOAD')
992: ORDER BY auth_id, person_id
993: FOR UPDATE NOWAIT;
994:
995: CURSOR c_auth_count(cv_auth_id igf_se_auth.auth_id%TYPE,
996: cv_person_id hz_parties.party_id%TYPE) IS
997: SELECT COUNT(*) count
998: FROM igf_se_auth c,igf_aw_award a, igf_ap_fa_base_rec b
999: WHERE c.auth_id = cv_auth_id

Line 998: FROM igf_se_auth c,igf_aw_award a, igf_ap_fa_base_rec b

994:
995: CURSOR c_auth_count(cv_auth_id igf_se_auth.auth_id%TYPE,
996: cv_person_id hz_parties.party_id%TYPE) IS
997: SELECT COUNT(*) count
998: FROM igf_se_auth c,igf_aw_award a, igf_ap_fa_base_rec b
999: WHERE c.auth_id = cv_auth_id
1000: AND c.award_id = a.award_id
1001: AND a.base_id = b.base_id
1002: AND b.person_id = cv_person_id

Line 1234: l_auth_id igf_se_auth.auth_id%TYPE;

1230: --veramach July 2004 bug 3709292 FA 151 HR integration changes
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;

Line 1242: CURSOR c_auth (cv_auth_id igf_se_auth.auth_id%TYPE) IS

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
1243: SELECT rowid row_id,auth.*
1244: FROM igf_se_auth auth
1245: WHERE auth_id = cv_auth_id
1246: AND flag='A';

Line 1244: FROM igf_se_auth auth

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
1243: SELECT rowid row_id,auth.*
1244: FROM igf_se_auth auth
1245: WHERE auth_id = cv_auth_id
1246: AND flag='A';
1247:
1248: CURSOR c_award_det(cp_cal_type VARCHAR2,

Line 1256: cv_auth_id igf_se_auth.auth_id%TYPE

1252: WHERE ci_cal_type = cp_cal_type
1253: AND ci_sequence_number = cp_seq_number;
1254:
1255: CURSOR c_sum(
1256: cv_auth_id igf_se_auth.auth_id%TYPE
1257: ) IS
1258: SELECT NVL(accepted_amt,NVL(offered_amt,0)) accepted_amt,
1259: base_id
1260: FROM igf_aw_award_all awd,

Line 1261: igf_se_auth se

1257: ) IS
1258: SELECT NVL(accepted_amt,NVL(offered_amt,0)) accepted_amt,
1259: base_id
1260: FROM igf_aw_award_all awd,
1261: igf_se_auth se
1262: WHERE se.award_id = awd.award_id
1263: AND se.auth_id = cv_auth_id
1264: AND se.flag = 'A';
1265:

Line 1268: cp_auth_id igf_se_auth.auth_id%TYPE

1264: AND se.flag = 'A';
1265:
1266:
1267: CURSOR c_award(
1268: cp_auth_id igf_se_auth.auth_id%TYPE
1269: ) IS
1270: SELECT awd.*
1271: FROM igf_aw_award awd,
1272: igf_se_auth auth

Line 1272: igf_se_auth auth

1268: cp_auth_id igf_se_auth.auth_id%TYPE
1269: ) IS
1270: SELECT awd.*
1271: FROM igf_aw_award awd,
1272: igf_se_auth auth
1273: WHERE auth.auth_id = cp_auth_id
1274: AND auth.award_id = awd.award_id;
1275:
1276: CURSOR c_payment_total(cv_auth_id igf_se_auth.auth_id%TYPE) IS

Line 1276: CURSOR c_payment_total(cv_auth_id igf_se_auth.auth_id%TYPE) IS

1272: igf_se_auth auth
1273: WHERE auth.auth_id = cp_auth_id
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:

Line 1287: l_notification_date igf_se_auth.notification_date%TYPE;

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(
1291: p_fund_id IN igf_aw_fund_mast.fund_id%TYPE,

Line 1497: igf_se_auth_pkg.update_row(

1493: CLOSE c_award_det;
1494:
1495: IF l_sys_awd_status = 'O' THEN
1496: igf_se_gen_001.se_notify (l_person_id, l_fund_id,NULL,NULL,auth_rec.award_id);
1497: igf_se_auth_pkg.update_row(
1498: x_rowid => auth_rec.row_id,
1499: x_sequence_no => auth_rec.sequence_no,
1500: x_auth_id => auth_rec.auth_id,
1501: x_flag => auth_rec.flag,