APPS.IGS_AD_TERM_DETAILS_PKG dependencies on IGS_AD_TERM_DETAILS

Line 1: PACKAGE BODY igs_ad_term_details_pkg AS

1: PACKAGE BODY igs_ad_term_details_pkg AS
2: /* $Header: IGSAI83B.pls 120.2 2005/10/01 21:47:34 appldev ship $ */
3: l_rowid VARCHAR2(25);
4: old_references igs_ad_term_details%RowType;
5: new_references igs_ad_term_details%RowType;

Line 4: old_references igs_ad_term_details%RowType;

1: PACKAGE BODY igs_ad_term_details_pkg AS
2: /* $Header: IGSAI83B.pls 120.2 2005/10/01 21:47:34 appldev ship $ */
3: l_rowid VARCHAR2(25);
4: old_references igs_ad_term_details%RowType;
5: new_references igs_ad_term_details%RowType;
6:
7: PROCEDURE Check_Status AS
8: /*************************************************************

Line 5: new_references igs_ad_term_details%RowType;

1: PACKAGE BODY igs_ad_term_details_pkg AS
2: /* $Header: IGSAI83B.pls 120.2 2005/10/01 21:47:34 appldev ship $ */
3: l_rowid VARCHAR2(25);
4: old_references igs_ad_term_details%RowType;
5: new_references igs_ad_term_details%RowType;
6:
7: PROCEDURE Check_Status AS
8: /*************************************************************
9: Created By : jchin

Line 80: FROM IGS_AD_TERM_DETAILS

76: ***************************************************************/
77:
78: CURSOR cur_old_ref_values IS
79: SELECT *
80: FROM IGS_AD_TERM_DETAILS
81: WHERE rowid = x_rowid;
82:
83: BEGIN
84:

Line 259: Igs_Ad_Term_Unitdtls_Pkg.Get_FK_Igs_Ad_Term_Details (

255: ***************************************************************/
256:
257: BEGIN
258:
259: Igs_Ad_Term_Unitdtls_Pkg.Get_FK_Igs_Ad_Term_Details (
260: old_references.term_details_id
261: );
262:
263: END Check_Child_Existance;

Line 282: FROM igs_ad_term_details

278: ***************************************************************/
279:
280: CURSOR cur_rowid IS
281: SELECT rowid
282: FROM igs_ad_term_details
283: WHERE term_details_id = x_term_details_id
284: FOR UPDATE NOWAIT;
285:
286: lv_rowid cur_rowid%RowType;

Line 318: FROM igs_ad_term_details

314: ***************************************************************/
315:
316: CURSOR cur_rowid IS
317: SELECT rowid
318: FROM igs_ad_term_details
319: WHERE transcript_id = x_transcript_id ;
320:
321: lv_rowid cur_rowid%RowType;
322:

Line 487: cursor C is select ROWID from IGS_AD_TERM_DETAILS

483:
484: (reverse chronological order - newest change first)
485: ***************************************************************/
486:
487: cursor C is select ROWID from IGS_AD_TERM_DETAILS
488: where TERM_DETAILS_ID= X_TERM_DETAILS_ID
489: ;
490: X_LAST_UPDATE_DATE DATE ;
491: X_LAST_UPDATED_BY NUMBER ;

Line 550: insert into IGS_AD_TERM_DETAILS (

546: x_last_update_login=>X_LAST_UPDATE_LOGIN);
547: IF (x_mode = 'S') THEN
548: igs_sc_gen_001.set_ctx('R');
549: END IF;
550: insert into IGS_AD_TERM_DETAILS (
551: TERM_DETAILS_ID
552: ,TRANSCRIPT_ID
553: ,TERM
554: ,START_DATE

Line 571: IGS_AD_TERM_DETAILS_S.NEXTVAL

567: ,PROGRAM_ID
568: ,PROGRAM_APPLICATION_ID
569: ,PROGRAM_UPDATE_DATE
570: ) values (
571: IGS_AD_TERM_DETAILS_S.NEXTVAL
572: ,NEW_REFERENCES.TRANSCRIPT_ID
573: ,NEW_REFERENCES.TERM
574: ,NEW_REFERENCES.START_DATE
575: ,NEW_REFERENCES.END_DATE

Line 652: from IGS_AD_TERM_DETAILS

648: , TOTAL_CP_EARNED
649: , TOTAL_UNIT_GP
650: , TOTAL_GPA_UNITS
651: , GPA
652: from IGS_AD_TERM_DETAILS
653: where ROWID = X_ROWID
654: for update nowait;
655: tlinfo c1%rowtype;
656: begin

Line 782: update IGS_AD_TERM_DETAILS set

778:
779: IF (x_mode = 'S') THEN
780: igs_sc_gen_001.set_ctx('R');
781: END IF;
782: update IGS_AD_TERM_DETAILS set
783: TRANSCRIPT_ID = NEW_REFERENCES.TRANSCRIPT_ID,
784: TERM = NEW_REFERENCES.TERM,
785: START_DATE = NEW_REFERENCES.START_DATE,
786: END_DATE = NEW_REFERENCES.END_DATE,

Line 854: cursor c1 is select ROWID from IGS_AD_TERM_DETAILS

850:
851: (reverse chronological order - newest change first)
852: ***************************************************************/
853:
854: cursor c1 is select ROWID from IGS_AD_TERM_DETAILS
855: where TERM_DETAILS_ID= X_TERM_DETAILS_ID
856: ;
857: begin
858: open c1;

Line 915: delete from IGS_AD_TERM_DETAILS

911: );
912: IF (x_mode = 'S') THEN
913: igs_sc_gen_001.set_ctx('R');
914: END IF;
915: delete from IGS_AD_TERM_DETAILS
916: where ROWID = X_ROWID;
917: if (sql%notfound) then
918: fnd_message.set_name ('IGS', 'IGS_SC_POLICY_UPD_DEL_EXCEP');
919: igs_ge_msg_stack.add;

Line 932: END igs_ad_term_details_pkg;

928: p_action => 'DELETE',
929: x_rowid => X_ROWID
930: );
931: end DELETE_ROW;
932: END igs_ad_term_details_pkg;