[Home] [Help]
PACKAGE: APPS.BOM_REFERENCE_DESIGNATOR_API
Source
1 PACKAGE Bom_Reference_Designator_Api AUTHID CURRENT_USER AS
2 /* $Header: BOMOIRDS.pls 115.4 2002/06/14 22:13:15 rfarook ship $ */
3 /*==========================================================================+
4 | Copyright (c) 1997 Oracle Corporation Redwood Shores, California, USA |
5 | All rights reserved. |
6 +===========================================================================+
7 | |
8 | File Name : BOMOIRDS.pls |
9 | DESCRIPTION : This package contains functions used to assign, validate |
10 | and transact Reference Designator data in the |
11 | BOM_REF_DESGS_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 | user_id user id |
17 | login_id login id |
18 | prog_appid program application_id |
19 | prog_id program id |
20 | req_id request_id |
21 | del_rec_flag 1 - Delete records w/ process_flag =7 |
22 | 2 - Do no delete these records |
23 | History: |
24 | 03/06/97 Julie Maeyama Created this new package |
25 +==========================================================================*/
26
27 G_Insert CONSTANT VARCHAR2(10) := 'CREATE'; -- transaction type
28 G_Update CONSTANT VARCHAR2(10) := 'UPDATE'; -- transaction type
29 G_Delete CONSTANT VARCHAR2(10) := 'DELETE'; -- transaction type
30 G_NullChar CONSTANT VARCHAR2(10) := fnd_global.local_chr(12); -- null value
31 G_NullNum CONSTANT NUMBER := 9.99E125; -- null value
32 G_NullDate CONSTANT DATE := to_date('1','j'); -- null value
33 G_rows_to_commit CONSTANT NUMBER := 500;
34
35
36 FUNCTION Import_Reference_Designator (
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_Reference_Designator_Api;