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_AD_APPL_PKG dependencies on IGS_AD_APPL_ALL

Line 4: old_references IGS_AD_APPL_ALL%RowType;

1: PACKAGE BODY IGS_AD_APPL_PKG as
2: /* $Header: IGSAI04B.pls 120.6 2005/09/30 05:55:10 appldev ship $ */
3: l_rowid VARCHAR2(25);
4: old_references IGS_AD_APPL_ALL%RowType;
5: new_references IGS_AD_APPL_ALL%RowType;
6:
7: PROCEDURE Set_Column_Values (
8: p_action IN VARCHAR2,

Line 5: new_references IGS_AD_APPL_ALL%RowType;

1: PACKAGE BODY IGS_AD_APPL_PKG as
2: /* $Header: IGSAI04B.pls 120.6 2005/09/30 05:55:10 appldev ship $ */
3: l_rowid VARCHAR2(25);
4: old_references IGS_AD_APPL_ALL%RowType;
5: new_references IGS_AD_APPL_ALL%RowType;
6:
7: PROCEDURE Set_Column_Values (
8: p_action IN VARCHAR2,
9: x_rowid IN VARCHAR2,

Line 44: FROM IGS_AD_APPL_ALL

40: --smadathi 12-Feb-2002 Bug 2217104. Added columns choice_number,routeb_pref
41: -------------------------------------------------------------------
42: CURSOR cur_old_ref_values IS
43: SELECT *
44: FROM IGS_AD_APPL_ALL
45: WHERE rowid = x_rowid;
46:
47: BEGIN
48:

Line 655: FROM IGS_AD_APPL_ALL

651: RETURN BOOLEAN AS
652:
653: CURSOR cur_rowid IS
654: SELECT rowid
655: FROM IGS_AD_APPL_ALL
656: WHERE person_id = x_person_id
657: AND admission_appl_number = x_admission_appl_number
658: FOR UPDATE NOWAIT;
659:

Line 681: FROM igs_ad_appl_all

677: x_application_type IN VARCHAR2
678: ) AS
679: CURSOR cur_rowid IS
680: SELECT rowid
681: FROM igs_ad_appl_all
682: WHERE application_type = x_application_type;
683:
684: lv_rowid cur_rowid%RowType;
685: BEGIN

Line 708: FROM IGS_AD_APPL_ALL

704: ) AS
705:
706: CURSOR cur_rowid IS
707: SELECT rowid
708: FROM IGS_AD_APPL_ALL
709: WHERE adm_cal_type = x_sub_cal_type
710: AND adm_ci_sequence_number = x_sub_ci_sequence_number
711: AND acad_cal_type = x_sup_cal_type
712: AND acad_ci_sequence_number = x_sup_ci_sequence_number ;

Line 737: FROM IGS_AD_APPL_ALL

733: ) AS
734:
735: CURSOR cur_rowid IS
736: SELECT rowid
737: FROM IGS_AD_APPL_ALL
738: WHERE person_id = x_person_id ;
739:
740: lv_rowid cur_rowid%RowType;
741:

Line 763: FROM IGS_AD_APPL_ALL

759: ) AS
760:
761: CURSOR cur_rowid IS
762: SELECT rowid
763: FROM IGS_AD_APPL_ALL
764: WHERE adm_appl_status = x_adm_appl_status ;
765:
766: lv_rowid cur_rowid%RowType;
767:

Line 789: FROM IGS_AD_APPL_ALL

785: ) AS
786:
787: CURSOR cur_rowid IS
788: SELECT rowid
789: FROM IGS_AD_APPL_ALL
790: WHERE adm_fee_status = x_adm_fee_status ;
791:
792: lv_rowid cur_rowid%RowType;
793:

Line 818: FROM IGS_AD_APPL_ALL

814: ) AS
815:
816: CURSOR cur_rowid IS
817: SELECT rowid
818: FROM IGS_AD_APPL_ALL
819: WHERE adm_cal_type = x_adm_cal_type
820: AND adm_ci_sequence_number = x_adm_ci_sequence_number
821: AND admission_cat = x_admission_cat
822: AND s_admission_process_type = x_s_admission_process_type ;

Line 848: FROM IGS_AD_APPL_ALL

844: ) AS
845:
846: CURSOR cur_rowid IS
847: SELECT rowid
848: FROM IGS_AD_APPL_ALL
849: WHERE admission_cat = x_admission_cat
850: AND s_admission_process_type = x_s_admission_process_type ;
851:
852: lv_rowid cur_rowid%RowType;

Line 883: FROM igs_ad_appl_all

879: (reverse chronological order - newest change first)
880: ***************************************************************/
881: CURSOR cur_rowid1 IS
882: SELECT rowid
883: FROM igs_ad_appl_all
884: WHERE spcl_grp_1 = x_code_id
885: OR spcl_grp_2 = x_code_id;
886: lv_rowid cur_rowid1%RowType;
887: BEGIN

Line 1231: cursor C is select ROWID from IGS_AD_APPL_ALL

1227: --ravishar 25-May-2005 Security related changes(Bug- 4344197)
1228: --smvk 14-Feb-2002 Call to igs_ge_gen_003.get_org_id w.r.t SWCR006
1229: --smadathi 12-Feb-2002 Bug 2217104. Added columns choice_number,routeb_pref
1230: -------------------------------------------------------------------
1231: cursor C is select ROWID from IGS_AD_APPL_ALL
1232: where PERSON_ID = X_PERSON_ID
1233: and ADMISSION_APPL_NUMBER = X_ADMISSION_APPL_NUMBER;
1234: X_LAST_UPDATE_DATE DATE;
1235: X_LAST_UPDATED_BY NUMBER;

Line 1306: insert into IGS_AD_APPL_ALL (

1302:
1303: IF (x_mode = 'S') THEN
1304: igs_sc_gen_001.set_ctx('R');
1305: END IF;
1306: insert into IGS_AD_APPL_ALL (
1307: PERSON_ID,
1308: ORG_ID,
1309: ADMISSION_APPL_NUMBER,
1310: APPL_DT,

Line 1449: from IGS_AD_APPL_ALL

1445: choice_number,
1446: routeb_pref,
1447: alt_appl_id,
1448: appl_fee_amt
1449: from IGS_AD_APPL_ALL
1450: where ROWID = X_ROWID
1451: for update nowait;
1452: tlinfo c1%rowtype;
1453:

Line 1609: update IGS_AD_APPL_ALL set

1605: as they should not be allowed to update for an existing application. Bug: 2772337 */
1606: IF (x_mode = 'S') THEN
1607: igs_sc_gen_001.set_ctx('R');
1608: END IF;
1609: update IGS_AD_APPL_ALL set
1610: APPL_DT = NEW_REFERENCES.APPL_DT,
1611: ADM_APPL_STATUS = NEW_REFERENCES.ADM_APPL_STATUS,
1612: ADM_FEE_STATUS = NEW_REFERENCES.ADM_FEE_STATUS,
1613: TAC_APPL_IND = NEW_REFERENCES.TAC_APPL_IND,

Line 1692: cursor c1 is select rowid from IGS_AD_APPL_ALL

1688: x_routeb_pref IN VARCHAR2,
1689: x_alt_appl_id IN VARCHAR2,
1690: x_appl_fee_amt IN NUMBER DEFAULT NULL
1691: ) AS
1692: cursor c1 is select rowid from IGS_AD_APPL_ALL
1693: where PERSON_ID = X_PERSON_ID
1694: and ADMISSION_APPL_NUMBER = X_ADMISSION_APPL_NUMBER
1695: ;
1696: begin

Line 1768: delete from IGS_AD_APPL_ALL

1764:
1765: IF (x_mode = 'S') THEN
1766: igs_sc_gen_001.set_ctx('R');
1767: END IF;
1768: delete from IGS_AD_APPL_ALL
1769: where ROWID = X_ROWID;
1770: if (sql%notfound) then
1771: fnd_message.set_name ('IGS', 'IGS_SC_POLICY_UPD_DEL_EXCEP');
1772: igs_ge_msg_stack.add;