APPS.IGS_AD_SBMAO_FN_CTTT_PKG dependencies on IGS_AD_SBMAO_FN_CTTT

Line 1: package body IGS_AD_SBMAO_FN_CTTT_PKG as

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

Line 4: old_references IGS_AD_SBMAO_FN_CTTT%RowType;

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

Line 5: new_references IGS_AD_SBMAO_FN_CTTT%RowType;

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

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

Line 291: FROM IGS_AD_SBMAO_FN_CTTT

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

Line 323: FROM IGS_AD_SBMAO_FN_CTTT

319: ) AS
320:
321: CURSOR cur_rowid IS
322: SELECT rowid
323: FROM IGS_AD_SBMAO_FN_CTTT
324: WHERE course_type_group_cd = x_course_type_group_cd ;
325:
326: lv_rowid cur_rowid%RowType;
327:

Line 349: FROM IGS_AD_SBMAO_FN_CTTT

345: ) AS
346:
347: CURSOR cur_rowid IS
348: SELECT rowid
349: FROM IGS_AD_SBMAO_FN_CTTT
350: WHERE funding_source = x_funding_source ;
351:
352: lv_rowid cur_rowid%RowType;
353:

Line 376: FROM IGS_AD_SBMAO_FN_CTTT

372: ) AS
373:
374: CURSOR cur_rowid IS
375: SELECT rowid
376: FROM IGS_AD_SBMAO_FN_CTTT
377: WHERE submission_yr = x_submission_yr
378: AND submission_number = x_submission_number ;
379:
380: lv_rowid cur_rowid%RowType;

Line 403: FROM IGS_AD_SBMAO_FN_CTTT

399: ) AS
400:
401: CURSOR cur_rowid IS
402: SELECT rowid
403: FROM IGS_AD_SBMAO_FN_CTTT
404: WHERE intake_target_type = x_intake_target_type ;
405:
406: lv_rowid cur_rowid%RowType;
407:

Line 430: FROM IGS_AD_SBMAO_FN_CTTT

426: ) AS
427:
428: CURSOR cur_rowid IS
429: SELECT rowid
430: FROM IGS_AD_SBMAO_FN_CTTT
431: WHERE org_unit_cd = x_org_unit_cd
432: AND TRUNC(ou_start_dt) = TRUNC(x_start_dt) ;
433:
434: lv_rowid cur_rowid%RowType;

Line 457: FROM IGS_AD_SBMAO_FN_CTTT

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

Line 670: cursor C is select ROWID from IGS_AD_SBMAO_FN_CTTT

666: X_ACTUAL_ENROLMENT in NUMBER,
667: X_ACTUAL_ENR_EFFECTIVE_DT in DATE,
668: X_MODE in VARCHAR2 default 'R'
669: ) AS
670: cursor C is select ROWID from IGS_AD_SBMAO_FN_CTTT
671: where SUBMISSION_YR = X_SUBMISSION_YR
672: and SUBMISSION_NUMBER = X_SUBMISSION_NUMBER
673: and ORG_UNIT_CD = X_ORG_UNIT_CD
674: and OU_START_DT = X_OU_START_DT

Line 722: insert into IGS_AD_SBMAO_FN_CTTT (

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

Line 795: from IGS_AD_SBMAO_FN_CTTT

791: MAX_TARGET,
792: OVERRIDE_S_AMOUNT_TYPE,
793: ACTUAL_ENROLMENT,
794: ACTUAL_ENR_EFFECTIVE_DT
795: from IGS_AD_SBMAO_FN_CTTT
796: where ROWID = X_ROWID
797: for update nowait;
798: tlinfo c1%rowtype;
799:

Line 895: update IGS_AD_SBMAO_FN_CTTT set

891: x_last_updated_by =>X_LAST_UPDATED_BY,
892: x_last_update_login =>X_LAST_UPDATE_LOGIN
893: );
894:
895: update IGS_AD_SBMAO_FN_CTTT set
896: TARGET = NEW_REFERENCES.TARGET,
897: MAX_TARGET = NEW_REFERENCES.MAX_TARGET,
898: OVERRIDE_S_AMOUNT_TYPE = NEW_REFERENCES.OVERRIDE_S_AMOUNT_TYPE,
899: ACTUAL_ENROLMENT = NEW_REFERENCES.ACTUAL_ENROLMENT,

Line 933: cursor c1 is select rowid from IGS_AD_SBMAO_FN_CTTT

929: X_ACTUAL_ENROLMENT in NUMBER,
930: X_ACTUAL_ENR_EFFECTIVE_DT in DATE,
931: X_MODE in VARCHAR2 default 'R'
932: ) AS
933: cursor c1 is select rowid from IGS_AD_SBMAO_FN_CTTT
934: where SUBMISSION_YR = X_SUBMISSION_YR
935: and SUBMISSION_NUMBER = X_SUBMISSION_NUMBER
936: and ORG_UNIT_CD = X_ORG_UNIT_CD
937: and OU_START_DT = X_OU_START_DT

Line 991: delete from IGS_AD_SBMAO_FN_CTTT

987: Before_DML(
988: p_action =>'DELETE',
989: x_rowid => X_ROWID
990: );
991: delete from IGS_AD_SBMAO_FN_CTTT
992: where ROWID = X_ROWID;
993: if (sql%notfound) then
994: raise no_data_found;
995: end if;

Line 1004: end IGS_AD_SBMAO_FN_CTTT_PKG;

1000: );
1001:
1002: end DELETE_ROW;
1003:
1004: end IGS_AD_SBMAO_FN_CTTT_PKG;