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_INTAK_TRG_TYP_PKG dependencies on IGS_AD_INTAK_TRG_TYP

Line 1: package body IGS_AD_INTAK_TRG_TYP_PKG as

1: package body IGS_AD_INTAK_TRG_TYP_PKG as
2: /* $Header: IGSAI48B.pls 115.5 2003/10/30 13:13:01 akadam ship $*/
3:
4: l_rowid VARCHAR2(25);
5: old_references IGS_AD_INTAK_TRG_TYP%RowType;

Line 5: old_references IGS_AD_INTAK_TRG_TYP%RowType;

1: package body IGS_AD_INTAK_TRG_TYP_PKG as
2: /* $Header: IGSAI48B.pls 115.5 2003/10/30 13:13:01 akadam ship $*/
3:
4: l_rowid VARCHAR2(25);
5: old_references IGS_AD_INTAK_TRG_TYP%RowType;
6: new_references IGS_AD_INTAK_TRG_TYP%RowType;
7:
8: PROCEDURE Set_Column_Values (
9: p_action IN VARCHAR2,

Line 6: new_references IGS_AD_INTAK_TRG_TYP%RowType;

2: /* $Header: IGSAI48B.pls 115.5 2003/10/30 13:13:01 akadam ship $*/
3:
4: l_rowid VARCHAR2(25);
5: old_references IGS_AD_INTAK_TRG_TYP%RowType;
6: new_references IGS_AD_INTAK_TRG_TYP%RowType;
7:
8: PROCEDURE Set_Column_Values (
9: p_action IN VARCHAR2,
10: x_rowid IN VARCHAR2 DEFAULT NULL,

Line 26: FROM IGS_AD_INTAK_TRG_TYP

22: ) as
23:
24: CURSOR cur_old_ref_values IS
25: SELECT *
26: FROM IGS_AD_INTAK_TRG_TYP
27: WHERE rowid = x_rowid;
28:
29: BEGIN
30:

Line 190: IGS_AD_SBMAO_FN_AMTT_PKG.GET_FK_IGS_AD_INTAK_TRG_TYP (

186:
187: PROCEDURE Check_Child_Existance as
188: BEGIN
189:
190: IGS_AD_SBMAO_FN_AMTT_PKG.GET_FK_IGS_AD_INTAK_TRG_TYP (
191: old_references.intake_target_type
192: );
193:
194: IGS_AD_SBMAO_FN_CTTT_PKG.GET_FK_IGS_AD_INTAK_TRG_TYP (

Line 194: IGS_AD_SBMAO_FN_CTTT_PKG.GET_FK_IGS_AD_INTAK_TRG_TYP (

190: IGS_AD_SBMAO_FN_AMTT_PKG.GET_FK_IGS_AD_INTAK_TRG_TYP (
191: old_references.intake_target_type
192: );
193:
194: IGS_AD_SBMAO_FN_CTTT_PKG.GET_FK_IGS_AD_INTAK_TRG_TYP (
195: old_references.intake_target_type
196: );
197:
198: IGS_AD_SBM_AOU_FNDTT_PKG.GET_FK_IGS_AD_INTAK_TRG_TYP (

Line 198: IGS_AD_SBM_AOU_FNDTT_PKG.GET_FK_IGS_AD_INTAK_TRG_TYP (

194: IGS_AD_SBMAO_FN_CTTT_PKG.GET_FK_IGS_AD_INTAK_TRG_TYP (
195: old_references.intake_target_type
196: );
197:
198: IGS_AD_SBM_AOU_FNDTT_PKG.GET_FK_IGS_AD_INTAK_TRG_TYP (
199: old_references.intake_target_type
200: );
201:
202: IGS_AD_SBMAO_FN_UITT_PKG.GET_FK_IGS_AD_INTAK_TRG_TYP (

Line 202: IGS_AD_SBMAO_FN_UITT_PKG.GET_FK_IGS_AD_INTAK_TRG_TYP (

198: IGS_AD_SBM_AOU_FNDTT_PKG.GET_FK_IGS_AD_INTAK_TRG_TYP (
199: old_references.intake_target_type
200: );
201:
202: IGS_AD_SBMAO_FN_UITT_PKG.GET_FK_IGS_AD_INTAK_TRG_TYP (
203: old_references.intake_target_type
204: );
205:
206: IGS_AD_SBMPS_FN_ITTT_PKG.GET_FK_IGS_AD_INTAK_TRG_TYP (

Line 206: IGS_AD_SBMPS_FN_ITTT_PKG.GET_FK_IGS_AD_INTAK_TRG_TYP (

202: IGS_AD_SBMAO_FN_UITT_PKG.GET_FK_IGS_AD_INTAK_TRG_TYP (
203: old_references.intake_target_type
204: );
205:
206: IGS_AD_SBMPS_FN_ITTT_PKG.GET_FK_IGS_AD_INTAK_TRG_TYP (
207: old_references.intake_target_type
208: );
209:
210: IGS_AD_SBMINTAK_TRGT_PKG.GET_FK_IGS_AD_INTAK_TRG_TYP (

Line 210: IGS_AD_SBMINTAK_TRGT_PKG.GET_FK_IGS_AD_INTAK_TRG_TYP (

206: IGS_AD_SBMPS_FN_ITTT_PKG.GET_FK_IGS_AD_INTAK_TRG_TYP (
207: old_references.intake_target_type
208: );
209:
210: IGS_AD_SBMINTAK_TRGT_PKG.GET_FK_IGS_AD_INTAK_TRG_TYP (
211: old_references.intake_target_type
212: );
213:
214: END Check_Child_Existance;

Line 223: FROM IGS_AD_INTAK_TRG_TYP

219: )return BOOLEAN as
220:
221: CURSOR cur_rowid IS
222: SELECT rowid
223: FROM IGS_AD_INTAK_TRG_TYP
224: WHERE intake_target_type = x_intake_target_type AND
225: closed_ind = NVL(x_closed_ind,closed_ind)
226: FOR UPDATE NOWAIT;
227:

Line 250: FROM IGS_AD_INTAK_TRG_TYP

246: ) as
247:
248: CURSOR cur_rowid IS
249: SELECT rowid
250: FROM IGS_AD_INTAK_TRG_TYP
251: WHERE s_intake_target_type = x_s_intake_target_type ;
252:
253: lv_rowid cur_rowid%RowType;
254:

Line 276: FROM IGS_AD_INTAK_TRG_TYP

272: ) as
273:
274: CURSOR cur_rowid IS
275: SELECT rowid
276: FROM IGS_AD_INTAK_TRG_TYP
277: WHERE s_amount_type = x_s_amount_type ;
278:
279: lv_rowid cur_rowid%RowType;
280:

Line 383: cursor C is select ROWID from IGS_AD_INTAK_TRG_TYP

379: X_CLOSED_IND in VARCHAR2,
380: X_COMMENTS in VARCHAR2,
381: X_MODE in VARCHAR2 default 'R'
382: ) as
383: cursor C is select ROWID from IGS_AD_INTAK_TRG_TYP
384: where INTAKE_TARGET_TYPE = X_INTAKE_TARGET_TYPE;
385: X_LAST_UPDATE_DATE DATE;
386: X_LAST_UPDATED_BY NUMBER;
387: X_LAST_UPDATE_LOGIN NUMBER;

Line 425: insert into IGS_AD_INTAK_TRG_TYP (

421: x_last_update_login=> X_LAST_UPDATE_LOGIN
422: );
423:
424:
425: insert into IGS_AD_INTAK_TRG_TYP (
426: INTAKE_TARGET_TYPE,
427: DESCRIPTION,
428: S_INTAKE_TARGET_TYPE,
429: S_AMOUNT_TYPE,

Line 481: from IGS_AD_INTAK_TRG_TYP

477: S_INTAKE_TARGET_TYPE,
478: S_AMOUNT_TYPE,
479: CLOSED_IND,
480: COMMENTS
481: from IGS_AD_INTAK_TRG_TYP
482: WHERE ROWID = X_ROWID for update nowait ;
483: tlinfo c1%rowtype;
484:
485: begin

Line 564: update IGS_AD_INTAK_TRG_TYP set

560: x_last_update_login=> X_LAST_UPDATE_LOGIN
561: );
562:
563:
564: update IGS_AD_INTAK_TRG_TYP set
565: DESCRIPTION = NEW_REFERENCES.DESCRIPTION,
566: S_INTAKE_TARGET_TYPE = NEW_REFERENCES.S_INTAKE_TARGET_TYPE,
567: S_AMOUNT_TYPE = NEW_REFERENCES.S_AMOUNT_TYPE,
568: CLOSED_IND = NEW_REFERENCES.CLOSED_IND,

Line 596: cursor c1 is select rowid from IGS_AD_INTAK_TRG_TYP

592: X_CLOSED_IND in VARCHAR2,
593: X_COMMENTS in VARCHAR2,
594: X_MODE in VARCHAR2 default 'R'
595: ) as
596: cursor c1 is select rowid from IGS_AD_INTAK_TRG_TYP
597: where INTAKE_TARGET_TYPE = X_INTAKE_TARGET_TYPE
598: ;
599:
600: begin

Line 638: delete from IGS_AD_INTAK_TRG_TYP

634: p_action=>'DELETE',
635: x_rowid=> X_ROWID
636: );
637:
638: delete from IGS_AD_INTAK_TRG_TYP
639: where ROWID = X_ROWID;
640: if (sql%notfound) then
641: raise no_data_found;
642: end if;

Line 653: end IGS_AD_INTAK_TRG_TYP_PKG;

649:
650:
651: end DELETE_ROW;
652:
653: end IGS_AD_INTAK_TRG_TYP_PKG;