PACKAGE: APPS.IGS_AD_CONV_GS_TYPES_PKG

Source

1 PACKAGE igs_ad_conv_gs_types_pkg AUTHID CURRENT_USER AS
2 /* $Header: IGSAI77S.pls 115.5 2002/11/28 22:16:00 nsidana ship $ */
3 
4   procedure INSERT_ROW (
5     X_ROWID in out NOCOPY VARCHAR2,
6     x_CONV_GS_TYPES_ID IN OUT NOCOPY NUMBER,
7     x_FROM_CODE_ID IN NUMBER,
8     x_TO_CODE_ID IN NUMBER,
9     X_MODE in VARCHAR2 default 'R'
10   );
11 
12   procedure LOCK_ROW (
13     X_ROWID in  VARCHAR2,
14     x_CONV_GS_TYPES_ID IN NUMBER,
15     x_FROM_CODE_ID IN NUMBER,
16     x_TO_CODE_ID IN NUMBER
17   );
18 
19   procedure UPDATE_ROW (
20     X_ROWID in  VARCHAR2,
21     x_CONV_GS_TYPES_ID IN NUMBER,
22     x_FROM_CODE_ID IN NUMBER,
23     x_TO_CODE_ID IN NUMBER,
24     X_MODE in VARCHAR2 default 'R'
25   );
26 
27   procedure ADD_ROW (
28     X_ROWID in out NOCOPY VARCHAR2,
29     x_CONV_GS_TYPES_ID IN OUT NOCOPY  NUMBER,
30     x_FROM_CODE_ID IN NUMBER,
31     x_TO_CODE_ID IN NUMBER,
32     X_MODE in VARCHAR2 default 'R'
33   );
34 
35   procedure DELETE_ROW (
36     X_ROWID in VARCHAR2
37   );
38 
39   FUNCTION Get_PK_For_Validation (
40     x_conv_gs_types_id IN NUMBER
41   ) RETURN BOOLEAN ;
42 
43   FUNCTION Get_UK_For_Validation (
44     x_from_code_id IN NUMBER,
45     x_to_code_id IN NUMBER
46   ) RETURN BOOLEAN;
47 
48   PROCEDURE Get_FK_Igs_Ad_Code_Classes (
49     x_code_id IN NUMBER
50   );
51 
52   PROCEDURE Before_DML (
53     p_action IN VARCHAR2,
54     x_rowid IN VARCHAR2 DEFAULT NULL,
55     x_conv_gs_types_id IN NUMBER DEFAULT NULL,
56     x_from_code_id IN NUMBER DEFAULT NULL,
57     x_to_code_id IN NUMBER DEFAULT NULL,
58     x_creation_date IN DATE DEFAULT NULL,
59     x_created_by IN NUMBER DEFAULT NULL,
60     x_last_update_date IN DATE DEFAULT NULL,
61     x_last_updated_by IN NUMBER DEFAULT NULL,
62     x_last_update_login IN NUMBER DEFAULT NULL
63   );
64 
65 END igs_ad_conv_gs_types_pkg;