PACKAGE: APPS.IGS_EN_METHOD_TYPE_PKG

Source

1 package  IGS_EN_METHOD_TYPE_PKG as
2 /* $Header: IGSEI07S.pls 120.0 2005/06/01 13:54:40 appldev noship $ */
3 procedure INSERT_ROW (
4   X_ROWID		IN out NOCOPY VARCHAR2,
5   X_ENR_METHOD_TYPE	IN VARCHAR2,
6   X_DESCRIPTION		IN VARCHAR2,
7   X_CLOSED_IND		IN VARCHAR2,
8   X_MODE		IN VARCHAR2 DEFAULT 'R',
9   X_SELF_SERVICE	IN VARCHAR2 ,
10   X_IVR_DISPLAY_IND	IN VARCHAR2 DEFAULT 'N',
11   X_BULK_JOB_IND        IN VARCHAR2 DEFAULT 'N',
12   X_TRANSFER_FLAG       IN VARCHAR2 DEFAULT 'N',
13   X_DFLT_TRANS_DETAILS_FLAG  IN VARCHAR2 DEFAULT 'N'
14   );
15 procedure LOCK_ROW (
16   X_ROWID		IN VARCHAR2,
17   X_ENR_METHOD_TYPE	IN VARCHAR2,
18   X_DESCRIPTION		IN VARCHAR2,
19   X_CLOSED_IND		IN VARCHAR2,
20   X_SELF_SERVICE	IN VARCHAR2,
21   X_IVR_DISPLAY_IND	IN VARCHAR2 DEFAULT 'N',
22   X_BULK_JOB_IND        IN VARCHAR2 DEFAULT 'N',
23   X_TRANSFER_FLAG       IN VARCHAR2 DEFAULT 'N',
24   X_DFLT_TRANS_DETAILS_FLAG  IN VARCHAR2 DEFAULT 'N'
25 );
26 procedure UPDATE_ROW (
27   X_ROWID		IN VARCHAR2,
28   X_ENR_METHOD_TYPE	IN VARCHAR2,
29   X_DESCRIPTION		IN VARCHAR2,
30   X_CLOSED_IND		IN VARCHAR2,
31   X_MODE		IN VARCHAR2 DEFAULT 'R',
32   X_SELF_SERVICE	IN VARCHAR2  ,
33   X_IVR_DISPLAY_IND	IN VARCHAR2 DEFAULT 'N',
34   X_BULK_JOB_IND        IN VARCHAR2 DEFAULT 'N',
35   X_TRANSFER_FLAG       IN VARCHAR2 DEFAULT 'N',
36   X_DFLT_TRANS_DETAILS_FLAG  IN VARCHAR2 DEFAULT 'N'
37   );
38 procedure ADD_ROW (
39   X_ROWID		IN OUT NOCOPY VARCHAR2,
40   X_ENR_METHOD_TYPE	IN VARCHAR2,
41   X_DESCRIPTION		IN VARCHAR2,
42   X_CLOSED_IND		IN VARCHAR2,
43   X_MODE		IN VARCHAR2 DEFAULT 'R',
44   X_SELF_SERVICE	IN VARCHAR2  ,
45   X_IVR_DISPLAY_IND	IN VARCHAR2 DEFAULT 'N',
46   X_BULK_JOB_IND        IN VARCHAR2 DEFAULT 'N',
47   X_TRANSFER_FLAG       IN VARCHAR2 DEFAULT 'N',
48   X_DFLT_TRANS_DETAILS_FLAG  IN VARCHAR2 DEFAULT 'N'
49   );
50 procedure DELETE_ROW (
51   X_ROWID in VARCHAR2
52 );
53 
54 FUNCTION Get_PK_For_Validation (
55     x_enr_method_type IN VARCHAR2
56     ) RETURN BOOLEAN;
57 
58  PROCEDURE Check_Constraints (
59  Column_Name	IN	VARCHAR2	DEFAULT NULL,
60  Column_Value 	IN	VARCHAR2	DEFAULT NULL
61  );
62 PROCEDURE Before_DML (
63     p_action		IN VARCHAR2,
64     x_rowid		IN VARCHAR2 DEFAULT NULL,
65     x_enr_method_type	IN VARCHAR2 DEFAULT NULL,
66     x_description	IN VARCHAR2 DEFAULT NULL,
67     x_closed_ind	IN VARCHAR2 DEFAULT NULL,
68     x_creation_date	IN DATE	    DEFAULT NULL,
69     x_created_by	IN NUMBER   DEFAULT NULL,
70     x_last_update_date	IN DATE     DEFAULT NULL,
71     x_last_updated_by	IN NUMBER   DEFAULT NULL,
72     x_last_update_login IN NUMBER   DEFAULT NULL,
73     x_self_service	IN VARCHAR2 DEFAULT NULL ,
74     x_ivr_display_ind	IN VARCHAR2 DEFAULT NULL,
75     x_bulk_job_ind      IN VARCHAR2 DEFAULT NULL,
76     x_transfer_flag     IN VARCHAR2 DEFAULT NULL,
77     x_dflt_trans_details_flag  IN VARCHAR2 DEFAULT NULL
78   );
79 END igs_en_method_type_pkg;