PACKAGE: APPS.IGS_PS_USEC_OCUR_REF_PKG

Source

1 PACKAGE igs_ps_usec_ocur_ref_pkg AUTHID CURRENT_USER AS
2 /* $Header: IGSPI0XS.pls 115.8 2003/05/09 06:47:24 sarakshi ship $ */
3  procedure INSERT_ROW (
4       X_ROWID in out NOCOPY VARCHAR2,
5        x_UNIT_SEC_OCCUR_REFERENCE_ID IN OUT NOCOPY NUMBER,
6        x_UNIT_SECTION_OCCURRENCE_ID IN NUMBER,
7        x_REFERENCE_CODE_TYPE IN VARCHAR2,
8        x_REFERENCE_CODE IN VARCHAR2,
9        X_MODE in VARCHAR2 default 'R' ,
10        x_reference_code_desc IN VARCHAR2 DEFAULT NULL
11   );
12 
13  procedure LOCK_ROW (
14       X_ROWID in  VARCHAR2,
15        x_UNIT_SEC_OCCUR_REFERENCE_ID IN NUMBER,
16        x_UNIT_SECTION_OCCURRENCE_ID IN NUMBER,
17        x_REFERENCE_CODE_TYPE IN VARCHAR2,
18        x_REFERENCE_CODE IN VARCHAR2,
19        x_reference_code_desc IN VARCHAR2 DEFAULT NULL
20   );
21  procedure UPDATE_ROW (
22       X_ROWID in  VARCHAR2,
23        x_UNIT_SEC_OCCUR_REFERENCE_ID IN NUMBER,
24        x_UNIT_SECTION_OCCURRENCE_ID IN NUMBER,
25        x_REFERENCE_CODE_TYPE IN VARCHAR2,
26        x_REFERENCE_CODE IN VARCHAR2,
27        X_MODE in VARCHAR2 default 'R'  ,
28        x_reference_code_desc IN VARCHAR2 DEFAULT NULL
29   );
30 
31  procedure ADD_ROW (
32       X_ROWID in out NOCOPY VARCHAR2,
33        x_UNIT_SEC_OCCUR_REFERENCE_ID IN OUT NOCOPY NUMBER,
34        x_UNIT_SECTION_OCCURRENCE_ID IN NUMBER,
35        x_REFERENCE_CODE_TYPE IN VARCHAR2,
36        x_REFERENCE_CODE IN VARCHAR2,
37        X_MODE in VARCHAR2 default 'R'  ,
38        x_reference_code_desc IN VARCHAR2 DEFAULT NULL
39   ) ;
40 
41 procedure DELETE_ROW (
42   X_ROWID in VARCHAR2
43 ) ;
44   FUNCTION Get_PK_For_Validation (
45     x_unit_sec_occur_reference_id IN NUMBER
46     ) RETURN BOOLEAN ;
47 
48   FUNCTION Get_Uk_For_Validation (
49     x_reference_code_type      IN  VARCHAR2,
50     x_reference_code          IN  VARCHAR2,
51     x_Unit_section_Occurrence_Id  IN NUMBER
52     ) RETURN BOOLEAN ;
53 
54   PROCEDURE Get_FK_Igs_Ps_Usec_Occurs (
55     x_unit_section_occurrence_id IN NUMBER
56     );
57 
58   PROCEDURE Get_FK_Igs_ge_ref_cd_type(
59     x_reference_code_type IN VARCHAR2
60     );
61 
62   PROCEDURE get_ufk_igs_ge_ref_cd (
63     x_reference_code_type IN VARCHAR2,
64     x_reference_code IN VARCHAR2
65     ) ;
66 
67   PROCEDURE Check_Constraints (
68 		 Column_Name IN VARCHAR2  DEFAULT NULL,
69 		 Column_Value IN VARCHAR2  DEFAULT NULL ) ;
70   PROCEDURE Before_DML (
71     p_action IN VARCHAR2,
72     x_rowid IN VARCHAR2 DEFAULT NULL,
73     x_unit_sec_occur_reference_id IN NUMBER DEFAULT NULL,
74     x_unit_section_occurrence_id IN NUMBER DEFAULT NULL,
75     x_reference_code_type IN VARCHAR2 DEFAULT NULL,
76     x_reference_code IN VARCHAR2 DEFAULT NULL,
77     x_creation_date IN DATE DEFAULT NULL,
78     x_created_by IN NUMBER DEFAULT NULL,
79     x_last_update_date IN DATE DEFAULT NULL,
80     x_last_updated_by IN NUMBER DEFAULT NULL,
81     x_last_update_login IN NUMBER DEFAULT NULL,
82     x_reference_code_desc IN VARCHAR2 DEFAULT NULL
83  );
84 END igs_ps_usec_ocur_ref_pkg;