PACKAGE: APPS.IGS_AS_CAL_CONF_PKG

Source

1 package IGS_AS_CAL_CONF_PKG AUTHID CURRENT_USER as
2 /* $Header: IGSDI45S.pls 115.6 2002/11/28 23:21:57 nsidana ship $ */
3 
4 procedure INSERT_ROW (
5   X_ROWID in out NOCOPY VARCHAR2,
6   X_S_CONTROL_NUM in  NUMBER,
7   X_ASS_ITEM_CUTOFF_DT_ALIAS in VARCHAR2,
8   X_MID_MGS_START_DT_ALIAS    in VARCHAR2,
9   X_MID_MGS_END_DT_ALIAS      in VARCHAR2,
10   X_EFINAL_MGS_START_DT_ALIAS in VARCHAR2,
11   X_EFINAL_MGS_END_DT_ALIAS   in VARCHAR2,
12   X_FINAL_MGS_START_DT_ALIAS  in VARCHAR2,
13   X_FINAL_MGS_END_DT_ALIAS    in VARCHAR2,
14   X_MODE in VARCHAR2 default 'R'
15   );
16 procedure LOCK_ROW (
17   X_ROWID in VARCHAR2,
18   X_S_CONTROL_NUM in NUMBER,
19   X_ASS_ITEM_CUTOFF_DT_ALIAS in VARCHAR2,
20   X_MID_MGS_START_DT_ALIAS    in VARCHAR2,
21   X_MID_MGS_END_DT_ALIAS      in VARCHAR2,
22   X_EFINAL_MGS_START_DT_ALIAS in VARCHAR2,
23   X_EFINAL_MGS_END_DT_ALIAS   in VARCHAR2,
24   X_FINAL_MGS_START_DT_ALIAS  in VARCHAR2,
25   X_FINAL_MGS_END_DT_ALIAS    in VARCHAR2
26 
27 );
28 procedure UPDATE_ROW (
29   X_ROWID in VARCHAR2,
30   X_S_CONTROL_NUM in NUMBER,
31   X_ASS_ITEM_CUTOFF_DT_ALIAS in VARCHAR2,
32   X_MID_MGS_START_DT_ALIAS    in VARCHAR2,
33   X_MID_MGS_END_DT_ALIAS      in VARCHAR2,
34   X_EFINAL_MGS_START_DT_ALIAS in VARCHAR2,
35   X_EFINAL_MGS_END_DT_ALIAS   in VARCHAR2,
36   X_FINAL_MGS_START_DT_ALIAS  in VARCHAR2,
37   X_FINAL_MGS_END_DT_ALIAS    in VARCHAR2,
38   X_MODE in VARCHAR2 default 'R'
39   );
40 procedure ADD_ROW (
41   X_ROWID in out NOCOPY VARCHAR2,
42   X_S_CONTROL_NUM in  NUMBER,
43   X_ASS_ITEM_CUTOFF_DT_ALIAS in VARCHAR2,
44   X_MID_MGS_START_DT_ALIAS    in VARCHAR2,
45   X_MID_MGS_END_DT_ALIAS      in VARCHAR2,
46   X_EFINAL_MGS_START_DT_ALIAS in VARCHAR2,
47   X_EFINAL_MGS_END_DT_ALIAS   in VARCHAR2,
48   X_FINAL_MGS_START_DT_ALIAS  in VARCHAR2,
49   X_FINAL_MGS_END_DT_ALIAS    in VARCHAR2,
50   X_MODE in VARCHAR2 default 'R'
51   );
52 procedure DELETE_ROW (
53   X_ROWID in VARCHAR2
54 );
55 FUNCTION Get_PK_For_Validation (
56     x_s_control_num IN NUMBER
57     ) RETURN BOOLEAN;
58 
59   PROCEDURE GET_FK_IGS_CA_DA (
60     x_dt_alias IN VARCHAR2
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_s_control_num IN NUMBER DEFAULT NULL,
71     x_ass_item_cutoff_dt_alias IN VARCHAR2 DEFAULT NULL,
72     x_mid_mgs_start_dt_alias    IN VARCHAR2 DEFAULT NULL ,
73     x_mid_mgs_end_dt_alias      IN VARCHAR2 DEFAULT NULL ,
74     x_efinal_mgs_start_dt_alias IN VARCHAR2 DEFAULT NULL ,
75     x_efinal_mgs_end_dt_alias   IN VARCHAR2 DEFAULT NULL ,
76     x_final_mgs_start_dt_alias  IN VARCHAR2 DEFAULT NULL ,
77     x_final_mgs_end_dt_alias    IN VARCHAR2 DEFAULT NULL ,
78     x_creation_date IN DATE DEFAULT NULL,
79     x_created_by IN NUMBER DEFAULT NULL,
80     x_last_update_date IN DATE DEFAULT NULL,
81     x_last_updated_by IN NUMBER DEFAULT NULL,
82     x_last_update_login IN NUMBER DEFAULT NULL
83   ) ;
84 end IGS_AS_CAL_CONF_PKG;