PACKAGE: APPS.IGS_AD_TERM_UNITDTLS_PKG

Source

1 PACKAGE igs_ad_term_unitdtls_pkg AS
2 /* $Header: IGSAI84S.pls 120.0 2005/06/01 14:22:40 appldev noship $ */
3  procedure INSERT_ROW (
4       X_ROWID in out NOCOPY VARCHAR2,
5        x_UNIT_DETAILS_ID IN OUT NOCOPY NUMBER,
6        x_TERM_DETAILS_ID IN NUMBER,
7        x_UNIT IN VARCHAR2,
8        x_UNIT_DIFFICULTY IN NUMBER,
9        x_UNIT_NAME IN VARCHAR2,
10        x_CP_ATTEMPTED IN NUMBER,
11        x_CP_EARNED IN NUMBER,
12        x_GRADE IN VARCHAR2,
13        x_UNIT_GRADE_POINTS IN NUMBER,
14        x_DEG_AUD_DETAIL_ID  IN NUMBER DEFAULT NULL,
15        X_MODE in VARCHAR2 default 'R'
16   );
17 
18  procedure LOCK_ROW (
19       X_ROWID in  VARCHAR2,
20        x_UNIT_DETAILS_ID IN NUMBER,
21        x_TERM_DETAILS_ID IN NUMBER,
22        x_UNIT IN VARCHAR2,
23        x_UNIT_DIFFICULTY IN NUMBER,
24        x_UNIT_NAME IN VARCHAR2,
25        x_CP_ATTEMPTED IN NUMBER,
26        x_CP_EARNED IN NUMBER,
27        x_GRADE IN VARCHAR2,
28        x_UNIT_GRADE_POINTS IN NUMBER,
29        x_DEG_AUD_DETAIL_ID  IN NUMBER DEFAULT NULL
30    );
31 
32  procedure UPDATE_ROW (
33       X_ROWID in  VARCHAR2,
34        x_UNIT_DETAILS_ID IN NUMBER,
35        x_TERM_DETAILS_ID IN NUMBER,
36        x_UNIT IN VARCHAR2,
37        x_UNIT_DIFFICULTY IN NUMBER,
38        x_UNIT_NAME IN VARCHAR2,
39        x_CP_ATTEMPTED IN NUMBER,
40        x_CP_EARNED IN NUMBER,
41        x_GRADE IN VARCHAR2,
42        x_UNIT_GRADE_POINTS IN NUMBER,
43        x_DEG_AUD_DETAIL_ID  IN NUMBER DEFAULT NULL,
44        X_MODE in VARCHAR2 default 'R'
45   );
46 
47  procedure ADD_ROW (
48       X_ROWID in out NOCOPY VARCHAR2,
49        x_UNIT_DETAILS_ID IN OUT NOCOPY NUMBER,
50        x_TERM_DETAILS_ID IN NUMBER,
51        x_UNIT IN VARCHAR2,
52        x_UNIT_DIFFICULTY IN NUMBER,
53        x_UNIT_NAME IN VARCHAR2,
54        x_CP_ATTEMPTED IN NUMBER,
55        x_CP_EARNED IN NUMBER,
56        x_GRADE IN VARCHAR2,
57        x_UNIT_GRADE_POINTS IN NUMBER,
58        x_DEG_AUD_DETAIL_ID  IN NUMBER DEFAULT NULL,
59        X_MODE in VARCHAR2 default 'R'
60   ) ;
61 
62 procedure DELETE_ROW (
63   X_ROWID in VARCHAR2,
64   x_mode IN VARCHAR2 DEFAULT 'R'
65 ) ;
66 
67 
68   FUNCTION Get_PK_For_Validation (
69     x_unit_details_id IN NUMBER
70     ) RETURN BOOLEAN ;
71 
72 
73   FUNCTION Get_UK_For_Validation (
74     x_term_details_id IN NUMBER,
75     x_unit IN VARCHAR2
76     ) RETURN BOOLEAN ;
77 
78   PROCEDURE Get_FK_Igs_Ad_Code_Classes (
79     x_code_id IN NUMBER
80     );
81 
82   PROCEDURE Get_FK_Igs_Ad_Term_Details (
83     x_term_details_id IN NUMBER
84     );
85 
86   PROCEDURE Check_Constraints (
87 		 Column_Name IN VARCHAR2  DEFAULT NULL,
88 		 Column_Value IN VARCHAR2  DEFAULT NULL ) ;
89   PROCEDURE Before_DML (
90     p_action IN VARCHAR2,
91     x_rowid IN VARCHAR2 DEFAULT NULL,
92     x_unit_details_id IN NUMBER DEFAULT NULL,
93     x_term_details_id IN NUMBER DEFAULT NULL,
94     x_unit IN VARCHAR2 DEFAULT NULL,
95     x_unit_difficulty IN NUMBER DEFAULT NULL,
96     x_unit_name IN VARCHAR2 DEFAULT NULL,
97     x_cp_attempted IN NUMBER DEFAULT NULL,
98     x_cp_earned IN NUMBER DEFAULT NULL,
99     x_grade IN VARCHAR2 DEFAULT NULL,
100     x_unit_grade_points IN NUMBER DEFAULT NULL,
101     x_deg_aud_detail_id  IN NUMBER DEFAULT NULL,
102     x_creation_date IN DATE DEFAULT NULL,
103     x_created_by IN NUMBER DEFAULT NULL,
104     x_last_update_date IN DATE DEFAULT NULL,
105     x_last_updated_by IN NUMBER DEFAULT NULL,
106     x_last_update_login IN NUMBER DEFAULT NULL
107  );
108 END igs_ad_term_unitdtls_pkg;