1 package IGS_AS_MARK_SHEET_PKG AUTHID CURRENT_USER as
2 /* $Header: IGSDI44S.pls 115.6 2002/11/28 23:21:42 nsidana ship $ */
3
4 procedure INSERT_ROW (
5 X_ROWID in out NOCOPY VARCHAR2,
6 X_ORG_ID in NUMBER,
7 X_SHEET_NUMBER in NUMBER,
8 X_GROUP_SEQUENCE_NUMBER in NUMBER,
9 X_UNIT_CD in VARCHAR2,
10 X_VERSION_NUMBER in NUMBER,
11 X_CAL_TYPE in VARCHAR2,
12 X_CI_SEQUENCE_NUMBER in NUMBER,
13 X_LOCATION_CD in VARCHAR2,
14 X_UNIT_MODE in VARCHAR2,
15 X_PRODUCTION_DT in DATE,
16 X_DUPLICATE_IND in VARCHAR2,
17 X_MODE in VARCHAR2 default 'R' ,
18 X_GRADING_PERIOD_CD in VARCHAR2
19 );
20 procedure LOCK_ROW (
21 X_ROWID in VARCHAR2,
22 X_SHEET_NUMBER in NUMBER,
23 X_GROUP_SEQUENCE_NUMBER in NUMBER,
24 X_UNIT_CD in VARCHAR2,
25 X_VERSION_NUMBER in NUMBER,
26 X_CAL_TYPE in VARCHAR2,
27 X_CI_SEQUENCE_NUMBER in NUMBER,
28 X_LOCATION_CD in VARCHAR2,
29 X_UNIT_MODE in VARCHAR2,
30 X_PRODUCTION_DT in DATE,
31 X_DUPLICATE_IND in VARCHAR2,
32 X_GRADING_PERIOD_CD in VARCHAR2
33 );
34 procedure UPDATE_ROW (
35 X_ROWID in VARCHAR2,
36 X_SHEET_NUMBER in NUMBER,
37 X_GROUP_SEQUENCE_NUMBER in NUMBER,
38 X_UNIT_CD in VARCHAR2,
39 X_VERSION_NUMBER in NUMBER,
40 X_CAL_TYPE in VARCHAR2,
41 X_CI_SEQUENCE_NUMBER in NUMBER,
42 X_LOCATION_CD in VARCHAR2,
43 X_UNIT_MODE in VARCHAR2,
44 X_PRODUCTION_DT in DATE,
45 X_DUPLICATE_IND in VARCHAR2,
46 X_MODE in VARCHAR2 default 'R',
47 X_GRADING_PERIOD_CD in VARCHAR2
48 );
49 procedure ADD_ROW (
50 X_ROWID in out NOCOPY VARCHAR2,
51 X_ORG_ID in NUMBER,
52 X_SHEET_NUMBER in NUMBER,
53 X_GROUP_SEQUENCE_NUMBER in NUMBER,
54 X_UNIT_CD in VARCHAR2,
55 X_VERSION_NUMBER in NUMBER,
56 X_CAL_TYPE in VARCHAR2,
57 X_CI_SEQUENCE_NUMBER in NUMBER,
58 X_LOCATION_CD in VARCHAR2,
59 X_UNIT_MODE in VARCHAR2,
60 X_PRODUCTION_DT in DATE,
61 X_DUPLICATE_IND in VARCHAR2,
62 X_MODE in VARCHAR2 default 'R',
63 X_GRADING_PERIOD_CD in VARCHAR2
64 );
65 procedure DELETE_ROW (
66 X_ROWID in VARCHAR2
67 );
68 FUNCTION Get_PK_For_Validation (
69 x_sheet_number IN NUMBER
70 ) RETURN BOOLEAN;
71 PROCEDURE GET_FK_IGS_PS_UNIT_OFR_PAT (
72 x_unit_cd IN VARCHAR2,
73 x_version_number IN NUMBER,
74 x_cal_type IN VARCHAR2,
75 x_ci_sequence_number IN NUMBER
76 );
77 PROCEDURE Check_Constraints (
78 Column_Name IN VARCHAR2 DEFAULT NULL,
79 Column_Value IN VARCHAR2 DEFAULT NULL
80 );
81 PROCEDURE Before_DML (
82 p_action IN VARCHAR2,
83 x_rowid IN VARCHAR2 DEFAULT NULL,
84 x_org_id IN NUMBER DEFAULT NULL,
85 x_sheet_number IN NUMBER DEFAULT NULL,
86 x_group_sequence_number IN NUMBER DEFAULT NULL,
87 x_unit_cd IN VARCHAR2 DEFAULT NULL,
88 x_version_number IN NUMBER DEFAULT NULL,
89 x_cal_type IN VARCHAR2 DEFAULT NULL,
90 x_ci_sequence_number IN NUMBER DEFAULT NULL,
91 x_location_cd IN VARCHAR2 DEFAULT NULL,
92 x_unit_mode IN VARCHAR2 DEFAULT NULL,
93 x_production_dt IN DATE DEFAULT NULL,
94 x_duplicate_ind IN VARCHAR2 DEFAULT NULL,
95 x_creation_date IN DATE DEFAULT NULL,
96 x_created_by IN NUMBER DEFAULT NULL,
97 x_last_update_date IN DATE DEFAULT NULL,
98 x_last_updated_by IN NUMBER DEFAULT NULL,
99 x_last_update_login IN NUMBER DEFAULT NULL,
100 x_grading_period_cd IN VARCHAR2 DEFAULT NULL
101 ) ;
102
103 end IGS_AS_MARK_SHEET_PKG;