PACKAGE: APPS.IGS_PR_S_OU_PRG_CAL_PKG

Source

1 package IGS_PR_S_OU_PRG_CAL_PKG AUTHID CURRENT_USER as
2 /* $Header: IGSQI23S.pls 115.3 2002/11/29 03:20:04 nsidana ship $ */
3 procedure INSERT_ROW (
4   X_ROWID in out NOCOPY VARCHAR2,
5   X_ORG_UNIT_CD in VARCHAR2,
6   X_OU_START_DT in DATE,
7   X_PRG_CAL_TYPE in VARCHAR2,
8   X_STREAM_NUM in NUMBER,
9   X_SHOW_CAUSE_LENGTH in NUMBER,
10   X_APPEAL_LENGTH in NUMBER,
11   X_MODE in VARCHAR2 default 'R'
12   );
13 procedure LOCK_ROW (
14   X_ROWID in VARCHAR2,
15   X_ORG_UNIT_CD in VARCHAR2,
16   X_OU_START_DT in DATE,
17   X_PRG_CAL_TYPE in VARCHAR2,
18   X_STREAM_NUM in NUMBER,
19   X_SHOW_CAUSE_LENGTH in NUMBER,
20   X_APPEAL_LENGTH in NUMBER
21 );
22 procedure UPDATE_ROW (
23   X_ROWID in VARCHAR2,
24   X_ORG_UNIT_CD in VARCHAR2,
25   X_OU_START_DT in DATE,
26   X_PRG_CAL_TYPE in VARCHAR2,
27   X_STREAM_NUM in NUMBER,
28   X_SHOW_CAUSE_LENGTH in NUMBER,
29   X_APPEAL_LENGTH in NUMBER,
30   X_MODE in VARCHAR2 default 'R'
31   );
32 procedure ADD_ROW (
33   X_ROWID in out NOCOPY VARCHAR2,
34   X_ORG_UNIT_CD in VARCHAR2,
35   X_OU_START_DT in DATE,
36   X_PRG_CAL_TYPE in VARCHAR2,
37   X_STREAM_NUM in NUMBER,
38   X_SHOW_CAUSE_LENGTH in NUMBER,
39   X_APPEAL_LENGTH in NUMBER,
40   X_MODE in VARCHAR2 default 'R'
41   );
42 procedure DELETE_ROW (
43   X_ROWID in VARCHAR2
44 );
45 
46   FUNCTION Get_PK_For_Validation (
47     x_org_unit_cd IN VARCHAR2,
48     x_ou_start_dt IN DATE,
49     x_prg_cal_type IN VARCHAR2
50     )
51   RETURN BOOLEAN;
52 
53   PROCEDURE GET_FK_IGS_CA_TYPE (
54     x_cal_type IN VARCHAR2
55     );
56 
57   PROCEDURE GET_FK_IGS_PR_S_OU_PRG_CONF (
58     x_org_unit_cd IN VARCHAR2,
59     x_ou_start_dt IN DATE
60     );
61 
62 PROCEDURE  Check_Constraints (
63     Column_Name IN VARCHAR2 DEFAULT NULL,
64     Column_Value IN VARCHAR2 DEFAULT NULL
65 );
66 
67   PROCEDURE Before_DML (
68     p_action IN VARCHAR2,
69     x_rowid IN VARCHAR2 DEFAULT NULL,
70     x_org_unit_cd IN VARCHAR2 DEFAULT NULL,
71     x_ou_start_dt IN DATE DEFAULT NULL,
72     x_prg_cal_type IN VARCHAR2 DEFAULT NULL,
73     x_stream_num IN NUMBER DEFAULT NULL,
74     x_show_cause_length IN NUMBER DEFAULT NULL,
75     x_appeal_length IN NUMBER DEFAULT NULL,
76     x_creation_date IN DATE DEFAULT NULL,
77     x_created_by IN NUMBER DEFAULT NULL,
78     x_last_update_date IN DATE DEFAULT NULL,
79     x_last_updated_by IN NUMBER DEFAULT NULL,
80     x_last_update_login IN NUMBER DEFAULT NULL
81   );
82 end IGS_PR_S_OU_PRG_CAL_PKG;