[Home] [Help]
PACKAGE: APPS.BOMPASGR
Source
1 package BOMPASGR AUTHID CURRENT_USER as
2 /* $Header: BOMASGRS.pls 115.2 99/07/16 05:09:02 porting ship $ */
3 /*==========================================================================+
4 | Copyright (c) 1993 Oracle Corporation Belmont, California, USA |
5 | All rights reserved. |
6 +===========================================================================+
7 | |
8 | File Name : BOMASGRS.pls |
9 | DESCRIPTION : This package contains functions used to assign 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 | req_id request_id |
18 | user_id user id |
19 | login_id login id |
20 | History: |
21 | 09/28/93 Shreyas Shah creation date |
22 | 05/03/94 Julie Maeyama modified logic |
23 | |
24 +==========================================================================*/
25 FUNCTION bmartorg_assign_rtg_orgid (
26 err_text IN OUT VARCHAR2
27 )
28 return INTEGER;
29
30 FUNCTION bmasrrev_assign_rtg_revision (
31 org_id NUMBER,
32 all_org NUMBER,
33 user_id NUMBER,
34 login_id NUMBER,
35 prog_appid NUMBER,
36 prog_id NUMBER,
37 req_id NUMBER,
38 err_text IN OUT VARCHAR2
39 )
40 return INTEGER;
41
42 FUNCTION bmprtgh_assign_rtg_header (
43 org_id NUMBER,
44 all_org NUMBER,
45 user_id NUMBER,
46 login_id NUMBER,
47 prog_appid NUMBER,
48 prog_id NUMBER,
49 req_id NUMBER,
50 err_text IN OUT VARCHAR2
51 )
52 return INTEGER;
53
54 FUNCTION bmasopd_assign_operation_data (
55 org_id NUMBER,
56 all_org NUMBER,
57 user_id NUMBER,
58 login_id NUMBER,
59 prog_appid NUMBER,
60 prog_id NUMBER,
61 req_id NUMBER,
62 err_text IN OUT VARCHAR2
63 )
64 return INTEGER;
65
66
67 FUNCTION bmasrsd_assign_resource_data (
68 org_id NUMBER,
69 all_org NUMBER,
70 user_id NUMBER,
71 login_id NUMBER,
72 prog_appid NUMBER,
73 prog_id NUMBER,
74 req_id NUMBER,
75 err_text IN OUT VARCHAR2
76 )
77 return INTEGER;
78
79 FUNCTION bmgrtsq_get_routing_sequence (
80 org_id NUMBER,
81 item_id NUMBER,
82 alt_desg VARCHAR2,
83 routing_seq_id OUT NUMBER,
84 err_text OUT VARCHAR2
85 )
86 return INTEGER;
87
88 FUNCTION bmgopsq_get_op_sequence(
89 rtg_seq_id NUMBER,
90 op_seq NUMBER,
91 eff_date VARCHAR2,
92 op_seq_id OUT NUMBER,
93 err_text OUT VARCHAR2
94 )
95 return INTEGER;
96
97 FUNCTION bmasopid_assign_op_seq_id(
98 org_id NUMBER,
99 assy_id NUMBER,
100 alt_desg VARCHAR2,
101 op_seq NUMBER,
102 op_id NUMBER,
103 eff_date VARCHAR2,
104 err_text OUT VARCHAR2
105 )
106 return INTEGER;
107
108 FUNCTION bmasrtgid_assign_rtg_seq_id(
109 org_id NUMBER,
110 assy_id NUMBER,
111 alt_desg VARCHAR2,
112 rtg_id NUMBER,
113 err_text OUT VARCHAR2
114 )
115 return INTEGER;
116
117 FUNCTION bmgrtin_get_rtg_info(
118 org_id OUT NUMBER,
119 item_id OUT NUMBER,
120 alt_desg OUT VARCHAR2,
121 rtg_seq_id NUMBER,
122 err_text OUT VARCHAR2
123 )
124 return INTEGER;
125
126 FUNCTION bmgtdep_get_department(
127 org_id NUMBER,
128 dept_code VARCHAR2,
129 dept_id OUT NUMBER,
130 err_text OUT VARCHAR2
131 )
132 return INTEGER;
133
134 FUNCTION bmgtstdop_get_stdop(
135 org_id NUMBER,
136 stdop_code VARCHAR2,
137 stdop_id OUT NUMBER,
138 err_text OUT VARCHAR2
139 )
140 return INTEGER;
141
142 FUNCTION bmasritm_assign_rtg_item_id(
143 org_id NUMBER,
144 item_num VARCHAR2,
145 item_id NUMBER,
146 err_text OUT VARCHAR2
147 )
148 return INTEGER;
149
150 END BOMPASGR;