PACKAGE: APPS.IGS_EN_DCNT_REASONCD_PKG

Source

1 package  IGS_EN_DCNT_REASONCD_PKG AS
2 /* $Header: IGSEI20S.pls 120.1 2005/09/08 14:48:39 appldev noship $ */
3 procedure INSERT_ROW (
4   X_ROWID in out NOCOPY VARCHAR2,
5   X_ORG_ID in NUMBER,
6   X_DISCONTINUATION_REASON_CD in VARCHAR2,
7   X_DESCRIPTION in VARCHAR2,
8   X_DFLT_IND in VARCHAR2,
9   X_DCNT_PROGRAM_IND VARCHAR2,
10   X_DCNT_UNIT_IND VARCHAR2,
11   X_S_DCNT_REASON_TYP in VARCHAR2,
12   X_SYS_DFLT_IND in VARCHAR2,
13   X_CLOSED_IND in VARCHAR2,
14   X_COMMENTS in VARCHAR2,
15   X_MODE in VARCHAR2 default 'R'
16   );
17 procedure LOCK_ROW (
18   X_ROWID in VARCHAR2,
19   X_DISCONTINUATION_REASON_CD in VARCHAR2,
20   X_DESCRIPTION in VARCHAR2,
21   X_DFLT_IND in VARCHAR2,
22   X_DCNT_PROGRAM_IND VARCHAR2,
23   X_DCNT_UNIT_IND VARCHAR2,
24   X_S_DCNT_REASON_TYP in VARCHAR2,
25   X_SYS_DFLT_IND in VARCHAR2,
26   X_CLOSED_IND in VARCHAR2,
27   X_COMMENTS in VARCHAR2
28 );
29 procedure UPDATE_ROW (
30   X_ROWID in VARCHAR2,
31   X_DISCONTINUATION_REASON_CD in VARCHAR2,
32   X_DESCRIPTION in VARCHAR2,
33   X_DFLT_IND in VARCHAR2,
34   X_DCNT_PROGRAM_IND VARCHAR2,
35   X_DCNT_UNIT_IND VARCHAR2,
36   X_S_DCNT_REASON_TYP in VARCHAR2,
37   X_SYS_DFLT_IND in VARCHAR2,
38   X_CLOSED_IND in VARCHAR2,
39   X_COMMENTS in VARCHAR2,
40   X_MODE in VARCHAR2 default 'R'
41   );
42 procedure ADD_ROW (
43   X_ROWID in out NOCOPY VARCHAR2,
44   X_ORG_ID in NUMBER,
45   X_DISCONTINUATION_REASON_CD in VARCHAR2,
46   X_DESCRIPTION in VARCHAR2,
47   X_DFLT_IND in VARCHAR2,
48   X_DCNT_PROGRAM_IND VARCHAR2,
49   X_DCNT_UNIT_IND VARCHAR2,
50   X_S_DCNT_REASON_TYP in VARCHAR2,
51   X_SYS_DFLT_IND in VARCHAR2,
52   X_CLOSED_IND in VARCHAR2,
53   X_COMMENTS in VARCHAR2,
54   X_MODE in VARCHAR2 default 'R'
55   );
56 
57 
58 FUNCTION Get_PK_For_Validation (
59   x_dcnt_reason_cd IN VARCHAR2
60 )
61 RETURN BOOLEAN ;
62 PROCEDURE GET_FK_IGS_LOOKUPS_VIEW (
63   x_s_dcnt_reason_type IN VARCHAR2
64 );
65 procedure Check_constraints(
66 	column_name IN VARCHAR2 DEFAULT NULL,
67 	column_value IN VARCHAR2 DEFAULT NULL
68    );
69 PROCEDURE Before_DML (
70   p_action IN VARCHAR2,
71   x_rowid IN VARCHAR2 DEFAULT NULL,
72   X_ORG_ID in NUMBER DEFAULT NULL,
73   x_discontinuation_reason_cd IN VARCHAR2 DEFAULT NULL,
74   x_description IN VARCHAR2 DEFAULT NULL,
75   x_dflt_ind IN VARCHAR2 DEFAULT NULL,
76   X_DCNT_PROGRAM_IND VARCHAR2 DEFAULT NULL,
77   X_DCNT_UNIT_IND VARCHAR2 DEFAULT NULL,
78   x_s_dcnt_reason_type IN VARCHAR2 DEFAULT NULL,
79   x_sys_dflt_ind IN VARCHAR2 DEFAULT NULL,
80   x_closed_ind IN VARCHAR2 DEFAULT NULL,
81   x_comments IN VARCHAR2 DEFAULT NULL,
82   x_creation_date IN DATE DEFAULT NULL,
83   x_created_by IN NUMBER DEFAULT NULL,
84   x_last_update_date IN DATE DEFAULT NULL,
85   x_last_updated_by IN NUMBER DEFAULT NULL,
86   x_last_update_login IN NUMBER DEFAULT NULL
87   );
88 
89 END IGS_EN_DCNT_REASONCD_PKG;