APPS.IGS_AD_SBMPS_FN_ITTT_PKG dependencies on IGS_AD_SBMPS_FN_ITTT

Line 1: package body IGS_AD_SBMPS_FN_ITTT_PKG as

1: package body IGS_AD_SBMPS_FN_ITTT_PKG as
2: /* $Header: IGSAI61B.pls 115.5 2003/10/30 13:21:12 rghosh ship $ */
3: l_rowid VARCHAR2(25);
4: old_references IGS_AD_SBMPS_FN_ITTT%RowType;
5: new_references IGS_AD_SBMPS_FN_ITTT%RowType;

Line 4: old_references IGS_AD_SBMPS_FN_ITTT%RowType;

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

Line 5: new_references IGS_AD_SBMPS_FN_ITTT%RowType;

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

Line 32: FROM IGS_AD_SBMPS_FN_ITTT

28: ) as
29:
30: CURSOR cur_old_ref_values IS
31: SELECT *
32: FROM IGS_AD_SBMPS_FN_ITTT
33: WHERE rowid = x_rowid;
34:
35: BEGIN
36:

Line 82: -- ON IGS_AD_SBMPS_FN_ITTT

78:
79: -- Trigger description :-
80: -- "OSS_TST".trg_scfit_br_iu
81: -- BEFORE INSERT OR UPDATE
82: -- ON IGS_AD_SBMPS_FN_ITTT
83: -- FOR EACH ROW
84:
85: PROCEDURE BeforeRowInsertUpdate1(
86: p_inserting IN BOOLEAN DEFAULT FALSE,

Line 230: FROM IGS_AD_SBMPS_FN_ITTT

226: RETURN BOOLEAN as
227:
228: CURSOR cur_rowid IS
229: SELECT rowid
230: FROM IGS_AD_SBMPS_FN_ITTT
231: WHERE submission_yr = x_submission_yr
232: AND submission_number = x_submission_number
233: AND course_cd = x_course_cd
234: AND crv_version_number = x_crv_version_number

Line 267: FROM IGS_AD_SBMPS_FN_ITTT

263: ) as
264:
265: CURSOR cur_rowid IS
266: SELECT rowid
267: FROM IGS_AD_SBMPS_FN_ITTT
268: WHERE submission_yr = x_submission_yr
269: AND submission_number = x_submission_number
270: AND course_cd = x_course_cd
271: AND crv_version_number = x_crv_version_number

Line 298: FROM IGS_AD_SBMPS_FN_ITTT

294: ) as
295:
296: CURSOR cur_rowid IS
297: SELECT rowid
298: FROM IGS_AD_SBMPS_FN_ITTT
299: WHERE intake_target_type = x_intake_target_type ;
300:
301: lv_rowid cur_rowid%RowType;
302:

Line 324: FROM IGS_AD_SBMPS_FN_ITTT

320: ) as
321:
322: CURSOR cur_rowid IS
323: SELECT rowid
324: FROM IGS_AD_SBMPS_FN_ITTT
325: WHERE override_s_amount_type = x_override_s_amount_type ;
326:
327: lv_rowid cur_rowid%RowType;
328:

Line 555: cursor C is select ROWID from IGS_AD_SBMPS_FN_ITTT

551: X_ACTUAL_ENROLMENT in NUMBER,
552: X_ACTUAL_ENR_EFFECTIVE_DT in DATE,
553: X_MODE in VARCHAR2 default 'R'
554: ) as
555: cursor C is select ROWID from IGS_AD_SBMPS_FN_ITTT
556: where SUBMISSION_YR = X_SUBMISSION_YR
557: and SUBMISSION_NUMBER = X_SUBMISSION_NUMBER
558: and COURSE_CD = X_COURSE_CD
559: and CRV_VERSION_NUMBER = X_CRV_VERSION_NUMBER

Line 609: insert into IGS_AD_SBMPS_FN_ITTT (

605: x_last_updated_by =>X_LAST_UPDATED_BY,
606: x_last_update_login =>X_LAST_UPDATE_LOGIN
607: );
608:
609: insert into IGS_AD_SBMPS_FN_ITTT (
610: SUBMISSION_YR,
611: SUBMISSION_NUMBER,
612: COURSE_CD,
613: CRV_VERSION_NUMBER,

Line 687: from IGS_AD_SBMPS_FN_ITTT

683: MAX_TARGET,
684: OVERRIDE_S_AMOUNT_TYPE,
685: ACTUAL_ENROLMENT,
686: ACTUAL_ENR_EFFECTIVE_DT
687: from IGS_AD_SBMPS_FN_ITTT
688: where ROWID = X_ROWID
689: for update nowait;
690: tlinfo c1%rowtype;
691:

Line 795: update IGS_AD_SBMPS_FN_ITTT set

791: x_last_update_login =>X_LAST_UPDATE_LOGIN
792: );
793:
794:
795: update IGS_AD_SBMPS_FN_ITTT set
796: PRIORITY_OF_TARGET = NEW_REFERENCES.PRIORITY_OF_TARGET,
797: TARGET = NEW_REFERENCES.TARGET,
798: MAX_TARGET = NEW_REFERENCES.MAX_TARGET,
799: OVERRIDE_S_AMOUNT_TYPE = NEW_REFERENCES.OVERRIDE_S_AMOUNT_TYPE,

Line 836: cursor c1 is select rowid from IGS_AD_SBMPS_FN_ITTT

832: X_ACTUAL_ENROLMENT in NUMBER,
833: X_ACTUAL_ENR_EFFECTIVE_DT in DATE,
834: X_MODE in VARCHAR2 default 'R'
835: ) as
836: cursor c1 is select rowid from IGS_AD_SBMPS_FN_ITTT
837: where SUBMISSION_YR = X_SUBMISSION_YR
838: and SUBMISSION_NUMBER = X_SUBMISSION_NUMBER
839: and COURSE_CD = X_COURSE_CD
840: and CRV_VERSION_NUMBER = X_CRV_VERSION_NUMBER

Line 898: delete from IGS_AD_SBMPS_FN_ITTT

894: x_rowid => X_ROWID
895: );
896:
897:
898: delete from IGS_AD_SBMPS_FN_ITTT
899: where ROWID = X_ROWID;
900: if (sql%notfound) then
901: raise no_data_found;
902: end if;

Line 910: end IGS_AD_SBMPS_FN_ITTT_PKG;

906: x_rowid => X_ROWID
907: );
908: end DELETE_ROW;
909:
910: end IGS_AD_SBMPS_FN_ITTT_PKG;