PACKAGE: APPS.IGS_PS_DIC_OCC_TITLS_PKG

Source

1 PACKAGE igs_ps_dic_occ_titls_pkg AUTHID CURRENT_USER AS
2 /* $Header: IGSPI0ES.pls 115.6 2002/11/29 01:56:08 nsidana ship $ */
3  procedure INSERT_ROW (
4       X_ROWID in out NOCOPY VARCHAR2,
5        x_OCCUPATIONAL_TITLE_CODE IN VARCHAR2,
6        x_OCCUPATIONAL_TITLE IN VARCHAR2,
7        x_ALTERNATE_TITLE IN VARCHAR2,
8       X_MODE in VARCHAR2 default 'R'
9   );
10 
11  procedure LOCK_ROW (
12       X_ROWID in  VARCHAR2,
13        x_OCCUPATIONAL_TITLE_CODE IN VARCHAR2,
14        x_OCCUPATIONAL_TITLE IN VARCHAR2,
15        x_ALTERNATE_TITLE IN VARCHAR2  );
16  procedure UPDATE_ROW (
17       X_ROWID in  VARCHAR2,
18        x_OCCUPATIONAL_TITLE_CODE IN VARCHAR2,
19        x_OCCUPATIONAL_TITLE IN VARCHAR2,
20        x_ALTERNATE_TITLE IN VARCHAR2,
21       X_MODE in VARCHAR2 default 'R'
22   );
23 
24  procedure ADD_ROW (
25       X_ROWID in out NOCOPY VARCHAR2,
26        x_OCCUPATIONAL_TITLE_CODE IN VARCHAR2,
27        x_OCCUPATIONAL_TITLE IN VARCHAR2,
28        x_ALTERNATE_TITLE IN VARCHAR2,
29       X_MODE in VARCHAR2 default 'R'
30   ) ;
31 
32 procedure DELETE_ROW (
33   X_ROWID in VARCHAR2
34 ) ;
35   FUNCTION Get_PK_For_Validation (
36     x_occupational_title_code IN VARCHAR2
37     ) RETURN BOOLEAN ;
38 
39   PROCEDURE Check_Constraints (
40 		 Column_Name IN VARCHAR2  DEFAULT NULL,
41 		 Column_Value IN VARCHAR2  DEFAULT NULL ) ;
42   PROCEDURE Before_DML (
43     p_action IN VARCHAR2,
44     x_rowid IN VARCHAR2 DEFAULT NULL,
45     x_occupational_title_code IN VARCHAR2 DEFAULT NULL,
46     x_occupational_title IN VARCHAR2 DEFAULT NULL,
47     x_alternate_title IN VARCHAR2 DEFAULT NULL,
48     x_creation_date IN DATE DEFAULT NULL,
49     x_created_by IN NUMBER DEFAULT NULL,
50     x_last_update_date IN DATE DEFAULT NULL,
51     x_last_updated_by IN NUMBER DEFAULT NULL,
52     x_last_update_login IN NUMBER DEFAULT NULL
53  );
54 END igs_ps_dic_occ_titls_pkg;