PACKAGE: APPS.IGS_GR_CRMN_ROUND_PKG

Source

1 PACKAGE igs_gr_crmn_round_pkg AUTHID CURRENT_USER AS
2 /* $Header: IGSGI07S.pls 115.7 2003/09/22 06:27:52 nalkumar ship $ */
3 PROCEDURE insert_row (
4   X_ROWID in out NOCOPY VARCHAR2,
5   X_GRD_CAL_TYPE in VARCHAR2,
6   X_GRD_CI_SEQUENCE_NUMBER in NUMBER,
7   X_START_DT_ALIAS in VARCHAR2,
8   X_START_DAI_SEQUENCE_NUMBER in NUMBER,
9   X_END_DT_ALIAS in VARCHAR2,
10   X_END_DAI_SEQUENCE_NUMBER in NUMBER,
11   X_MODE in VARCHAR2 default 'R' ,
12   X_ORG_ID  in NUMBER,
13   X_CONFERRAL_START_DATE   IN DATE DEFAULT NULL,
14   X_CONFERRAL_END_DATE     IN DATE DEFAULT NULL,
15   X_COMPLETION_START_DATE  IN DATE DEFAULT NULL,
16   X_COMPLETION_END_DATE    IN DATE DEFAULT NULL
17   );
18 
19 procedure LOCK_ROW (
20   X_ROWID in VARCHAR2,
21   X_GRD_CAL_TYPE in VARCHAR2,
22   X_GRD_CI_SEQUENCE_NUMBER in NUMBER,
23   X_START_DT_ALIAS in VARCHAR2,
24   X_START_DAI_SEQUENCE_NUMBER in NUMBER,
25   X_END_DT_ALIAS in VARCHAR2,
26   X_END_DAI_SEQUENCE_NUMBER IN NUMBER,
27   X_CONFERRAL_START_DATE    IN DATE,
28   X_CONFERRAL_END_DATE      IN DATE,
29   X_COMPLETION_START_DATE   IN DATE,
30   X_COMPLETION_END_DATE     IN DATE
31 );
32 
33 procedure UPDATE_ROW (
34   X_ROWID in VARCHAR2,
35   X_GRD_CAL_TYPE in VARCHAR2,
36   X_GRD_CI_SEQUENCE_NUMBER in NUMBER,
37   X_START_DT_ALIAS in VARCHAR2,
38   X_START_DAI_SEQUENCE_NUMBER in NUMBER,
39   X_END_DT_ALIAS in VARCHAR2,
40   X_END_DAI_SEQUENCE_NUMBER in NUMBER,
41   X_MODE                   IN VARCHAR2 default 'R',
42   X_CONFERRAL_START_DATE   IN DATE DEFAULT NULL,
43   X_CONFERRAL_END_DATE     IN DATE DEFAULT NULL,
44   X_COMPLETION_START_DATE  IN DATE DEFAULT NULL,
45   X_COMPLETION_END_DATE    IN DATE DEFAULT NULL
46   );
47 
48 procedure ADD_ROW (
49   X_ROWID in out NOCOPY VARCHAR2,
50   X_GRD_CAL_TYPE in VARCHAR2,
51   X_GRD_CI_SEQUENCE_NUMBER in NUMBER,
52   X_START_DT_ALIAS in VARCHAR2,
53   X_START_DAI_SEQUENCE_NUMBER in NUMBER,
54   X_END_DT_ALIAS in VARCHAR2,
55   X_END_DAI_SEQUENCE_NUMBER in NUMBER,
56   X_MODE in VARCHAR2 DEFAULT 'R',
57   X_ORG_ID                 IN NUMBER,
58   X_CONFERRAL_START_DATE   IN DATE DEFAULT NULL,
59   X_CONFERRAL_END_DATE     IN DATE DEFAULT NULL,
60   X_COMPLETION_START_DATE  IN DATE DEFAULT NULL,
61   X_COMPLETION_END_DATE    IN DATE DEFAULT NULL
62   );
63 
64   FUNCTION Get_PK_For_Validation (
65     x_grd_cal_type IN VARCHAR2,
66     x_grd_ci_sequence_number IN NUMBER
67     ) RETURN BOOLEAN;
68 
69   PROCEDURE GET_FK_IGS_CA_INST (
70     x_cal_type IN VARCHAR2,
71     x_sequence_number IN NUMBER
72     );
73 
74   PROCEDURE GET_FK_IGS_CA_DA_INST (
75     x_dt_alias IN VARCHAR2,
76     x_sequence_number IN NUMBER,
77     x_cal_type IN VARCHAR2,
78     x_ci_sequence_number IN NUMBER
79     );
80 
81 PROCEDURE Check_Constraints(
82   Column_Name IN VARCHAR2 DEFAULT NULL,
83   Column_Value IN VARCHAR2 DEFAULT NULL
84   );
85 
86   PROCEDURE Before_DML (
87     p_action IN VARCHAR2,
88     x_rowid IN VARCHAR2 DEFAULT NULL,
89     x_grd_cal_type IN VARCHAR2 DEFAULT NULL,
90     x_grd_ci_sequence_number IN NUMBER DEFAULT NULL,
91     x_start_dt_alias IN VARCHAR2 DEFAULT NULL,
92     x_start_dai_sequence_number IN NUMBER DEFAULT NULL,
93     x_end_dt_alias IN VARCHAR2 DEFAULT NULL,
94     x_end_dai_sequence_number IN NUMBER DEFAULT NULL,
95     x_creation_date IN DATE DEFAULT NULL,
96     x_created_by IN NUMBER DEFAULT NULL,
97     x_last_update_date IN DATE DEFAULT NULL,
98     x_last_updated_by IN NUMBER DEFAULT NULL,
99     x_last_update_login IN NUMBER DEFAULT NULL,
100     x_org_id                 IN NUMBER DEFAULT NULL,
101     x_conferral_start_date   IN DATE DEFAULT NULL,
102     x_conferral_end_date     IN DATE DEFAULT NULL,
103     x_completion_start_date  IN DATE DEFAULT NULL,
104     x_completion_end_date    IN DATE DEFAULT NULL
105   );
106 
107 END igs_gr_crmn_round_pkg;