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_PAYMENT_PKG dependencies on IGF_SE_PAYMENT_INT

Line 464: FROM igf_se_payment_int spi

460: WHERE transaction_id = x_transaction_id;
461:
462: CURSOR c_payment_int IS
463: SELECT rowid , spi.*
464: FROM igf_se_payment_int spi
465: WHERE spi.auth_id =x_auth_id AND
466: spi.payroll_id =x_payroll_id AND
467: spi.status NOT IN ('DONE','ERROR');
468:

Line 470: c_error_cd igf_se_payment_int.error_code%TYPE

466: spi.payroll_id =x_payroll_id AND
467: spi.status NOT IN ('DONE','ERROR');
468:
469: CURSOR c_get_se_errors(
470: c_error_cd igf_se_payment_int.error_code%TYPE
471: ) IS
472: SELECT meaning
473: FROM igf_lookups_view
474: WHERE lookup_type = 'IGF_STUD_EMP_ERROR'

Line 487: l_status igf_se_payment_int.status%TYPE;

483: x_request_id NUMBER;
484: x_program_id NUMBER;
485: x_program_application_id NUMBER;
486: x_program_update_date DATE;
487: l_status igf_se_payment_int.status%TYPE;
488: l_error igf_se_payment_int.error_code%TYPE;
489: l_error_meaming igf_lookups_view.meaning%TYPE;
490: my_exception EXCEPTION;
491:

Line 488: l_error igf_se_payment_int.error_code%TYPE;

484: x_program_id NUMBER;
485: x_program_application_id NUMBER;
486: x_program_update_date DATE;
487: l_status igf_se_payment_int.status%TYPE;
488: l_error igf_se_payment_int.error_code%TYPE;
489: l_error_meaming igf_lookups_view.meaning%TYPE;
490: my_exception EXCEPTION;
491:
492: BEGIN

Line 617: -- this means that the record is coming from IGF_SE_PAYMENT_INT table

613: IF l_status ='DONE' THEN -- that is its a success
614:
615: IF new_references.payroll_id IS NOT NULL THEN
616:
617: -- this means that the record is coming from IGF_SE_PAYMENT_INT table
618: -- update payment int table with the error code
619: OPEN c_payment_int;
620: FETCH c_payment_int INTO payment_int_rec;
621: IF c_payment_int%FOUND THEN

Line 625: igf_se_payment_int_pkg.update_row (

621: IF c_payment_int%FOUND THEN
622: CLOSE c_payment_int;
623:
624: BEGIN
625: igf_se_payment_int_pkg.update_row (
626: x_rowid => payment_int_rec.rowid,
627: x_transaction_id => payment_int_rec.transaction_id,
628: x_batch_id => payment_int_rec.batch_id,
629: x_payroll_id => payment_int_rec.payroll_id,

Line 663: -- this means that the record is coming from IGF_SE_PAYMENT_INT table

659:
660: WHEN my_exception THEN
661: IF new_references.payroll_id IS NOT NULL THEN
662:
663: -- this means that the record is coming from IGF_SE_PAYMENT_INT table
664: -- update payment int table with the error code
665: OPEN c_payment_int;
666: FETCH c_payment_int INTO payment_int_rec;
667: IF c_payment_int%FOUND THEN

Line 676: igf_se_payment_int_pkg.update_row (

672:
673: ROLLBACK TO se_payment;
674:
675: BEGIN
676: igf_se_payment_int_pkg.update_row (
677: x_rowid => payment_int_rec.rowid,
678: x_transaction_id => payment_int_rec.transaction_id,
679: x_batch_id => payment_int_rec.batch_id,
680: x_payroll_id => payment_int_rec.payroll_id,

Line 820: c_error_cd igf_se_payment_int.error_code%TYPE

816: || (reverse chronological order - newest change first)
817: */
818:
819: CURSOR c_get_se_errors(
820: c_error_cd igf_se_payment_int.error_code%TYPE
821: ) IS
822: SELECT meaning
823: FROM igf_lookups_view
824: WHERE lookup_type = 'IGF_STUD_EMP_ERROR'

Line 834: l_status igf_se_payment_int.status%TYPE;

830: x_request_id NUMBER;
831: x_program_id NUMBER;
832: x_program_application_id NUMBER;
833: x_program_update_date DATE;
834: l_status igf_se_payment_int.status%TYPE;
835: l_error igf_se_payment_int.error_code%TYPE;
836: l_error_meaming igf_lookups_view.meaning%TYPE;
837: my_exception EXCEPTION;
838:

Line 835: l_error igf_se_payment_int.error_code%TYPE;

831: x_program_id NUMBER;
832: x_program_application_id NUMBER;
833: x_program_update_date DATE;
834: l_status igf_se_payment_int.status%TYPE;
835: l_error igf_se_payment_int.error_code%TYPE;
836: l_error_meaming igf_lookups_view.meaning%TYPE;
837: my_exception EXCEPTION;
838:
839: CURSOR c_payment_int IS

Line 841: FROM igf_se_payment_int spi

837: my_exception EXCEPTION;
838:
839: CURSOR c_payment_int IS
840: SELECT rowid , spi.*
841: FROM igf_se_payment_int spi
842: WHERE spi.auth_id =x_auth_id AND
843: spi.payroll_id =x_payroll_id AND
844: spi.status NOT IN ('DONE','ERROR');
845:

Line 942: -- this means that the record is coming from IGF_SE_PAYMENT_INT table

938: IF l_status ='DONE' THEN -- that is its a success
939:
940: IF new_references.payroll_id IS NOT NULL THEN
941:
942: -- this means that the record is coming from IGF_SE_PAYMENT_INT table
943: -- update payment int table with the error code
944: OPEN c_payment_int;
945: FETCH c_payment_int INTO payment_int_rec;
946: IF c_payment_int%FOUND THEN

Line 950: igf_se_payment_int_pkg.update_row(

946: IF c_payment_int%FOUND THEN
947: CLOSE c_payment_int;
948:
949: BEGIN
950: igf_se_payment_int_pkg.update_row(
951: x_rowid => payment_int_rec.rowid,
952: x_transaction_id => payment_int_rec.transaction_id,
953: x_batch_id => payment_int_rec.batch_id,
954: x_payroll_id => payment_int_rec.payroll_id,

Line 986: -- this means that the record is coming from IGF_SE_PAYMENT_INT table

982:
983: WHEN my_exception THEN
984: IF new_references.payroll_id IS NOT NULL THEN
985:
986: -- this means that the record is coming from IGF_SE_PAYMENT_INT table
987: -- update payment int table with the error code
988: OPEN c_payment_int;
989: FETCH c_payment_int INTO payment_int_rec;
990: IF c_payment_int%FOUND THEN

Line 999: igf_se_payment_int_pkg.update_row(

995:
996: ROLLBACK TO se_payment_upd;
997:
998: BEGIN
999: igf_se_payment_int_pkg.update_row(
1000: x_rowid => payment_int_rec.rowid,
1001: x_transaction_id => payment_int_rec.transaction_id,
1002: x_batch_id => payment_int_rec.batch_id,
1003: x_payroll_id => payment_int_rec.payroll_id,