APPS.IGS_PS_DIC_OCC_TITLS_PKG dependencies on IGS_PS_DIC_OCC_TITLS

Line 1: PACKAGE BODY igs_ps_dic_occ_titls_pkg AS

1: PACKAGE BODY igs_ps_dic_occ_titls_pkg AS
2: /* $Header: IGSPI0EB.pls 115.6 2002/11/29 01:56:01 nsidana ship $ */
3: l_rowid VARCHAR2(25);
4: old_references igs_ps_dic_occ_titls%RowType;
5: new_references igs_ps_dic_occ_titls%RowType;

Line 4: old_references igs_ps_dic_occ_titls%RowType;

1: PACKAGE BODY igs_ps_dic_occ_titls_pkg AS
2: /* $Header: IGSPI0EB.pls 115.6 2002/11/29 01:56:01 nsidana ship $ */
3: l_rowid VARCHAR2(25);
4: old_references igs_ps_dic_occ_titls%RowType;
5: new_references igs_ps_dic_occ_titls%RowType;
6:
7: PROCEDURE Set_Column_Values (
8: p_action IN VARCHAR2,

Line 5: new_references igs_ps_dic_occ_titls%RowType;

1: PACKAGE BODY igs_ps_dic_occ_titls_pkg AS
2: /* $Header: IGSPI0EB.pls 115.6 2002/11/29 01:56:01 nsidana ship $ */
3: l_rowid VARCHAR2(25);
4: old_references igs_ps_dic_occ_titls%RowType;
5: new_references igs_ps_dic_occ_titls%RowType;
6:
7: PROCEDURE Set_Column_Values (
8: p_action IN VARCHAR2,
9: x_rowid IN VARCHAR2 DEFAULT NULL,

Line 35: FROM IGS_PS_DIC_OCC_TITLS

31:
32:
33: CURSOR cur_old_ref_values IS
34: SELECT *
35: FROM IGS_PS_DIC_OCC_TITLS
36: WHERE rowid = x_rowid;
37:
38: BEGIN
39:

Line 115: Igs_Ps_Occup_Titles_Pkg.Get_FK_Igs_Ps_Dic_Occ_Titls (

111: ***************************************************************/
112:
113: BEGIN
114:
115: Igs_Ps_Occup_Titles_Pkg.Get_FK_Igs_Ps_Dic_Occ_Titls (
116: old_references.occupational_title_code
117: );
118:
119: END Check_Child_Existance;

Line 130: FROM igs_ps_dic_occ_titls

126: ) RETURN BOOLEAN AS
127:
128: CURSOR cur_rowid IS
129: SELECT rowid
130: FROM igs_ps_dic_occ_titls
131: WHERE occupational_title_code = x_occupational_title_code
132: FOR UPDATE NOWAIT;
133:
134: lv_rowid cur_rowid%RowType;

Line 280: cursor C is select ROWID from IGS_PS_DIC_OCC_TITLS

276: ***************************************************************/
277:
278:
279:
280: cursor C is select ROWID from IGS_PS_DIC_OCC_TITLS
281: where OCCUPATIONAL_TITLE_CODE= X_OCCUPATIONAL_TITLE_CODE
282: ;
283: X_LAST_UPDATE_DATE DATE ;
284: X_LAST_UPDATED_BY NUMBER ;

Line 316: insert into IGS_PS_DIC_OCC_TITLS (

312: x_created_by=>X_LAST_UPDATED_BY,
313: x_last_update_date=>X_LAST_UPDATE_DATE,
314: x_last_updated_by=>X_LAST_UPDATED_BY,
315: x_last_update_login=>X_LAST_UPDATE_LOGIN);
316: insert into IGS_PS_DIC_OCC_TITLS (
317: OCCUPATIONAL_TITLE_CODE
318: ,OCCUPATIONAL_TITLE
319: ,ALTERNATE_TITLE
320: ,CREATION_DATE

Line 367: from IGS_PS_DIC_OCC_TITLS

363:
364: cursor c1 is select
365: OCCUPATIONAL_TITLE
366: , ALTERNATE_TITLE
367: from IGS_PS_DIC_OCC_TITLS
368: where ROWID = X_ROWID
369: for update nowait;
370: tlinfo c1%rowtype;
371: begin

Line 448: update IGS_PS_DIC_OCC_TITLS set

444: x_created_by=>X_LAST_UPDATED_BY,
445: x_last_update_date=>X_LAST_UPDATE_DATE,
446: x_last_updated_by=>X_LAST_UPDATED_BY,
447: x_last_update_login=>X_LAST_UPDATE_LOGIN);
448: update IGS_PS_DIC_OCC_TITLS set
449: OCCUPATIONAL_TITLE = NEW_REFERENCES.OCCUPATIONAL_TITLE,
450: ALTERNATE_TITLE = NEW_REFERENCES.ALTERNATE_TITLE,
451: LAST_UPDATE_DATE = X_LAST_UPDATE_DATE,
452: LAST_UPDATED_BY = X_LAST_UPDATED_BY,

Line 485: cursor c1 is select ROWID from IGS_PS_DIC_OCC_TITLS

481: (reverse chronological order - newest change first)
482: ***************************************************************/
483:
484:
485: cursor c1 is select ROWID from IGS_PS_DIC_OCC_TITLS
486: where OCCUPATIONAL_TITLE_CODE= X_OCCUPATIONAL_TITLE_CODE
487: ;
488: begin
489: open c1;

Line 531: delete from IGS_PS_DIC_OCC_TITLS

527: Before_DML (
528: p_action => 'DELETE',
529: x_rowid => X_ROWID
530: );
531: delete from IGS_PS_DIC_OCC_TITLS
532: where ROWID = X_ROWID;
533: if (sql%notfound) then
534: raise no_data_found;
535: end if;

Line 541: END igs_ps_dic_occ_titls_pkg;

537: p_action => 'DELETE',
538: x_rowid => X_ROWID
539: );
540: end DELETE_ROW;
541: END igs_ps_dic_occ_titls_pkg;