PACKAGE: APPS.IGS_AS_UNT_PATRN_ITM_PKG

Source

1 package  IGS_AS_UNT_PATRN_ITM_PKG as
2 /* $Header: IGSDI32S.pls 120.0 2005/07/05 11:24:54 appldev noship $ */
3 
4 procedure INSERT_ROW (
5   X_ROWID in out NOCOPY VARCHAR2,
6   X_UNIT_CD in VARCHAR2,
7   X_VERSION_NUMBER in NUMBER,
8   X_CAL_TYPE in VARCHAR2,
9   X_CI_SEQUENCE_NUMBER in NUMBER,
10   X_ASS_PATTERN_ID in NUMBER,
11   X_ASS_ID in NUMBER,
12   X_UAI_SEQUENCE_NUMBER in NUMBER,
13   X_APPORTIONMENT_PERCENTAGE in NUMBER,
14   X_MODE in VARCHAR2 default 'R'
15   );
16 procedure LOCK_ROW (
17   X_ROWID in VARCHAR2,
18   X_UNIT_CD in VARCHAR2,
19   X_VERSION_NUMBER in NUMBER,
20   X_CAL_TYPE in VARCHAR2,
21   X_CI_SEQUENCE_NUMBER in NUMBER,
22   X_ASS_PATTERN_ID in NUMBER,
23   X_ASS_ID in NUMBER,
24   X_UAI_SEQUENCE_NUMBER in NUMBER,
25   X_APPORTIONMENT_PERCENTAGE in NUMBER
26 );
27 procedure UPDATE_ROW (
28   X_ROWID in VARCHAR2,
29   X_UNIT_CD in VARCHAR2,
30   X_VERSION_NUMBER in NUMBER,
31   X_CAL_TYPE in VARCHAR2,
32   X_CI_SEQUENCE_NUMBER in NUMBER,
33   X_ASS_PATTERN_ID in NUMBER,
34   X_ASS_ID in NUMBER,
35   X_UAI_SEQUENCE_NUMBER in NUMBER,
36   X_APPORTIONMENT_PERCENTAGE in NUMBER,
37   X_MODE in VARCHAR2 default 'R'
38   );
39 procedure ADD_ROW (
40   X_ROWID in out NOCOPY VARCHAR2,
41   X_UNIT_CD in VARCHAR2,
42   X_VERSION_NUMBER in NUMBER,
43   X_CAL_TYPE in VARCHAR2,
44   X_CI_SEQUENCE_NUMBER in NUMBER,
45   X_ASS_PATTERN_ID in NUMBER,
46   X_ASS_ID in NUMBER,
47   X_UAI_SEQUENCE_NUMBER in NUMBER,
48   X_APPORTIONMENT_PERCENTAGE in NUMBER,
49   X_MODE in VARCHAR2 default 'R'
50   );
51 procedure DELETE_ROW (
52   X_ROWID in VARCHAR2
53   );
54 FUNCTION Get_PK_For_Validation (
55     x_unit_cd IN VARCHAR2,
56     x_version_number IN NUMBER,
57     x_cal_type IN VARCHAR2,
58     x_ci_sequence_number IN NUMBER,
59     x_ass_pattern_id IN NUMBER,
60     x_ass_id IN NUMBER,
61     x_uai_sequence_number IN NUMBER
62     ) RETURN BOOLEAN;
63 
64   PROCEDURE GET_FK_IGS_AS_UNITASS_ITEM (
65     x_unit_cd IN VARCHAR2,
66     x_version_number IN NUMBER,
67     x_cal_type IN VARCHAR2,
68     x_ci_sequence_number IN NUMBER,
69     x_ass_id IN NUMBER,
70     x_sequence_number IN NUMBER
71     );
72 
73   PROCEDURE GET_FK_IGS_AS_UNTAS_PATTERN (
74     x_unit_cd IN VARCHAR2,
75     x_version_number IN NUMBER,
76     x_cal_type IN VARCHAR2,
77     x_ci_sequence_number IN NUMBER,
78     x_ass_pattern_id IN NUMBER
79     );
80 
81  PROCEDURE Check_Constraints (
82  Column_Name	IN	VARCHAR2	DEFAULT NULL,
83  Column_Value 	IN	VARCHAR2	DEFAULT NULL
84  );
85 
86   PROCEDURE Before_DML (
87     p_action IN VARCHAR2,
88     x_rowid IN VARCHAR2 DEFAULT NULL,
89     x_unit_cd IN VARCHAR2 DEFAULT NULL,
90     x_version_number IN NUMBER DEFAULT NULL,
91     x_cal_type IN VARCHAR2 DEFAULT NULL,
92     x_ci_sequence_number IN NUMBER DEFAULT NULL,
93     x_ass_pattern_id IN NUMBER DEFAULT NULL,
94     x_ass_id IN NUMBER DEFAULT NULL,
95     x_uai_sequence_number IN NUMBER DEFAULT NULL,
96     x_apportionment_percentage IN NUMBER DEFAULT NULL,
97     x_creation_date IN DATE DEFAULT NULL,
98     x_created_by IN NUMBER DEFAULT NULL,
99     x_last_update_date IN DATE DEFAULT NULL,
100     x_last_updated_by IN NUMBER DEFAULT NULL,
101     x_last_update_login IN NUMBER DEFAULT NULL
102   ) ;
103 
104 end IGS_AS_UNT_PATRN_ITM_PKG;