[Home] [Help]
PACKAGE: APPS.BOM_BILL_API
Source
1 PACKAGE Bom_Bill_Api AUTHID CURRENT_USER AS
2 /* $Header: BOMOIBMS.pls 115.4 2002/06/14 22:12:46 rfarook ship $ */
3 /*==========================================================================+
4 | Copyright (c) 1997 Oracle Corporation Redwood Shores, California, USA |
5 | All rights reserved. |
6 +===========================================================================+
7 | |
8 | File Name : BOMOIBMS.pls |
9 | DESCRIPTION : This package contains functions used to assign, validate |
10 | and transact Bill of Material data in the |
11 | BOM_BILL_OF_MATLS_INTERFACE table. |
12 | Parameters: org_id organization_id |
13 | all_org process all orgs or just current org |
14 | 1 - all orgs |
15 | 2 - only org_id |
16 | prog_appid program application_id |
17 | prog_id program id |
18 | req_id request_id |
19 | user_id user id |
20 | login_id login id |
21 | History: |
22 | 03/10/97 Julie Maeyama Created this new package |
23 +==========================================================================*/
24
25 G_Insert CONSTANT VARCHAR2(10) := 'CREATE'; -- transaction type
26 G_Update CONSTANT VARCHAR2(10) := 'UPDATE'; -- transaction type
27 G_Delete CONSTANT VARCHAR2(10) := 'DELETE'; -- transaction type
28 G_NullChar CONSTANT VARCHAR2(10) := fnd_global.local_chr(12); -- null value
29 G_NullNum CONSTANT NUMBER := 9.99E125; -- null value
30 G_NullDate CONSTANT DATE := to_date('1','j'); -- null value
31 G_DeleteEntity CONSTANT VARCHAR2(30) := 'BOM_BILL_OF_MTLS_INTERFACE';
32 G_ProductFamily CONSTANT NUMBER := 5;
33 G_rows_to_commit CONSTANT NUMBER := 500;
34
35
36 FUNCTION Import_Bill (
37 org_id NUMBER,
38 all_org NUMBER := 1,
39 user_id NUMBER := -1,
40 login_id NUMBER := -1,
41 prog_appid NUMBER := -1,
42 prog_id NUMBER := -1,
43 req_id NUMBER := -1,
44 del_rec_flag NUMBER := 1,
45 err_text IN OUT VARCHAR2
46 )
47 return INTEGER;
48
49 END Bom_Bill_Api;