PACKAGE: APPS.IGS_PS_USEC_RPT_FMLY_PKG

Source

1 PACKAGE igs_ps_usec_rpt_fmly_pkg AUTHID CURRENT_USER AS
2 /* $Header: IGSPI0IS.pls 115.6 2002/11/29 01:57:14 nsidana ship $ */
3  procedure INSERT_ROW (
4       X_ROWID in out NOCOPY VARCHAR2,
5        x_UNIT_SECTION_RPT_FAMILY_ID IN OUT NOCOPY NUMBER,
6        x_UOO_ID IN NUMBER,
7        x_REPEAT_FAMILY_UNIT_CD IN VARCHAR2,
8        x_RPT_FAMILY_VER_NUMBER IN NUMBER,
9       X_MODE in VARCHAR2 default 'R'
10   );
11 
12  procedure LOCK_ROW (
13       X_ROWID in  VARCHAR2,
14        x_UNIT_SECTION_RPT_FAMILY_ID IN NUMBER,
15        x_UOO_ID IN NUMBER,
16        x_REPEAT_FAMILY_UNIT_CD IN VARCHAR2,
17        x_RPT_FAMILY_VER_NUMBER IN NUMBER  );
18  procedure UPDATE_ROW (
19       X_ROWID in  VARCHAR2,
20        x_UNIT_SECTION_RPT_FAMILY_ID IN NUMBER,
21        x_UOO_ID IN NUMBER,
22        x_REPEAT_FAMILY_UNIT_CD IN VARCHAR2,
23        x_RPT_FAMILY_VER_NUMBER IN NUMBER,
24       X_MODE in VARCHAR2 default 'R'
25   );
26 
27  procedure ADD_ROW (
28       X_ROWID in out NOCOPY VARCHAR2,
29        x_UNIT_SECTION_RPT_FAMILY_ID IN OUT NOCOPY NUMBER,
30        x_UOO_ID IN NUMBER,
31        x_REPEAT_FAMILY_UNIT_CD IN VARCHAR2,
32        x_RPT_FAMILY_VER_NUMBER IN NUMBER,
33       X_MODE in VARCHAR2 default 'R'
34   ) ;
35 
36 procedure DELETE_ROW (
37   X_ROWID in VARCHAR2
38 ) ;
39   FUNCTION Get_PK_For_Validation (
40     x_UNIT_SECTION_RPT_FAMILY_ID IN NUMBER
41     ) RETURN BOOLEAN ;
42 
43   FUNCTION Get_UK_For_Validation (
44     x_repeat_family_unit_cd IN VARCHAR2,
45     x_RPT_FAMILY_VER_NUMBER IN NUMBER,
46     x_uoo_id IN NUMBER
47     ) RETURN BOOLEAN;
48 
49   PROCEDURE Get_UFK_Igs_Ps_Unit_Ofr_Opt (
50     x_uoo_id IN NUMBER
51     );
52 
53   PROCEDURE Get_FK_Igs_Ps_Unit_Ver (
54     x_unit_cd IN VARCHAR2,
55     x_version_number IN NUMBER
56     );
57 
58   PROCEDURE Check_Constraints (
59 		 Column_Name IN VARCHAR2  DEFAULT NULL,
60 		 Column_Value IN VARCHAR2  DEFAULT NULL ) ;
61   PROCEDURE Before_DML (
62     p_action IN VARCHAR2,
63     x_rowid IN VARCHAR2 DEFAULT NULL,
64     x_UNIT_SECTION_RPT_FAMILY_ID IN NUMBER DEFAULT NULL,
65     x_uoo_id IN NUMBER DEFAULT NULL,
66     x_repeat_family_unit_cd IN VARCHAR2 DEFAULT NULL,
67     x_RPT_FAMILY_VER_NUMBER IN NUMBER 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  );
74 END igs_ps_usec_rpt_fmly_pkg;