[Home] [Help]
PACKAGE: APPS.BOMPVALR
Source
1 package BOMPVALR as
2 /* $Header: BOMVALRS.pls 120.2.12010000.2 2008/11/14 16:39:38 snandana ship $ */
3 /*==========================================================================+
4 | Copyright (c) 1993 Oracle Corporation Belmont, California, USA |
5 | All rights reserved. |
6 +===========================================================================+
7 | |
8 | File Name : BOMPVALR.pls |
9 | DESCRIPTION : This package contains functions used to validate routing
10 | data in the interface tables
11 | Parameters: org_id organization_id
12 | all_org process all orgs or just current org
13 | 1 - all orgs
14 | 2 - only org_id
15 | prog_appid program application_id
16 | prog_id program id
17 | request_id request_id
18 | user_id user id
19 | login_id login id
20 | History:
21 | 10/05/93 Shreyas Shah creation date
22 | |
23 +==========================================================================*/
24 FUNCTION bmvrtgh_validate_rtg_header (
25 org_id NUMBER,
26 all_org NUMBER,
27 user_id NUMBER,
28 login_id NUMBER,
29 prog_appid NUMBER,
30 prog_id NUMBER,
31 request_id NUMBER,
32 err_text IN OUT NOCOPY VARCHAR2
33 )
34 return INTEGER;
35
36 FUNCTION bmvopr_validate_operations (
37 org_id NUMBER,
38 all_org NUMBER := 2,
39 user_id NUMBER,
40 login_id NUMBER,
41 prog_appid NUMBER,
42 prog_id NUMBER,
43 request_id NUMBER,
44 err_text IN OUT NOCOPY VARCHAR2
45 )
46 return INTEGER;
47
48 FUNCTION bmvres_validate_resources (
49 org_id NUMBER,
50 all_org NUMBER,
51 user_id NUMBER,
52 login_id NUMBER,
53 prog_appid NUMBER,
54 prog_id NUMBER,
55 request_id NUMBER,
56 err_text IN OUT NOCOPY VARCHAR2
57 )
58 return INTEGER;
59
60 FUNCTION bmvunres_verify_unique_res (
61 trans_id NUMBER,
62 err_text IN OUT NOCOPY VARCHAR2
63 )
64 return INTEGER;
65
66 FUNCTION bmvrtgrev_validate_rtg_rev (
67 org_id NUMBER,
68 all_org NUMBER,
69 user_id NUMBER,
70 login_id NUMBER,
71 prog_appid NUMBER,
72 prog_id NUMBER,
73 req_id NUMBER,
74 err_text IN OUT NOCOPY VARCHAR2
75 )
76 return INTEGER;
77
78 FUNCTION bmvrev_validate_rev (
79 org_id NUMBER,
80 assy_id NUMBER,
81 user_id NUMBER,
82 login_id NUMBER,
83 prog_appid NUMBER,
84 prog_id NUMBER,
85 req_id NUMBER,
86 err_text IN OUT NOCOPY VARCHAR2
87 )
88 return INTEGER;
89
90 FUNCTION bmvcmrtg_verify_common_routing (
91 rtg_id NUMBER,
92 cmn_rtg_id NUMBER,
93 rtg_type NUMBER,
94 item_id NUMBER,
95 org_id NUMBER,
96 alt_desg VARCHAR2,
97 err_text IN OUT NOCOPY VARCHAR2
98 )
99 return INTEGER;
100
101 FUNCTION bmvrtg_verify_rtg_type (
102 org_id NUMBER,
103 assy_id NUMBER,
104 rtg_type NUMBER,
105 err_text IN OUT NOCOPY VARCHAR2
106 )
107 return INTEGER;
108
109 FUNCTION bmvurtg_verify_routing (
110 rtg_seq_id NUMBER,
111 mode_type NUMBER,
112 err_text IN OUT NOCOPY VARCHAR2
113 )
114 return INTEGER;
115
116 FUNCTION bmvduprt_verify_duplicate_rtg(
117 org_id NUMBER,
118 assy_id NUMBER,
119 alt_desg VARCHAR2,
120 rtg_type NUMBER,
121 err_text IN OUT NOCOPY VARCHAR2
122 )
123 return INTEGER;
124
125 FUNCTION bmvunop_verify_unique_op (
126 op_seq_id NUMBER,
127 exist_flag NUMBER,
128 err_text IN OUT NOCOPY VARCHAR2
129 )
130 return INTEGER;
131
132 FUNCTION bmvdupop_verify_duplicate_op(
133 rtg_seq_id NUMBER,
134 eff_date VARCHAR2,
135 op_seq NUMBER,
136 err_text IN OUT NOCOPY VARCHAR2
137 )
138 return INTEGER;
139
140 FUNCTION bmvovlap_verify_overlaps (
141 rtg_id NUMBER,
142 op_num NUMBER,
143 eff_date VARCHAR2,
144 dis_date VARCHAR2,
145 err_text IN OUT NOCOPY VARCHAR2
146 )
147 return INTEGER;
148
149 FUNCTION bmvdept_validate_department (
150 org_id NUMBER,
151 dept_id NUMBER,
152 eff_date VARCHAR2,
153 err_text IN OUT NOCOPY VARCHAR2
154 )
155 return INTEGER;
156
157 FUNCTION bmvrsch_verify_resource_sched (
158 op_seq NUMBER,
159 sched_type NUMBER,
160 err_text IN OUT NOCOPY VARCHAR2
161 )
162 return INTEGER;
163
164 FUNCTION bmvauto_verify_autocharge (
165 op_seq NUMBER,
166 dept_id NUMBER,
167 err_text IN OUT NOCOPY VARCHAR2
168 )
169 return INTEGER;
170
171 G_round_off_val number :=NVL(FND_PROFILE.VALUE('BOM:ROUND_OFF_VALUE'),6); /* Bug 7322996 */
172
173 END BOMPVALR;