PACKAGE: APPS.IGS_PS_OCCUP_TITLES_PKG

Source

1 PACKAGE igs_ps_occup_titles_pkg AUTHID CURRENT_USER AS
2 /* $Header: IGSPI0FS.pls 115.7 2002/11/29 01:56:26 nsidana ship $ */
3  procedure INSERT_ROW (
4       X_ROWID in out NOCOPY VARCHAR2,
5        x_PRGM_OCCUPATIONAL_TITLE_ID IN OUT NOCOPY NUMBER,
6        x_PROGRAM_CODE IN VARCHAR2,
7        x_OCCUPATIONAL_TITLE_CODE IN VARCHAR2,
8       X_MODE in VARCHAR2 default 'R'  ,
9       X_ORG_ID IN NUMBER
10   );
11 
12  procedure LOCK_ROW (
13       X_ROWID in  VARCHAR2,
14        x_PRGM_OCCUPATIONAL_TITLE_ID IN NUMBER,
15        x_PROGRAM_CODE IN VARCHAR2,
16        x_OCCUPATIONAL_TITLE_CODE IN VARCHAR2
17        );
18  procedure UPDATE_ROW (
19       X_ROWID in  VARCHAR2,
20        x_PRGM_OCCUPATIONAL_TITLE_ID IN NUMBER,
21        x_PROGRAM_CODE IN VARCHAR2,
22        x_OCCUPATIONAL_TITLE_CODE IN VARCHAR2,
23       X_MODE in VARCHAR2 default 'R'
24   );
25 
26  procedure ADD_ROW (
27       X_ROWID in out NOCOPY VARCHAR2,
28        x_PRGM_OCCUPATIONAL_TITLE_ID IN OUT NOCOPY NUMBER,
29        x_PROGRAM_CODE IN VARCHAR2,
30        x_OCCUPATIONAL_TITLE_CODE IN VARCHAR2,
31       X_MODE in VARCHAR2 default 'R'  ,
32       X_ORG_ID IN NUMBER
33   ) ;
34 
35 procedure DELETE_ROW (
36   X_ROWID in VARCHAR2
37 ) ;
38   FUNCTION Get_PK_For_Validation (
39     x_prgm_occupational_title_id IN NUMBER
40     ) RETURN BOOLEAN ;
41 
42   FUNCTION Get_UK_For_Validation (
43     x_occupational_title_code IN VARCHAR2,
44     x_program_code IN VARCHAR2
45     ) RETURN BOOLEAN;
46 
47   PROCEDURE Get_FK_Igs_Ps_Dic_Occ_Titls (
48     x_occupational_title_code IN VARCHAR2
49     );
50 
51 
52 PROCEDURE Get_Fk_Igs_Ps_Ver(
53     x_program_code IN VARCHAR2
54     );
55 
56   PROCEDURE Check_Constraints (
57 		 Column_Name IN VARCHAR2  DEFAULT NULL,
58 		 Column_Value IN VARCHAR2  DEFAULT NULL ) ;
59   PROCEDURE Before_DML (
60     p_action IN VARCHAR2,
61     x_rowid IN VARCHAR2 DEFAULT NULL,
62     x_prgm_occupational_title_id IN NUMBER DEFAULT NULL,
63     x_program_code IN VARCHAR2 DEFAULT NULL,
64     x_occupational_title_code IN VARCHAR2 DEFAULT NULL,
65     x_creation_date IN DATE DEFAULT NULL,
66     x_created_by IN NUMBER DEFAULT NULL,
67     x_last_update_date IN DATE DEFAULT NULL,
68     x_last_updated_by IN NUMBER DEFAULT NULL,
69     x_last_update_login IN NUMBER DEFAULT NULL,
70       X_ORG_ID IN NUMBER DEFAULT NULL
71  );
72 END igs_ps_occup_titles_pkg;