PACKAGE: APPS.IGS_PS_UOFR_WLST_PRI_PKG

Source

1 PACKAGE igs_ps_uofr_wlst_pri_pkg AUTHID CURRENT_USER AS
2 /* $Header: IGSPI96S.pls 115.7 2003/12/05 13:22:22 sarakshi ship $ */
3  procedure INSERT_ROW (
4       X_ROWID in out NOCOPY VARCHAR2,
5        x_UNIT_OFR_WL_PRIORITY_ID IN OUT NOCOPY NUMBER,
6        x_UNIT_CD IN VARCHAR2,
7        x_VERSION_NUMBER IN NUMBER,
8        x_CALENDER_TYPE IN VARCHAR2,
9        x_CI_SEQUENCE_NUMBER IN NUMBER,
10        x_PRIORITY_NUMBER IN NUMBER,
11        x_PRIORITY_VALUE IN VARCHAR2,
12       X_MODE in VARCHAR2 default 'R'
13   );
14 
15  procedure LOCK_ROW (
16       X_ROWID in  VARCHAR2,
17        x_UNIT_OFR_WL_PRIORITY_ID IN NUMBER,
18        x_UNIT_CD IN VARCHAR2,
19        x_VERSION_NUMBER IN NUMBER,
20        x_CALENDER_TYPE IN VARCHAR2,
21        x_CI_SEQUENCE_NUMBER IN NUMBER,
22        x_PRIORITY_NUMBER IN NUMBER,
23        x_PRIORITY_VALUE IN VARCHAR2  );
24  procedure UPDATE_ROW (
25       X_ROWID in  VARCHAR2,
26        x_UNIT_OFR_WL_PRIORITY_ID IN NUMBER,
27        x_UNIT_CD IN VARCHAR2,
28        x_VERSION_NUMBER IN NUMBER,
29        x_CALENDER_TYPE IN VARCHAR2,
30        x_CI_SEQUENCE_NUMBER IN NUMBER,
31        x_PRIORITY_NUMBER IN NUMBER,
32        x_PRIORITY_VALUE IN VARCHAR2,
33       X_MODE in VARCHAR2 default 'R'
34   );
35 
36  procedure ADD_ROW (
37       X_ROWID in out NOCOPY VARCHAR2,
38        x_UNIT_OFR_WL_PRIORITY_ID IN OUT NOCOPY NUMBER,
39        x_UNIT_CD IN VARCHAR2,
40        x_VERSION_NUMBER IN NUMBER,
41        x_CALENDER_TYPE IN VARCHAR2,
42        x_CI_SEQUENCE_NUMBER IN NUMBER,
43        x_PRIORITY_NUMBER IN NUMBER,
44        x_PRIORITY_VALUE IN VARCHAR2,
45       X_MODE in VARCHAR2 default 'R'
46   ) ;
47 
48 procedure DELETE_ROW (
49   X_ROWID in VARCHAR2
50 ) ;
51   FUNCTION Get_PK_For_Validation (
52     x_unit_ofr_wl_priority_id IN NUMBER
53     ) RETURN BOOLEAN ;
54 
55   FUNCTION Get_UK_For_Validation (
56     x_calender_type IN VARCHAR2,
57     x_ci_sequence_number IN NUMBER,
58     x_priority_value IN VARCHAR2,
59     x_unit_cd IN VARCHAR2,
60     x_version_number IN NUMBER
61     ) RETURN BOOLEAN;
62 
63   PROCEDURE Get_FK_Igs_Ps_Unit_Ofr_Pat (
64     x_unit_cd IN VARCHAR2,
65     x_version_number IN NUMBER,
66     x_cal_type IN VARCHAR2,
67     x_ci_sequence_number IN NUMBER
68     );
69 
70   PROCEDURE Check_Constraints (
71 		 Column_Name IN VARCHAR2  DEFAULT NULL,
72 		 Column_Value IN VARCHAR2  DEFAULT NULL ) ;
73   PROCEDURE Before_DML (
74     p_action IN VARCHAR2,
75     x_rowid IN VARCHAR2 DEFAULT NULL,
76     x_unit_ofr_wl_priority_id IN NUMBER DEFAULT NULL,
77     x_unit_cd IN VARCHAR2 DEFAULT NULL,
78     x_version_number IN NUMBER DEFAULT NULL,
79     x_calender_type IN VARCHAR2 DEFAULT NULL,
80     x_ci_sequence_number IN NUMBER DEFAULT NULL,
81     x_priority_number IN NUMBER DEFAULT NULL,
82     x_priority_value IN VARCHAR2 DEFAULT NULL,
83     x_creation_date IN DATE DEFAULT NULL,
84     x_created_by IN NUMBER DEFAULT NULL,
85     x_last_update_date IN DATE DEFAULT NULL,
86     x_last_updated_by IN NUMBER DEFAULT NULL,
87     x_last_update_login IN NUMBER DEFAULT NULL
88  );
89 END igs_ps_uofr_wlst_pri_pkg;