PACKAGE: APPS.IGS_AD_SYSSRC_CAT_PKG

Source

1 PACKAGE igs_ad_syssrc_cat_pkg AUTHID CURRENT_USER AS
2 /* $Header: IGSAI72S.pls 115.9 2003/10/30 13:16:34 akadam ship $ */
3  procedure INSERT_ROW (
4       X_ROWID in out NOCOPY VARCHAR2,
5        x_SYSTEM_SOURCE_TYPE IN VARCHAR2,
6        x_CATEGORY_NAME IN VARCHAR2,
7        x_MANDATORY_IND IN VARCHAR2,
8        x_SS_IND IN VARCHAR2,
9        x_DISPLAY_SEQUENCE IN NUMBER,
10        x_AD_TAB_NAME   IN  VARCHAR2 DEFAULT NULL,
11        x_INT_TAB_NAME  IN  VARCHAR2 DEFAULT NULL,
12       X_MODE in VARCHAR2 default 'R',
13       X_CLOSED_IND IN VARCHAR2 DEFAULT 'N'
14   );
15 
16  procedure LOCK_ROW (
17       X_ROWID in  VARCHAR2,
18        x_SYSTEM_SOURCE_TYPE IN VARCHAR2,
19        x_CATEGORY_NAME IN VARCHAR2,
20        x_MANDATORY_IND IN VARCHAR2 ,
21        x_SS_IND IN VARCHAR2,
22        x_DISPLAY_SEQUENCE IN NUMBER,
23        x_AD_TAB_NAME   IN  VARCHAR2 DEFAULT NULL,
24        x_INT_TAB_NAME  IN  VARCHAR2 DEFAULT NULL,
25       X_CLOSED_IND IN VARCHAR2 DEFAULT 'N'
26                    );
27 
28  procedure UPDATE_ROW (
29       X_ROWID in  VARCHAR2,
30        x_SYSTEM_SOURCE_TYPE IN VARCHAR2,
31        x_CATEGORY_NAME IN VARCHAR2,
32        x_MANDATORY_IND IN VARCHAR2,
33        x_SS_IND IN VARCHAR2,
34        x_DISPLAY_SEQUENCE IN NUMBER,
35        x_AD_TAB_NAME   IN  VARCHAR2 DEFAULT NULL,
36        x_INT_TAB_NAME  IN  VARCHAR2 DEFAULT NULL,
37       X_MODE in VARCHAR2 default 'R',
38       X_CLOSED_IND IN VARCHAR2 DEFAULT 'N'
39   );
40 
41  procedure ADD_ROW (
42       X_ROWID in out NOCOPY VARCHAR2,
43        x_SYSTEM_SOURCE_TYPE IN VARCHAR2,
44        x_CATEGORY_NAME IN VARCHAR2,
45        x_MANDATORY_IND IN VARCHAR2,
46        x_SS_IND IN VARCHAR2,
47        x_DISPLAY_SEQUENCE IN NUMBER,
48        x_AD_TAB_NAME   IN  VARCHAR2 DEFAULT NULL,
49        x_INT_TAB_NAME  IN  VARCHAR2 DEFAULT NULL,
50       X_MODE in VARCHAR2 default 'R',
51       X_CLOSED_IND IN VARCHAR2 DEFAULT 'N'
52   ) ;
53 
54 procedure DELETE_ROW (
55   X_ROWID in VARCHAR2
56 ) ;
57   FUNCTION Get_PK_For_Validation (
58     x_category_name IN VARCHAR2,
59     x_system_source_type IN VARCHAR2,
60     x_closed_ind IN VARCHAR2 DEFAULT NULL
61     ) RETURN BOOLEAN ;
62 
63   PROCEDURE Check_Constraints (
64 		 Column_Name IN VARCHAR2  DEFAULT NULL,
65 		 Column_Value IN VARCHAR2  DEFAULT NULL ) ;
66 
67 
68   PROCEDURE Before_DML (
69     p_action IN VARCHAR2,
70     x_rowid IN VARCHAR2 DEFAULT NULL,
71     x_system_source_type IN VARCHAR2 DEFAULT NULL,
72     x_category_name IN VARCHAR2 DEFAULT NULL,
73     x_mandatory_ind IN VARCHAR2 DEFAULT NULL,
74     x_ss_ind IN VARCHAR2 DEFAULT NULL,
75     x_display_sequence IN NUMBER DEFAULT NULL,
76     x_AD_TAB_NAME   IN  VARCHAR2 DEFAULT NULL,
77     x_INT_TAB_NAME  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       X_CLOSED_IND IN VARCHAR2 DEFAULT 'N'
84  );
85 END igs_ad_syssrc_cat_pkg;