[Home] [Help]
PACKAGE: APPS.BOM_SUBSTITUTE_COMPONENT_API
Source
1 PACKAGE Bom_Substitute_Component_Api AUTHID CURRENT_USER AS
2 /* $Header: BOMOISCS.pls 115.4 2002/06/14 22:13:34 rfarook ship $ */
3 /*==========================================================================+
4 | Copyright (c) 1997 Oracle Corporation Redwood Shores, California, USA |
5 | All rights reserved. |
6 +===========================================================================+
7 | |
8 | File Name : BOMOISCS.pls |
9 | DESCRIPTION : This package contains functions used to assign, validate |
10 | and transact Substitute Component data in the |
11 | BOM_SUB_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 | 02/26/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_rows_to_commit CONSTANT NUMBER := 500;
32
33
34 FUNCTION Import_Substitute_Component (
35 org_id NUMBER,
36 all_org NUMBER := 1,
37 user_id NUMBER := -1,
38 login_id NUMBER := -1,
39 prog_appid NUMBER := -1,
40 prog_id NUMBER := -1,
41 req_id NUMBER := -1,
42 del_rec_flag NUMBER := 1,
43 err_text IN OUT VARCHAR2
44 )
45 return INTEGER;
46
47 END Bom_Substitute_Component_Api;