APPS.IGS_AD_SBM_PS_FNTRGT_PKG dependencies on IGS_AD_SBM_PS_FNTRGT

Line 1: package body IGS_AD_SBM_PS_FNTRGT_PKG as

1: package body IGS_AD_SBM_PS_FNTRGT_PKG as
2: /* $Header: IGSAI60B.pls 115.5 2003/10/30 13:21:04 rghosh ship $ */
3:
4: l_rowid VARCHAR2(25);
5: old_references IGS_AD_SBM_PS_FNTRGT%RowType;

Line 5: old_references IGS_AD_SBM_PS_FNTRGT%RowType;

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

Line 6: new_references IGS_AD_SBM_PS_FNTRGT%RowType;

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

Line 31: FROM IGS_AD_SBM_PS_FNTRGT

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

Line 387: IGS_AD_SBMPS_FN_ITTT_PKG.GET_FK_IGS_AD_SBM_PS_FNTRGT (

383:
384: PROCEDURE Check_Child_Existance AS
385: BEGIN
386:
387: IGS_AD_SBMPS_FN_ITTT_PKG.GET_FK_IGS_AD_SBM_PS_FNTRGT (
388: old_references.submission_yr,
389: old_references.submission_number,
390: old_references.course_cd,
391: old_references.crv_version_number,

Line 409: FROM IGS_AD_SBM_PS_FNTRGT

405: )return BOOLEAN AS
406:
407: CURSOR cur_rowid IS
408: SELECT rowid
409: FROM IGS_AD_SBM_PS_FNTRGT
410: WHERE submission_yr = x_submission_yr
411: AND submission_number = x_submission_number
412: AND course_cd = x_course_cd
413: AND crv_version_number = x_crv_version_number

Line 440: FROM IGS_AD_SBM_PS_FNTRGT

436: ) AS
437:
438: CURSOR cur_rowid IS
439: SELECT rowid
440: FROM IGS_AD_SBM_PS_FNTRGT
441: WHERE attendance_mode = x_attendance_mode ;
442:
443: lv_rowid cur_rowid%RowType;
444:

Line 466: FROM IGS_AD_SBM_PS_FNTRGT

462: ) AS
463:
464: CURSOR cur_rowid IS
465: SELECT rowid
466: FROM IGS_AD_SBM_PS_FNTRGT
467: WHERE attendance_type = x_attendance_type ;
468:
469: lv_rowid cur_rowid%RowType;
470:

Line 493: FROM IGS_AD_SBM_PS_FNTRGT

489: ) AS
490:
491: CURSOR cur_rowid IS
492: SELECT rowid
493: FROM IGS_AD_SBM_PS_FNTRGT
494: WHERE course_cd = x_course_cd
495: AND crv_version_number = x_version_number ;
496:
497: lv_rowid cur_rowid%RowType;

Line 520: FROM IGS_AD_SBM_PS_FNTRGT

516: ) AS
517:
518: CURSOR cur_rowid IS
519: SELECT rowid
520: FROM IGS_AD_SBM_PS_FNTRGT
521: WHERE funding_source = x_funding_source ;
522:
523: lv_rowid cur_rowid%RowType;
524:

Line 548: FROM IGS_AD_SBM_PS_FNTRGT

544: ) AS
545:
546: CURSOR cur_rowid IS
547: SELECT rowid
548: FROM IGS_AD_SBM_PS_FNTRGT
549: WHERE submission_yr = x_submission_yr
550: AND submission_number = x_submission_number ;
551:
552: lv_rowid cur_rowid%RowType;

Line 575: FROM IGS_AD_SBM_PS_FNTRGT

571: ) AS
572:
573: CURSOR cur_rowid IS
574: SELECT rowid
575: FROM IGS_AD_SBM_PS_FNTRGT
576: WHERE location_cd = x_location_cd ;
577:
578: lv_rowid cur_rowid%RowType;
579:

Line 602: FROM IGS_AD_SBM_PS_FNTRGT

598: ) AS
599:
600: CURSOR cur_rowid IS
601: SELECT rowid
602: FROM IGS_AD_SBM_PS_FNTRGT
603: WHERE unit_set_cd = x_unit_set_cd
604: AND us_version_number = x_version_number ;
605:
606: lv_rowid cur_rowid%RowType;

Line 734: cursor C is select ROWID from IGS_AD_SBM_PS_FNTRGT

730: X_UNIT_SET_CD in VARCHAR2,
731: X_US_VERSION_NUMBER in NUMBER,
732: X_MODE in VARCHAR2 default 'R'
733: ) AS
734: cursor C is select ROWID from IGS_AD_SBM_PS_FNTRGT
735: where SUBMISSION_YR = X_SUBMISSION_YR
736: and SUBMISSION_NUMBER = X_SUBMISSION_NUMBER
737: and COURSE_CD = X_COURSE_CD
738: and CRV_VERSION_NUMBER = X_CRV_VERSION_NUMBER

Line 785: insert into IGS_AD_SBM_PS_FNTRGT (

781: x_last_update_login => X_LAST_UPDATE_LOGIN
782: );
783:
784:
785: insert into IGS_AD_SBM_PS_FNTRGT (
786: SUBMISSION_YR,
787: SUBMISSION_NUMBER,
788: COURSE_CD,
789: CRV_VERSION_NUMBER,

Line 855: from IGS_AD_SBM_PS_FNTRGT

851: ATTENDANCE_MODE,
852: ATTENDANCE_TYPE,
853: UNIT_SET_CD,
854: US_VERSION_NUMBER
855: from IGS_AD_SBM_PS_FNTRGT
856: where ROWID = X_ROWID for update nowait;
857: tlinfo c1%rowtype;
858:
859: begin

Line 954: update IGS_AD_SBM_PS_FNTRGT set

950: x_last_updated_by => X_LAST_UPDATED_BY,
951: x_last_update_login => X_LAST_UPDATE_LOGIN
952: );
953:
954: update IGS_AD_SBM_PS_FNTRGT set
955: LOCATION_CD = NEW_REFERENCES.LOCATION_CD,
956: ATTENDANCE_MODE = NEW_REFERENCES.ATTENDANCE_MODE,
957: ATTENDANCE_TYPE = NEW_REFERENCES.ATTENDANCE_TYPE,
958: UNIT_SET_CD = NEW_REFERENCES.UNIT_SET_CD,

Line 989: cursor c1 is select rowid from IGS_AD_SBM_PS_FNTRGT

985: X_UNIT_SET_CD in VARCHAR2,
986: X_US_VERSION_NUMBER in NUMBER,
987: X_MODE in VARCHAR2 default 'R'
988: ) as
989: cursor c1 is select rowid from IGS_AD_SBM_PS_FNTRGT
990: where SUBMISSION_YR = X_SUBMISSION_YR
991: and SUBMISSION_NUMBER = X_SUBMISSION_NUMBER
992: and COURSE_CD = X_COURSE_CD
993: and CRV_VERSION_NUMBER = X_CRV_VERSION_NUMBER

Line 1043: delete from IGS_AD_SBM_PS_FNTRGT

1039: Before_DML (
1040: p_action => 'DELETE',
1041: x_rowid => X_ROWID
1042: );
1043: delete from IGS_AD_SBM_PS_FNTRGT
1044: where ROWID = X_ROWID;
1045: if (sql%notfound) then
1046: raise no_data_found;
1047: end if;

Line 1054: end IGS_AD_SBM_PS_FNTRGT_PKG;

1050: x_rowid => X_ROWID
1051: );
1052: end DELETE_ROW;
1053:
1054: end IGS_AD_SBM_PS_FNTRGT_PKG;