APPS.IGS_PS_OCCUP_TITLES_PKG dependencies on IGS_PS_OCCUP_TITLES

Line 1: PACKAGE BODY igs_ps_occup_titles_pkg AS

1: PACKAGE BODY igs_ps_occup_titles_pkg AS
2: /* $Header: IGSPI0FB.pls 115.10 2003/03/21 08:13:27 sarakshi ship $ */
3: l_rowid VARCHAR2(25);
4: old_references igs_ps_occup_titles_all%RowType;
5: new_references igs_ps_occup_titles_all%RowType;

Line 4: old_references igs_ps_occup_titles_all%RowType;

1: PACKAGE BODY igs_ps_occup_titles_pkg AS
2: /* $Header: IGSPI0FB.pls 115.10 2003/03/21 08:13:27 sarakshi ship $ */
3: l_rowid VARCHAR2(25);
4: old_references igs_ps_occup_titles_all%RowType;
5: new_references igs_ps_occup_titles_all%RowType;
6:
7: PROCEDURE Set_Column_Values (
8: p_action IN VARCHAR2,

Line 5: new_references igs_ps_occup_titles_all%RowType;

1: PACKAGE BODY igs_ps_occup_titles_pkg AS
2: /* $Header: IGSPI0FB.pls 115.10 2003/03/21 08:13:27 sarakshi ship $ */
3: l_rowid VARCHAR2(25);
4: old_references igs_ps_occup_titles_all%RowType;
5: new_references igs_ps_occup_titles_all%RowType;
6:
7: PROCEDURE Set_Column_Values (
8: p_action IN VARCHAR2,
9: x_rowid IN VARCHAR2 DEFAULT NULL,

Line 37: FROM IGS_PS_OCCUP_TITLES_ALL

33:
34:
35: CURSOR cur_old_ref_values IS
36: SELECT *
37: FROM IGS_PS_OCCUP_TITLES_ALL
38: WHERE rowid = x_rowid;
39:
40: BEGIN
41:

Line 192: FROM igs_ps_occup_titles_all

188:
189:
190: CURSOR cur_rowid IS
191: SELECT rowid
192: FROM igs_ps_occup_titles_all
193: WHERE program_occupational_title_id = x_prgm_occupational_title_id
194: FOR UPDATE NOWAIT;
195:
196: lv_rowid cur_rowid%RowType;

Line 231: FROM igs_ps_occup_titles_all

227:
228:
229: CURSOR cur_rowid IS
230: SELECT rowid
231: FROM igs_ps_occup_titles_all
232: WHERE occupational_title_code = x_occupational_title_code
233: AND program_code = x_program_code and ((l_rowid is null) or (rowid <> l_rowid))
234:
235: ;

Line 267: FROM igs_ps_occup_titles_all

263: ***************************************************************/
264:
265: CURSOR cur_rowid IS
266: SELECT rowid
267: FROM igs_ps_occup_titles_all
268: WHERE occupational_title_code = x_occupational_title_code ;
269:
270: lv_rowid cur_rowid%RowType;
271:

Line 304: FROM igs_ps_occup_titles_all

300: ***************************************************************/
301:
302: CURSOR cur_rowid IS
303: SELECT rowid
304: FROM igs_ps_occup_titles_all
305: WHERE program_code = x_program_code ;
306:
307: lv_rowid cur_rowid%RowType;
308:

Line 465: cursor C is select ROWID from IGS_PS_OCCUP_TITLES

461:
462: (reverse chronological order - newest change first)
463: ***************************************************************/
464:
465: cursor C is select ROWID from IGS_PS_OCCUP_TITLES
466: where PROGRAM_OCCUPATIONAL_TITLE_ID= X_PRGM_OCCUPATIONAL_TITLE_ID
467: ;
468: X_LAST_UPDATE_DATE DATE ;
469: X_LAST_UPDATED_BY NUMBER ;

Line 507: insert into IGS_PS_OCCUP_TITLES (

503: x_last_update_date=>X_LAST_UPDATE_DATE,
504: x_last_updated_by=>X_LAST_UPDATED_BY,
505: x_last_update_login=>X_LAST_UPDATE_LOGIN,
506: x_org_id => igs_ge_gen_003.get_org_id);
507: insert into IGS_PS_OCCUP_TITLES (
508: PROGRAM_OCCUPATIONAL_TITLE_ID
509: ,PROGRAM_CODE
510: ,OCCUPATIONAL_TITLE_CODE
511: ,CREATION_DATE

Line 558: from IGS_PS_OCCUP_TITLES_ALL

554:
555: cursor c1 is select
556: PROGRAM_CODE
557: , OCCUPATIONAL_TITLE_CODE
558: from IGS_PS_OCCUP_TITLES_ALL
559: where ROWID = X_ROWID
560: for update nowait;
561: tlinfo c1%rowtype;
562: begin

Line 635: update IGS_PS_OCCUP_TITLES_ALL set

631: x_created_by=>X_LAST_UPDATED_BY,
632: x_last_update_date=>X_LAST_UPDATE_DATE,
633: x_last_updated_by=>X_LAST_UPDATED_BY,
634: x_last_update_login=>X_LAST_UPDATE_LOGIN);
635: update IGS_PS_OCCUP_TITLES_ALL set
636: PROGRAM_CODE = NEW_REFERENCES.PROGRAM_CODE,
637: OCCUPATIONAL_TITLE_CODE = NEW_REFERENCES.OCCUPATIONAL_TITLE_CODE,
638: LAST_UPDATE_DATE = X_LAST_UPDATE_DATE,
639: LAST_UPDATED_BY = X_LAST_UPDATED_BY,

Line 673: cursor c1 is select ROWID from IGS_PS_OCCUP_TITLES_ALL

669: ***************************************************************/
670:
671:
672:
673: cursor c1 is select ROWID from IGS_PS_OCCUP_TITLES_ALL
674: where PROGRAM_OCCUPATIONAL_TITLE_ID= X_PRGM_OCCUPATIONAL_TITLE_ID
675: ;
676: begin
677: open c1;

Line 720: delete from IGS_PS_OCCUP_TITLES

716: Before_DML (
717: p_action => 'DELETE',
718: x_rowid => X_ROWID
719: );
720: delete from IGS_PS_OCCUP_TITLES
721: where ROWID = X_ROWID;
722: if (sql%notfound) then
723: raise no_data_found;
724: end if;

Line 730: END igs_ps_occup_titles_pkg;

726: p_action => 'DELETE',
727: x_rowid => X_ROWID
728: );
729: end DELETE_ROW;
730: END igs_ps_occup_titles_pkg;