APPS.IGS_AD_SBMAO_FN_UITT_PKG dependencies on IGS_AD_SBMAO_FN_UITT

Line 1: package body IGS_AD_SBMAO_FN_UITT_PKG as

1: package body IGS_AD_SBMAO_FN_UITT_PKG as
2: /* $Header: IGSAI62B.pls 115.6 2003/10/30 13:21:20 rghosh ship $ */
3: l_rowid VARCHAR2(25);
4: old_references IGS_AD_SBMAO_FN_UITT%RowType;
5: new_references IGS_AD_SBMAO_FN_UITT%RowType;

Line 4: old_references IGS_AD_SBMAO_FN_UITT%RowType;

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

Line 5: new_references IGS_AD_SBMAO_FN_UITT%RowType;

1: package body IGS_AD_SBMAO_FN_UITT_PKG as
2: /* $Header: IGSAI62B.pls 115.6 2003/10/30 13:21:20 rghosh ship $ */
3: l_rowid VARCHAR2(25);
4: old_references IGS_AD_SBMAO_FN_UITT%RowType;
5: new_references IGS_AD_SBMAO_FN_UITT%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_UITT

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

Line 289: FROM IGS_AD_SBMAO_FN_UITT

285: ) RETURN BOOLEAN AS
286:
287: CURSOR cur_rowid IS
288: SELECT rowid
289: FROM IGS_AD_SBMAO_FN_UITT
290: WHERE submission_yr = x_submission_yr
291: AND submission_number = x_submission_number
292: AND org_unit_cd = x_org_unit_cd
293: AND TRUNC(ou_start_dt) = TRUNC(x_ou_start_dt)

Line 321: FROM IGS_AD_SBMAO_FN_UITT

317: ) AS
318:
319: CURSOR cur_rowid IS
320: SELECT rowid
321: FROM IGS_AD_SBMAO_FN_UITT
322: WHERE funding_source = x_funding_source ;
323:
324: lv_rowid cur_rowid%RowType;
325:

Line 348: FROM IGS_AD_SBMAO_FN_UITT

344: ) AS
345:
346: CURSOR cur_rowid IS
347: SELECT rowid
348: FROM IGS_AD_SBMAO_FN_UITT
349: WHERE submission_yr = x_submission_yr
350: AND submission_number = x_submission_number ;
351:
352: lv_rowid cur_rowid%RowType;

Line 375: FROM IGS_AD_SBMAO_FN_UITT

371: ) AS
372:
373: CURSOR cur_rowid IS
374: SELECT rowid
375: FROM IGS_AD_SBMAO_FN_UITT
376: WHERE intake_target_type = x_intake_target_type ;
377:
378: lv_rowid cur_rowid%RowType;
379:

Line 402: FROM IGS_AD_SBMAO_FN_UITT

398: ) AS
399:
400: CURSOR cur_rowid IS
401: SELECT rowid
402: FROM IGS_AD_SBMAO_FN_UITT
403: WHERE org_unit_cd = x_org_unit_cd
404: AND TRUNC(ou_start_dt) = TRUNC(x_start_dt) ;
405:
406: lv_rowid cur_rowid%RowType;

Line 429: FROM IGS_AD_SBMAO_FN_UITT

425: ) AS
426:
427: CURSOR cur_rowid IS
428: SELECT rowid
429: FROM IGS_AD_SBMAO_FN_UITT
430: WHERE unit_int_course_level_cd = x_unit_int_course_level_cd ;
431:
432: lv_rowid cur_rowid%RowType;
433:

Line 455: FROM IGS_AD_SBMAO_FN_UITT

451: ) as
452:
453: CURSOR cur_rowid IS
454: SELECT rowid
455: FROM IGS_AD_SBMAO_FN_UITT
456: WHERE override_s_amount_type = x_override_s_amount_type ;
457:
458: lv_rowid cur_rowid%RowType;
459:

Line 674: cursor C is select ROWID from IGS_AD_SBMAO_FN_UITT

670: X_ACTUAL_ENROLMENT in NUMBER,
671: X_ACTUAL_ENR_EFFECTIVE_DT in DATE,
672: X_MODE in VARCHAR2 default 'R'
673: ) as
674: cursor C is select ROWID from IGS_AD_SBMAO_FN_UITT
675: where SUBMISSION_YR = X_SUBMISSION_YR
676: and SUBMISSION_NUMBER = X_SUBMISSION_NUMBER
677: and ORG_UNIT_CD = X_ORG_UNIT_CD
678: and OU_START_DT = X_OU_START_DT

Line 728: insert into IGS_AD_SBMAO_FN_UITT (

724: x_last_update_login =>X_LAST_UPDATE_LOGIN
725: );
726:
727:
728: insert into IGS_AD_SBMAO_FN_UITT (
729: SUBMISSION_YR,
730: SUBMISSION_NUMBER,
731: ORG_UNIT_CD,
732: OU_START_DT,

Line 802: from IGS_AD_SBMAO_FN_UITT

798: MAX_TARGET,
799: OVERRIDE_S_AMOUNT_TYPE,
800: ACTUAL_ENROLMENT,
801: ACTUAL_ENR_EFFECTIVE_DT
802: from IGS_AD_SBMAO_FN_UITT
803: where ROWID = X_ROWID
804: for update nowait;
805: tlinfo c1%rowtype;
806:

Line 903: update IGS_AD_SBMAO_FN_UITT set

899: x_last_updated_by =>X_LAST_UPDATED_BY,
900: x_last_update_login =>X_LAST_UPDATE_LOGIN
901: );
902:
903: update IGS_AD_SBMAO_FN_UITT set
904: TARGET = NEW_REFERENCES.TARGET,
905: MAX_TARGET = NEW_REFERENCES.MAX_TARGET,
906: OVERRIDE_S_AMOUNT_TYPE = NEW_REFERENCES.OVERRIDE_S_AMOUNT_TYPE,
907: ACTUAL_ENROLMENT = NEW_REFERENCES.ACTUAL_ENROLMENT,

Line 941: cursor c1 is select rowid from IGS_AD_SBMAO_FN_UITT

937: X_ACTUAL_ENROLMENT in NUMBER,
938: X_ACTUAL_ENR_EFFECTIVE_DT in DATE,
939: X_MODE in VARCHAR2 default 'R'
940: ) as
941: cursor c1 is select rowid from IGS_AD_SBMAO_FN_UITT
942: where SUBMISSION_YR = X_SUBMISSION_YR
943: and SUBMISSION_NUMBER = X_SUBMISSION_NUMBER
944: and ORG_UNIT_CD = X_ORG_UNIT_CD
945: and OU_START_DT = X_OU_START_DT

Line 1000: delete from IGS_AD_SBMAO_FN_UITT

996: p_action =>'DELETE',
997: x_rowid => X_ROWID
998: );
999:
1000: delete from IGS_AD_SBMAO_FN_UITT
1001: where ROWID = X_ROWID;
1002: if (sql%notfound) then
1003: raise no_data_found;
1004: end if;

Line 1013: end IGS_AD_SBMAO_FN_UITT_PKG;

1009: );
1010:
1011: end DELETE_ROW;
1012:
1013: end IGS_AD_SBMAO_FN_UITT_PKG;