[Home] [Help]
PACKAGE: APPS.BOMPASGB
Source
1 package BOMPASGB AUTHID CURRENT_USER as
2 /* $Header: BOMASGBS.pls 115.2 99/07/16 05:08:55 porting ship $ */
3 /*==========================================================================+
4 | Copyright (c) 1993 Oracle Corporation Belmont, California, USA |
5 | All rights reserved. |
6 +===========================================================================+
7 | |
8 | File Name : BOMPASGB.pls |
9 | DESCRIPTION : This package contains functions used to assign bill |
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 | 11/11/93 Shreyas Shah creation date |
22 | 04/24/94 Julie Maeyama modifications |
23 +==========================================================================*/
24 FUNCTION bmablorg_assign_bill_orgid (
25 err_text IN OUT VARCHAR2
26 )
27 return INTEGER;
28
29 FUNCTION bmasrev_assign_revision (
30 org_id NUMBER,
31 all_org NUMBER := 2,
32 user_id NUMBER,
33 login_id NUMBER,
34 prog_appid NUMBER,
35 prog_id NUMBER,
36 req_id NUMBER,
37 err_text IN OUT VARCHAR2
38 )
39 return INTEGER;
40
41 FUNCTION bmasbilh_assign_bill_header (
42 org_id NUMBER,
43 all_org NUMBER := 2,
44 user_id NUMBER,
45 login_id NUMBER,
46 prog_appid NUMBER,
47 prog_id NUMBER,
48 req_id NUMBER,
49 err_text IN OUT VARCHAR2
50 )
51 return INTEGER;
52
53 FUNCTION bmascomp_assign_comp (
54 org_id NUMBER,
55 all_org NUMBER := 2,
56 user_id NUMBER,
57 login_id NUMBER,
58 prog_appid NUMBER,
59 prog_id NUMBER,
60 req_id NUMBER,
61 err_text IN OUT VARCHAR2
62 )
63 return INTEGER;
64
65 FUNCTION bmgblsq_get_bill_sequence(
66 org_id NUMBER,
67 item_id NUMBER,
68 alt_desg VARCHAR2,
69 bill_seq_id OUT NUMBER,
70 err_text OUT VARCHAR2
71 )
72 return INTEGER;
73
74 FUNCTION bmgcpsq_get_comp_sequence(
75 bill_seq_id NUMBER,
76 op_seq NUMBER,
77 cmp_id NUMBER,
78 eff_date VARCHAR2,
79 cmp_seq_id OUT NUMBER,
80 err_text OUT VARCHAR2
81 )
82 return INTEGER;
83
84 FUNCTION bmgblin_get_bill_info(
85 org_id OUT NUMBER,
86 item_id OUT NUMBER,
87 alt_desg OUT VARCHAR2,
88 bill_seq_id NUMBER,
89 err_text OUT VARCHAR2
90 )
91 return INTEGER;
92
93 FUNCTION bmasbitm_assign_bom_item_id(
94 org_id NUMBER,
95 item_number VARCHAR2,
96 item_id NUMBER,
97 err_text IN OUT VARCHAR2
98 )
99 return INTEGER;
100
101 FUNCTION bmasbomid_assign_bom_seq_id(
102 org_id NUMBER,
103 assy_id NUMBER,
104 alt_desg VARCHAR2,
105 bom_id NUMBER,
106 err_text IN OUT VARCHAR2
107 )
108 return INTEGER;
109
110 FUNCTION bmascmpid_assign_cmp_seq_id(
111 org_id NUMBER,
112 assy_id NUMBER,
113 alt_desg VARCHAR2,
114 op_seq NUMBER,
115 cmp_id NUMBER,
116 cmp_seq_id NUMBER,
117 eff_date VARCHAR2,
118 err_text IN OUT VARCHAR2
119 )
120 return INTEGER;
121
122 FUNCTION bmgcpqy_get_comp_quantity(
123 comp_seq_id NUMBER,
124 comp_qty OUT NUMBER,
125 err_text OUT VARCHAR2
126 )
127 return INTEGER;
128
129 FUNCTION bmasrefd_assign_ref_desg_data (
130 org_id NUMBER,
131 all_org NUMBER := 2,
132 user_id NUMBER,
133 login_id NUMBER,
134 prog_appid NUMBER,
135 prog_id NUMBER,
136 req_id NUMBER,
137 err_text IN OUT VARCHAR2
138 )
139 return INTEGER;
140
141 FUNCTION bmassubd_assign_sub_comp_data (
142 org_id NUMBER,
143 all_org NUMBER := 2,
144 user_id NUMBER,
145 login_id NUMBER,
146 prog_appid NUMBER,
147 prog_id NUMBER,
148 req_id NUMBER,
149 err_text IN OUT VARCHAR2
150 )
151 return INTEGER;
152
153
154 END BOMPASGB;