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_SBMAO_FN_AMTT_PKG dependencies on IGS_AD_SBMAO_FN_AMTT

Line 1: package body IGS_AD_SBMAO_FN_AMTT_PKG as

1: package body IGS_AD_SBMAO_FN_AMTT_PKG as
2: /* $Header: IGSAI65B.pls 115.7 2003/10/30 13:21:47 rghosh ship $ */
3: l_rowid VARCHAR2(25);
4: old_references IGS_AD_SBMAO_FN_AMTT%RowType;
5: new_references IGS_AD_SBMAO_FN_AMTT%RowType;

Line 4: old_references IGS_AD_SBMAO_FN_AMTT%RowType;

1: package body IGS_AD_SBMAO_FN_AMTT_PKG as
2: /* $Header: IGSAI65B.pls 115.7 2003/10/30 13:21:47 rghosh ship $ */
3: l_rowid VARCHAR2(25);
4: old_references IGS_AD_SBMAO_FN_AMTT%RowType;
5: new_references IGS_AD_SBMAO_FN_AMTT%RowType;
6:
7: PROCEDURE Set_Column_Values (
8: p_action IN VARCHAR2,

Line 5: new_references IGS_AD_SBMAO_FN_AMTT%RowType;

1: package body IGS_AD_SBMAO_FN_AMTT_PKG as
2: /* $Header: IGSAI65B.pls 115.7 2003/10/30 13:21:47 rghosh ship $ */
3: l_rowid VARCHAR2(25);
4: old_references IGS_AD_SBMAO_FN_AMTT%RowType;
5: new_references IGS_AD_SBMAO_FN_AMTT%RowType;
6:
7: PROCEDURE Set_Column_Values (
8: p_action IN VARCHAR2,
9: x_rowid IN VARCHAR2 DEFAULT NULL,

Line 31: FROM IGS_AD_SBMAO_FN_AMTT

27: ) AS
28:
29: CURSOR cur_old_ref_values IS
30: SELECT *
31: FROM IGS_AD_SBMAO_FN_AMTT
32: WHERE rowid = x_rowid;
33:
34: BEGIN
35:

Line 80: -- ON IGS_AD_SBMAO_FN_AMTT

76:
77: -- Trigger description :-
78: -- "OSS_TST".trg_safat_br_iu
79: -- BEFORE INSERT OR UPDATE
80: -- ON IGS_AD_SBMAO_FN_AMTT
81: -- FOR EACH ROW
82:
83: PROCEDURE BeforeRowInsertUpdate1(
84: p_inserting IN BOOLEAN DEFAULT FALSE,

Line 296: FROM IGS_AD_SBMAO_FN_AMTT

292: ) RETURN BOOLEAN AS
293:
294: CURSOR cur_rowid IS
295: SELECT rowid
296: FROM IGS_AD_SBMAO_FN_AMTT
297: WHERE submission_yr = x_submission_yr
298: AND submission_number = x_submission_number
299: AND org_unit_cd = x_org_unit_cd
300: AND TRUNC(ou_start_dt) = TRUNC(x_ou_start_dt)

Line 328: FROM IGS_AD_SBMAO_FN_AMTT

324: ) AS
325:
326: CURSOR cur_rowid IS
327: SELECT rowid
328: FROM IGS_AD_SBMAO_FN_AMTT
329: WHERE attendance_mode = x_attendance_mode ;
330:
331: lv_rowid cur_rowid%RowType;
332:

Line 354: FROM IGS_AD_SBMAO_FN_AMTT

350: ) AS
351:
352: CURSOR cur_rowid IS
353: SELECT rowid
354: FROM IGS_AD_SBMAO_FN_AMTT
355: WHERE funding_source = x_funding_source ;
356:
357: lv_rowid cur_rowid%RowType;
358:

Line 380: FROM IGS_AD_SBMAO_FN_AMTT

376: ) AS
377:
378: CURSOR cur_rowid IS
379: SELECT rowid
380: FROM IGS_AD_SBMAO_FN_AMTT
381: WHERE submission_yr = x_submission_yr
382: AND submission_number = x_submission_number ;
383:
384: lv_rowid cur_rowid%RowType;

Line 407: FROM IGS_AD_SBMAO_FN_AMTT

403: ) AS
404:
405: CURSOR cur_rowid IS
406: SELECT rowid
407: FROM IGS_AD_SBMAO_FN_AMTT
408: WHERE intake_target_type = x_intake_target_type ;
409:
410: lv_rowid cur_rowid%RowType;
411:

Line 434: FROM IGS_AD_SBMAO_FN_AMTT

430: ) AS
431:
432: CURSOR cur_rowid IS
433: SELECT rowid
434: FROM IGS_AD_SBMAO_FN_AMTT
435: WHERE org_unit_cd = x_org_unit_cd
436: AND TRUNC(ou_start_dt) = TRUNC(x_start_dt) ;
437:
438: lv_rowid cur_rowid%RowType;

Line 461: FROM IGS_AD_SBMAO_FN_AMTT

457: ) as
458:
459: CURSOR cur_rowid IS
460: SELECT rowid
461: FROM IGS_AD_SBMAO_FN_AMTT
462: WHERE override_s_amount_type = x_override_s_amount_type ;
463:
464: lv_rowid cur_rowid%RowType;
465:

Line 673: cursor C is select ROWID from IGS_AD_SBMAO_FN_AMTT

669: X_ACTUAL_ENROLMENT in NUMBER,
670: X_ACTUAL_ENR_EFFECTIVE_DT in DATE,
671: X_MODE in VARCHAR2 default 'R'
672: ) AS
673: cursor C is select ROWID from IGS_AD_SBMAO_FN_AMTT
674: where SUBMISSION_YR = X_SUBMISSION_YR
675: and SUBMISSION_NUMBER = X_SUBMISSION_NUMBER
676: and ORG_UNIT_CD = X_ORG_UNIT_CD
677: and FUNDING_SOURCE = X_FUNDING_SOURCE

Line 724: insert into IGS_AD_SBMAO_FN_AMTT (

720: x_last_updated_by =>X_LAST_UPDATED_BY,
721: x_last_update_login =>X_LAST_UPDATE_LOGIN
722: );
723:
724: insert into IGS_AD_SBMAO_FN_AMTT (
725: SUBMISSION_YR,
726: SUBMISSION_NUMBER,
727: ORG_UNIT_CD,
728: OU_START_DT,

Line 799: from IGS_AD_SBMAO_FN_AMTT

795: MAX_TARGET,
796: OVERRIDE_S_AMOUNT_TYPE,
797: ACTUAL_ENROLMENT,
798: ACTUAL_ENR_EFFECTIVE_DT
799: from IGS_AD_SBMAO_FN_AMTT
800: where ROWID = X_ROWID
801: for update nowait;
802: tlinfo c1%rowtype;
803:

Line 900: update IGS_AD_SBMAO_FN_AMTT set

896: x_last_updated_by =>X_LAST_UPDATED_BY,
897: x_last_update_login =>X_LAST_UPDATE_LOGIN
898: );
899:
900: update IGS_AD_SBMAO_FN_AMTT set
901: OU_START_DT = NEW_REFERENCES.OU_START_DT,
902: TARGET = NEW_REFERENCES.TARGET,
903: MAX_TARGET = NEW_REFERENCES.MAX_TARGET,
904: OVERRIDE_S_AMOUNT_TYPE = NEW_REFERENCES.OVERRIDE_S_AMOUNT_TYPE,

Line 945: cursor c1 is select rowid from IGS_AD_SBMAO_FN_AMTT

941: X_ACTUAL_ENROLMENT in NUMBER,
942: X_ACTUAL_ENR_EFFECTIVE_DT in DATE,
943: X_MODE in VARCHAR2 default 'R'
944: ) AS
945: cursor c1 is select rowid from IGS_AD_SBMAO_FN_AMTT
946: where SUBMISSION_YR = X_SUBMISSION_YR
947: and SUBMISSION_NUMBER = X_SUBMISSION_NUMBER
948: and ORG_UNIT_CD = X_ORG_UNIT_CD
949: and FUNDING_SOURCE = X_FUNDING_SOURCE

Line 1003: delete from IGS_AD_SBMAO_FN_AMTT

999: p_action =>'DELETE',
1000: x_rowid => X_ROWID
1001: );
1002:
1003: delete from IGS_AD_SBMAO_FN_AMTT
1004: where ROWID = X_ROWID;
1005: if (sql%notfound) then
1006: raise no_data_found;
1007: end if;

Line 1016: end IGS_AD_SBMAO_FN_AMTT_PKG;

1012: );
1013:
1014: end DELETE_ROW;
1015:
1016: end IGS_AD_SBMAO_FN_AMTT_PKG;