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.IGR_I_APPL_PKG dependencies on IGR_I_APPL_ALL

Line 5: old_references IGR_I_APPL_ALL%RowType;

1: package body IGR_I_APPL_PKG as
2: /* $Header: IGSRH16B.pls 120.0 2005/06/01 21:08:31 appldev noship $ */
3:
4: l_rowid VARCHAR2(25);
5: old_references IGR_I_APPL_ALL%RowType;
6: new_references IGR_I_APPL_ALL%RowType;
7: PROCEDURE Set_Column_Values (
8: p_action IN VARCHAR2,
9: x_rowid IN VARCHAR2 DEFAULT NULL,

Line 6: new_references IGR_I_APPL_ALL%RowType;

2: /* $Header: IGSRH16B.pls 120.0 2005/06/01 21:08:31 appldev noship $ */
3:
4: l_rowid VARCHAR2(25);
5: old_references IGR_I_APPL_ALL%RowType;
6: new_references IGR_I_APPL_ALL%RowType;
7: PROCEDURE Set_Column_Values (
8: p_action IN VARCHAR2,
9: x_rowid IN VARCHAR2 DEFAULT NULL,
10: x_person_id IN NUMBER DEFAULT NULL,

Line 59: FROM IGR_I_APPL_ALL

55: x_pkg_reduct_ind IN VARCHAR2 DEFAULT NULL
56: ) as
57: CURSOR cur_old_ref_values IS
58: SELECT *
59: FROM IGR_I_APPL_ALL
60: WHERE rowid = x_rowid;
61: BEGIN
62: l_rowid := x_rowid;
63: -- Code for setting the Old and New Reference Values.

Line 131: -- ON IGR_I_APPL_ALL

127: END Set_Column_Values;
128: -- Trigger description :-
129: -- "OSS_TST".trg_eap_br_iu
130: -- BEFORE INSERT OR UPDATE
131: -- ON IGR_I_APPL_ALL
132: -- FOR EACH ROW
133: PROCEDURE BeforeRowInsertUpdate1(
134: p_inserting IN BOOLEAN DEFAULT FALSE,
135: p_updating IN BOOLEAN DEFAULT FALSE,

Line 396: FROM IGR_I_APPL_ALL

392: x_enquiry_appl_number IN NUMBER
393: ) RETURN BOOLEAN AS
394: CURSOR cur_rowid IS
395: SELECT rowid
396: FROM IGR_I_APPL_ALL
397: WHERE person_id = x_person_id
398: AND enquiry_appl_number = x_enquiry_appl_number
399: FOR UPDATE NOWAIT;
400: lv_rowid cur_rowid%RowType;

Line 418: FROM IGR_I_APPL_ALL

414: x_person_id IN NUMBER
415: ) as
416: CURSOR cur_rowid IS
417: SELECT rowid
418: FROM IGR_I_APPL_ALL
419: WHERE person_id = x_person_id OR
420: registering_person_id = x_person_id ;
421: lv_rowid cur_rowid%RowType;
422: BEGIN

Line 442: FROM IGR_I_APPL_ALL

438: x_sup_ci_sequence_number IN NUMBER
439: ) as
440: CURSOR cur_rowid IS
441: SELECT rowid
442: FROM IGR_I_APPL_ALL
443: WHERE adm_cal_type = x_sub_cal_type
444: AND adm_ci_sequence_number = x_sub_ci_sequence_number
445: AND acad_cal_type = x_sup_cal_type
446: AND acad_ci_sequence_number = x_sup_ci_sequence_number;

Line 470: FROM IGR_I_APPL_ALL

466: x_inq_entry_level_id IN NUMBER
467: ) as
468: CURSOR cur_rowid IS
469: SELECT rowid
470: FROM IGR_I_APPL_ALL
471: WHERE inq_entry_level_id = x_inq_entry_level_id ;
472: lv_rowid cur_rowid%RowType;
473: BEGIN
474: Open cur_rowid;

Line 491: FROM IGR_I_APPL_ALL

487: x_code_id IN NUMBER
488: ) as
489: CURSOR cur_rowid IS
490: SELECT rowid
491: FROM IGR_I_APPL_ALL
492: WHERE edu_goal_id = x_code_id
493: AND how_knowus_id = x_code_id
494: AND who_influenced_id = x_code_id;
495: lv_rowid cur_rowid%RowType;

Line 695: cursor C is select ROWID from IGR_I_APPL_ALL

691: X_MODE in VARCHAR2 default 'R',
692: X_ORG_ID in NUMBER,
693: X_PKG_REDUCT_IND IN VARCHAR2 DEFAULT NULL
694: ) as
695: cursor C is select ROWID from IGR_I_APPL_ALL
696: where PERSON_ID = X_PERSON_ID
697: and ENQUIRY_APPL_NUMBER = X_ENQUIRY_APPL_NUMBER;
698: X_LAST_UPDATE_DATE DATE;
699: X_LAST_UPDATED_BY NUMBER;

Line 786: insert into IGR_I_APPL_ALL (

782: x_last_updated_by=>X_LAST_UPDATED_BY,
783: x_last_update_login=>X_LAST_UPDATE_LOGIN,
784: x_pkg_reduct_ind => X_PKG_REDUCT_IND
785: );
786: insert into IGR_I_APPL_ALL (
787: PERSON_ID,
788: ENQUIRY_APPL_NUMBER,
789: SALES_LEAD_ID,
790: ACAD_CAL_TYPE,

Line 978: from IGR_I_APPL_ALL

974: ATTRIBUTE18,
975: ATTRIBUTE19,
976: ATTRIBUTE20,
977: PKG_REDUCT_IND
978: from IGR_I_APPL_ALL
979: where ROWID = X_ROWID
980: for update nowait;
981: tlinfo c1%rowtype;
982: begin

Line 1175: update IGR_I_APPL_ALL set

1171: else
1172: X_PROGRAM_UPDATE_DATE := SYSDATE;
1173: end if;
1174: end if;
1175: update IGR_I_APPL_ALL set
1176: ACAD_CAL_TYPE = NEW_REFERENCES.ACAD_CAL_TYPE,
1177: ACAD_CI_SEQUENCE_NUMBER = NEW_REFERENCES.ACAD_CI_SEQUENCE_NUMBER,
1178: ADM_CAL_TYPE = NEW_REFERENCES.ADM_CAL_TYPE,
1179: ADM_CI_SEQUENCE_NUMBER = NEW_REFERENCES.ADM_CI_SEQUENCE_NUMBER,

Line 1271: cursor c1 is select rowid from IGR_I_APPL_ALL

1267: X_MODE in VARCHAR2 default 'R',
1268: X_ORG_ID in NUMBER,
1269: X_PKG_REDUCT_IND IN VARCHAR2 DEFAULT NULL
1270: ) as
1271: cursor c1 is select rowid from IGR_I_APPL_ALL
1272: where PERSON_ID = X_PERSON_ID
1273: and ENQUIRY_APPL_NUMBER = X_ENQUIRY_APPL_NUMBER ;
1274: l_sales_lead_id IGR_I_APPL_ALL.sales_lead_id%TYPE;
1275: begin

Line 1274: l_sales_lead_id IGR_I_APPL_ALL.sales_lead_id%TYPE;

1270: ) as
1271: cursor c1 is select rowid from IGR_I_APPL_ALL
1272: where PERSON_ID = X_PERSON_ID
1273: and ENQUIRY_APPL_NUMBER = X_ENQUIRY_APPL_NUMBER ;
1274: l_sales_lead_id IGR_I_APPL_ALL.sales_lead_id%TYPE;
1275: begin
1276: open c1;
1277: fetch c1 into X_ROWID;
1278: if (c1%notfound) then

Line 1379: delete from IGR_I_APPL_ALL

1375: Before_DML(
1376: p_action => 'DELETE',
1377: x_rowid => X_ROWID
1378: );
1379: delete from IGR_I_APPL_ALL
1380: where ROWID = X_ROWID;
1381: if (sql%notfound) then
1382: raise no_data_found;
1383: end if;