PACKAGE: APPS.IGS_PS_AWD_OWN_PKG

Source

1 package IGS_PS_AWD_OWN_PKG AUTHID CURRENT_USER AS
2   /* $Header: IGSPI07S.pls 115.4 2003/06/09 03:43:47 smvk ship $ */
3 
4 procedure INSERT_ROW (
5   X_ROWID in out NOCOPY VARCHAR2,
6   X_COURSE_CD in VARCHAR2,
7   X_ORG_UNIT_CD in VARCHAR2,
8   X_OU_START_DT in DATE,
9   X_AWARD_CD in VARCHAR2,
10   X_VERSION_NUMBER in NUMBER,
11   X_PERCENTAGE in NUMBER,
12   X_MODE in VARCHAR2 default 'R'
13   );
14 procedure LOCK_ROW (
15   X_ROWID IN VARCHAR2,
16   X_COURSE_CD in VARCHAR2,
17   X_ORG_UNIT_CD in VARCHAR2,
18   X_OU_START_DT in DATE,
19   X_AWARD_CD in VARCHAR2,
20   X_VERSION_NUMBER in NUMBER,
21   X_PERCENTAGE in NUMBER
22 );
23 procedure UPDATE_ROW (
24   X_ROWID IN VARCHAR2,
25   X_COURSE_CD in VARCHAR2,
26   X_ORG_UNIT_CD in VARCHAR2,
27   X_OU_START_DT in DATE,
28   X_AWARD_CD in VARCHAR2,
29   X_VERSION_NUMBER in NUMBER,
30   X_PERCENTAGE in NUMBER,
31   X_MODE in VARCHAR2 default 'R'
32   );
33 procedure ADD_ROW (
34   X_ROWID in out NOCOPY VARCHAR2,
35   X_COURSE_CD in VARCHAR2,
36   X_ORG_UNIT_CD in VARCHAR2,
37   X_OU_START_DT in DATE,
38   X_AWARD_CD in VARCHAR2,
39   X_VERSION_NUMBER in NUMBER,
40   X_PERCENTAGE in NUMBER,
41   X_MODE in VARCHAR2 default 'R'
42   );
43 procedure DELETE_ROW (
44   X_ROWID in VARCHAR2
45 );
46 
47   FUNCTION Get_PK_For_Validation (
48     x_course_cd IN VARCHAR2,
49     x_version_number IN NUMBER,
50     x_award_cd IN VARCHAR2,
51     x_org_unit_cd IN VARCHAR2,
52     x_ou_start_dt IN DATE )
53   RETURN BOOLEAN;
54 
55   PROCEDURE GET_FK_IGS_OR_UNIT (
56     x_org_unit_cd IN VARCHAR2,
57     x_start_dt IN VARCHAR2
58     );
59 
60 PROCEDURE Check_Constraints (
61     Column_Name	IN VARCHAR2	DEFAULT NULL,
62     Column_Value 	IN VARCHAR2	DEFAULT NULL
63 );
64 
65 PROCEDURE Before_DML (
66     p_action IN VARCHAR2,
67     x_rowid IN VARCHAR2 DEFAULT NULL,
68     x_course_cd IN VARCHAR2 DEFAULT NULL,
69     x_version_number IN NUMBER DEFAULT NULL,
70     x_award_cd IN VARCHAR2 DEFAULT NULL,
71     x_org_unit_cd IN VARCHAR2 DEFAULT NULL,
72     x_ou_start_dt IN DATE DEFAULT NULL,
73     x_percentage IN NUMBER DEFAULT NULL,
74     x_creation_date IN DATE DEFAULT NULL,
75     x_created_by IN NUMBER DEFAULT NULL,
76     x_last_update_date IN DATE DEFAULT NULL,
77     x_last_updated_by IN NUMBER DEFAULT NULL,
78     x_last_update_login IN NUMBER DEFAULT NULL
79   ) ;
80 
81 end IGS_PS_AWD_OWN_PKG;