PACKAGE: APPS.IGS_GR_AWD_CEREMONY_PKG

Source

1 package IGS_GR_AWD_CEREMONY_PKG AUTHID CURRENT_USER as
2 /* $Header: IGSGI02S.pls 115.7 2003/06/09 03:38:34 smvk ship $ */
3 procedure INSERT_ROW (
4   X_ROWID in out NOCOPY VARCHAR2,
5   X_AWC_ID in out NOCOPY NUMBER,
6   X_GRD_CAL_TYPE in VARCHAR2,
7   X_GRD_CI_SEQUENCE_NUMBER in NUMBER,
8   X_CEREMONY_NUMBER in NUMBER,
9   X_AWARD_COURSE_CD in VARCHAR2,
10   X_AWARD_CRS_VERSION_NUMBER in NUMBER,
11   X_AWARD_CD in VARCHAR2,
12   X_ORDER_IN_CEREMONY in NUMBER,
13   X_CLOSED_IND in VARCHAR2,
14   X_MODE in VARCHAR2 default 'R' ,
15   X_ORG_ID  in NUMBER
16   );
17 procedure LOCK_ROW (
18   X_ROWID in VARCHAR2,
19   X_AWC_ID in NUMBER,
20   X_GRD_CAL_TYPE in VARCHAR2,
21   X_GRD_CI_SEQUENCE_NUMBER in NUMBER,
22   X_CEREMONY_NUMBER in NUMBER,
23   X_AWARD_COURSE_CD in VARCHAR2,
24   X_AWARD_CRS_VERSION_NUMBER in NUMBER,
25   X_AWARD_CD in VARCHAR2,
26   X_ORDER_IN_CEREMONY in NUMBER,
27   X_CLOSED_IND in VARCHAR2
28 
29 );
30 procedure UPDATE_ROW (
31   X_ROWID in VARCHAR2,
32   X_AWC_ID in NUMBER,
33   X_GRD_CAL_TYPE in VARCHAR2,
34   X_GRD_CI_SEQUENCE_NUMBER in NUMBER,
35   X_CEREMONY_NUMBER in NUMBER,
36   X_AWARD_COURSE_CD in VARCHAR2,
37   X_AWARD_CRS_VERSION_NUMBER in NUMBER,
38   X_AWARD_CD in VARCHAR2,
39   X_ORDER_IN_CEREMONY in NUMBER,
40   X_CLOSED_IND in VARCHAR2,
41   X_MODE in VARCHAR2 default 'R'
42 
43   );
44 procedure ADD_ROW (
45   X_ROWID in out NOCOPY VARCHAR2,
46   X_AWC_ID in out NOCOPY NUMBER,
47   X_GRD_CAL_TYPE in VARCHAR2,
48   X_GRD_CI_SEQUENCE_NUMBER in NUMBER,
49   X_CEREMONY_NUMBER in NUMBER,
50   X_AWARD_COURSE_CD in VARCHAR2,
51   X_AWARD_CRS_VERSION_NUMBER in NUMBER,
52   X_AWARD_CD in VARCHAR2,
53   X_ORDER_IN_CEREMONY in NUMBER,
54   X_CLOSED_IND in VARCHAR2,
55   X_MODE in VARCHAR2 default 'R',
56   X_ORG_ID  in NUMBER
57   );
58 procedure DELETE_ROW (
59   X_ROWID in VARCHAR2
60 );
61 
62   FUNCTION Get_PK_For_Validation (
63         x_AWC_ID IN NUMBER
64     ) RETURN BOOLEAN;
65 
66   FUNCTION Get_UK_For_Validation (
67         x_grd_cal_type IN VARCHAR2,
68         x_grd_ci_sequence_number IN NUMBER,
69         x_ceremony_number IN NUMBER,
70         x_award_course_cd IN VARCHAR2,
71         x_award_crs_version_number IN NUMBER,
72         x_award_cd IN VARCHAR2
73     ) RETURN BOOLEAN;
74 
75 
76   PROCEDURE GET_FK_IGS_GR_CRMN (
77     x_grd_cal_type IN VARCHAR2,
78     x_grd_ci_sequence_number IN NUMBER,
79     x_ceremony_number IN NUMBER
80     );
81 
82 PROCEDURE Before_DML (
83     p_action IN VARCHAR2,
84     x_rowid IN VARCHAR2 DEFAULT NULL,
85     x_AWC_ID IN NUMBER DEFAULT NULL,
86     x_grd_cal_type IN VARCHAR2 DEFAULT NULL,
87     x_grd_ci_sequence_number IN NUMBER DEFAULT NULL,
88     x_ceremony_number IN NUMBER DEFAULT NULL,
89     x_award_course_cd IN VARCHAR2 DEFAULT NULL,
90     x_award_crs_version_number IN NUMBER DEFAULT NULL,
91     x_award_cd IN VARCHAR2 DEFAULT NULL,
92     x_order_in_ceremony IN NUMBER DEFAULT NULL,
93     x_closed_ind IN VARCHAR2 DEFAULT NULL,
94     x_creation_date IN DATE DEFAULT NULL,
95     x_created_by IN NUMBER DEFAULT NULL,
96     x_last_update_date IN DATE DEFAULT NULL,
97     x_last_updated_by IN NUMBER DEFAULT NULL,
98     x_last_update_login IN NUMBER DEFAULT NULL,
99     X_ORG_ID  in NUMBER DEFAULT NULL
100   );
101 
102 PROCEDURE Check_Constraints(
103 	Column_Name IN VARCHAR2 DEFAULT NULL,
104 	Column_Value IN VARCHAR2 DEFAULT NULL
105 	);
106 
107 end IGS_GR_AWD_CEREMONY_PKG;