PACKAGE: APPS.IGS_PS_OWN_PKG

Source

1 package  IGS_PS_OWN_PKG AS
2 /* $Header: IGSPI27S.pls 120.0 2005/06/01 23:50:51 appldev noship $ */
3 procedure INSERT_ROW (
4   X_ROWID in out NOCOPY VARCHAR2,
5   X_COURSE_CD in VARCHAR2,
6   X_OU_START_DT in DATE,
7   X_ORG_UNIT_CD in VARCHAR2,
8   X_VERSION_NUMBER in NUMBER,
9   X_PERCENTAGE in NUMBER,
10   X_MODE in VARCHAR2 default 'R'
11   );
12 procedure LOCK_ROW (
13   X_ROWID in VARCHAR2,
14   X_COURSE_CD in VARCHAR2,
15   X_OU_START_DT in DATE,
16   X_ORG_UNIT_CD in VARCHAR2,
17   X_VERSION_NUMBER in NUMBER,
18   X_PERCENTAGE in NUMBER
19 );
20 procedure UPDATE_ROW (
21   X_ROWID in VARCHAR2,
22   X_COURSE_CD in VARCHAR2,
23   X_OU_START_DT in DATE,
24   X_ORG_UNIT_CD in VARCHAR2,
25   X_VERSION_NUMBER in NUMBER,
26   X_PERCENTAGE in NUMBER,
27   X_MODE in VARCHAR2 default 'R'
28   );
29 procedure ADD_ROW (
30   X_ROWID in out NOCOPY VARCHAR2,
31   X_COURSE_CD in VARCHAR2,
32   X_OU_START_DT in DATE,
33   X_ORG_UNIT_CD in VARCHAR2,
34   X_VERSION_NUMBER in NUMBER,
35   X_PERCENTAGE in NUMBER,
36   X_MODE in VARCHAR2 default 'R'
37   );
38 procedure DELETE_ROW (
39   X_ROWID in VARCHAR2
40 );
41 
42   FUNCTION Get_PK_For_Validation (
43     x_course_cd IN VARCHAR2,
44     x_version_number IN NUMBER,
45     x_org_unit_cd IN VARCHAR2,
46     x_ou_start_dt IN DATE
47     )RETURN BOOLEAN;
48 
49   FUNCTION Get_PK_For_Validation (
50     x_course_cd IN VARCHAR2,
51     x_version_number IN NUMBER,
52     x_org_unit_cd IN VARCHAR2
53   ) RETURN BOOLEAN;
54 
55   PROCEDURE GET_FK_IGS_PS_VER (
56     x_course_cd IN VARCHAR2,
57     x_version_number IN NUMBER
58     );
59 
60   PROCEDURE GET_FK_IGS_OR_UNIT (
61     x_org_unit_cd IN VARCHAR2,
62     x_start_dt IN VARCHAR2
63     );
64 
65   PROCEDURE Check_Constraints (
66 	Column_name IN VARCHAR2 DEFAULT NULL,
67 	Column_value IN VARCHAR2 DEFAULT NULL
68    );
69 
70   PROCEDURE Before_DML (
71     p_action IN VARCHAR2,
72     x_rowid IN VARCHAR2 DEFAULT NULL,
73     x_org_unit_cd IN VARCHAR2 DEFAULT NULL,
74     x_ou_start_dt IN DATE DEFAULT NULL,
75     x_percentage IN NUMBER DEFAULT NULL,
76     x_course_cd IN VARCHAR2 DEFAULT NULL,
77     x_version_number IN NUMBER 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   );
84 
85 
86 end IGS_PS_OWN_PKG;