1 package IGS_PS_NOTE_TYPE_PKG AS
2 /* $Header: IGSPI48S.pls 120.1 2006/01/27 02:51:50 sarakshi noship $ */
3
4 procedure INSERT_ROW (
5 X_ROWID in out NOCOPY VARCHAR2,
6 X_CRS_NOTE_TYPE in VARCHAR2,
7 X_DESCRIPTION in VARCHAR2,
8 X_MODE in VARCHAR2 default 'R',
9 X_ORG_ID IN NUMBER
10 );
11 procedure LOCK_ROW (
12 X_ROWID in VARCHAR2,
13 X_CRS_NOTE_TYPE in VARCHAR2,
14 X_DESCRIPTION in VARCHAR2
15 );
16 procedure UPDATE_ROW (
17 X_ROWID in VARCHAR2,
18 X_CRS_NOTE_TYPE in VARCHAR2,
19 X_DESCRIPTION in VARCHAR2,
20 X_MODE in VARCHAR2 default 'R'
21 );
22 procedure ADD_ROW (
23 X_ROWID in out NOCOPY VARCHAR2,
24 X_CRS_NOTE_TYPE in VARCHAR2,
25 X_DESCRIPTION in VARCHAR2,
26 X_MODE in VARCHAR2 default 'R',
27 X_ORG_ID IN NUMBER
28 );
29 procedure DELETE_ROW (
30 X_ROWID in VARCHAR2
31 );
32 FUNCTION Get_PK_For_Validation (
33 x_crs_note_type IN VARCHAR2
34 )RETURN BOOLEAN;
35
36 PROCEDURE CHECK_CONSTRAINTS (
37 Column_Name IN VARCHAR2 DEFAULT NULL,
38 Column_Value IN VARCHAR2 DEFAULT NULL
39 );
40 PROCEDURE Before_DML (
41 p_action IN VARCHAR2,
42 x_rowid IN VARCHAR2 DEFAULT NULL,
43 x_crs_note_type IN VARCHAR2 DEFAULT NULL,
44 x_description IN VARCHAR2 DEFAULT NULL,
45 x_creation_date IN DATE DEFAULT NULL,
46 x_created_by IN NUMBER DEFAULT NULL,
47 x_last_update_date IN DATE DEFAULT NULL,
48 x_last_updated_by IN NUMBER DEFAULT NULL,
49 x_last_update_login IN NUMBER DEFAULT NULL,
50 X_ORG_ID IN NUMBER DEFAULT NULL
51 ) ;
52
53 PROCEDURE LOAD_ROW (
54 x_crs_note_type IN VARCHAR2,
55 x_description IN VARCHAR2,
56 x_owner IN VARCHAR2,
57 x_last_update_date IN VARCHAR2,
58 x_custom_mode IN VARCHAR2
59 );
60
61 PROCEDURE LOAD_SEED_ROW (
62 x_upload_mode IN VARCHAR2, -- an extra parameter to distinguish NLS and non-NLS upload
63 x_crs_note_type IN VARCHAR2,
64 x_description IN VARCHAR2,
65 x_owner IN VARCHAR2,
66 x_last_update_date IN VARCHAR2,
67 x_custom_mode IN VARCHAR2
68 );
69
70 end IGS_PS_NOTE_TYPE_PKG;