[Home] [Help]
PACKAGE: APPS.BOM_COMPONENT_API
Source
1 PACKAGE Bom_Component_Api AUTHID CURRENT_USER AS
2 /* $Header: BOMOICMS.pls 115.4 2002/05/15 13:57:52 pkm ship $ */
3 /*==========================================================================+
4 | Copyright (c) 1997 Oracle Corporation Redwood Shores, California, USA |
5 | All rights reserved. |
6 +===========================================================================+
7 | |
8 | File Name : BOMOICMS.pls |
9 | DESCRIPTION : This package contains functions used to assign, validate |
10 | and transact Component data in the |
11 | BOM_INVENTORY_COMPS_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/17/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_INVENTORY_COMPS_INTERFACE';
32 G_ProductFamily CONSTANT NUMBER := 5;
33 G_rows_to_commit CONSTANT NUMBER := 500;
34
35
36 FUNCTION Import_Component (
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_Component_Api;