PACKAGE: APPS.IGS_GE_S_ERROR_LOG_PKG

Source

1 package IGS_GE_S_ERROR_LOG_PKG AUTHID CURRENT_USER as
2 /* $Header: IGSMI07S.pls 115.3 2002/11/29 01:10:49 nsidana ship $ */
3 
4 procedure INSERT_ROW (
5   X_ROWID in out NOCOPY VARCHAR2,
6   X_SEQUENCE_NUMBER in NUMBER,
7   X_PROGRAM_UNIT in VARCHAR2,
8   X_SQL_ERROR_NUM in NUMBER,
9   X_SQL_ERROR_MESSAGE in VARCHAR2,
10   X_OTHER_DETAIL in VARCHAR2,
11   x_creation_date IN DATE ,
12   x_created_by IN NUMBER ,
13   X_LAST_UPDATE_DATE IN DATE ,
14   X_LAST_UPDATED_BY IN NUMBER ,
15   X_LAST_UPDATE_LOGIN IN NUMBER ,
16   X_REQUEST_ID IN NUMBER ,
17   X_PROGRAM_ID IN NUMBER ,
18   X_PROGRAM_APPLICATION_ID IN NUMBER ,
19   X_PROGRAM_UPDATE_DATE IN DATE ,
20 
21   X_MODE in VARCHAR2 default 'R'
22   );
23 procedure LOCK_ROW (
24   X_ROWID in VARCHAR2,
25   X_SEQUENCE_NUMBER in NUMBER,
26   X_PROGRAM_UNIT in VARCHAR2,
27   X_SQL_ERROR_NUM in NUMBER,
28   X_SQL_ERROR_MESSAGE in VARCHAR2,
29   X_OTHER_DETAIL in VARCHAR2
30 );
31 procedure UPDATE_ROW (
32   X_ROWID in VARCHAR2,
33   X_SEQUENCE_NUMBER in NUMBER,
34   X_PROGRAM_UNIT in VARCHAR2,
35   X_SQL_ERROR_NUM in NUMBER,
36   X_SQL_ERROR_MESSAGE in VARCHAR2,
37   X_OTHER_DETAIL in VARCHAR2,
38   x_creation_date IN DATE ,
39   x_created_by IN NUMBER ,
40   X_LAST_UPDATE_DATE IN DATE ,
41   X_LAST_UPDATED_BY IN NUMBER ,
42   X_LAST_UPDATE_LOGIN IN NUMBER ,
43   X_REQUEST_ID IN NUMBER ,
44   X_PROGRAM_ID IN NUMBER ,
45   X_PROGRAM_APPLICATION_ID IN NUMBER ,
46   X_PROGRAM_UPDATE_DATE IN DATE ,
47   X_MODE in VARCHAR2 default 'R'
48   );
49 procedure ADD_ROW (
50   X_ROWID in out NOCOPY VARCHAR2,
51   X_SEQUENCE_NUMBER in NUMBER,
52   X_PROGRAM_UNIT in VARCHAR2,
53   X_SQL_ERROR_NUM in NUMBER,
54   X_SQL_ERROR_MESSAGE in VARCHAR2,
55   X_OTHER_DETAIL in VARCHAR2,
56   x_creation_date IN DATE ,
57   x_created_by IN NUMBER ,
58   X_LAST_UPDATE_DATE IN DATE ,
59   X_LAST_UPDATED_BY IN NUMBER ,
60   X_LAST_UPDATE_LOGIN IN NUMBER ,
61   X_REQUEST_ID IN NUMBER ,
62   X_PROGRAM_ID IN NUMBER ,
63   X_PROGRAM_APPLICATION_ID IN NUMBER ,
64   X_PROGRAM_UPDATE_DATE IN DATE ,
65 
66   X_MODE in VARCHAR2 default 'R'
67   );
68 procedure DELETE_ROW (
69   X_ROWID in VARCHAR2
70 );
71 FUNCTION GET_PK_FOR_VALIDATION (
72     x_sequence_number IN NUMBER
73 )RETURN BOOLEAN ;
74 
75   PROCEDURE Before_DML (
76     p_action IN VARCHAR2,
77     x_rowid IN VARCHAR2 DEFAULT NULL,
78     x_sequence_number IN NUMBER DEFAULT NULL,
79     x_program_unit IN VARCHAR2 DEFAULT NULL,
80     x_sql_error_num IN NUMBER DEFAULT NULL,
81     x_sql_error_message IN VARCHAR2 DEFAULT NULL,
82     x_other_detail IN VARCHAR2 DEFAULT NULL,
83     x_creation_date IN DATE DEFAULT NULL,
84     x_created_by IN NUMBER DEFAULT NULL,
85     x_last_update_date IN DATE DEFAULT NULL,
86     x_last_updated_by IN NUMBER DEFAULT NULL,
87     x_last_update_login IN NUMBER DEFAULT NULL
88   ) ;
89 
90 end IGS_GE_S_ERROR_LOG_PKG;