PACKAGE: APPS.BOM_ROUTINGINTERFACE_PUB

Source

1 PACKAGE BOM_RoutingInterface_PUB AUTHID CURRENT_USER AS
2 /* $Header: BOMPRTGS.pls 120.1 2005/06/21 12:12:02 rfarook noship $ */
3 
4 -- Start of comments
5 --	API name 	: ImportRouting
6 --	Type		: Public.
7 --	Function	: Imports routings from open interface tables
8 --	Pre-reqs	: None.
9 --	Parameters	:
10 --	IN		:
11 --	  p_api_version         NUMBER	 	Required
12 --	  p_init_msg_list	VARCHAR2 	Optional
13 --	    Default = FND_API.G_FALSE
14 --	  p_commit    		VARCHAR2	Optional
15 --	    Default = FND_API.G_FALSE
16 --	  p_validation_level	NUMBER		Optional
17 --	    Default = FND_API.G_VALID_LEVEL_FULL
18 --	  p_organization_id  	NUMBER		Required
19 --	  p_commit_rows  	NUMBER		Optional  Default = 500
20 --	  p_delete_rows  	VARCHAR2	Optional
21 --	    Default = FND_API.G_FALSE
22 --	  p_all_organizations  	VARCHAR2	Optional
23 --	    Default = FND_API.G_TRUE
24 --
25 --	OUT		:
26 --	  x_return_status	OUT	VARCHAR2(1)
27 --	  x_msg_count		OUT	NUMBER
28 --	  x_msg_data		OUT	VARCHAR2(2000)
29 --
30 --
31 --	Version	: Current version	1.0
32 --		  Initial version 	1.0
33 --
34 --	Notes		:
35 --	  When p_commit = true, commits will be issued after every
36 --	  p_commit_rows are transacted.
37 --
38 --	  When p_delete_rows = true, successfully processed interface table
39 --	  rows will be deleted.  Rows with errors will still remain
40 --
41 --	  When p_all_organizations = false, only interface table rows for the
42 --	  specified organization id will be processed.
43 --
44 -- End of comments
45 
46 -- Constants
47 G_Insert constant varchar2(10) := 'INSERT'; -- transaction type
48 G_Update constant varchar2(10) := 'UPDATE'; -- transaction type
49 G_Delete constant varchar2(10) := 'DELETE'; -- transaction type
50 G_NullChar constant varchar2(10) := 'empty'; -- null value
51 G_NullNum constant number := -999999; -- null value
52 G_NullDate constant date :=
53   to_date('1900/01/01 00:00:00', 'yyyy/mm/dd hh24:mi:ss'); -- null value
54 G_RtgDelEntity constant varchar2(30) := 'BOM_OP_ROUTINGS_INTERFACE';
55 G_OprDelEntity constant varchar2(30) := 'BOM_OP_SEQUENCES_INTERFACE';
56 
57 PROCEDURE ImportRouting(
58   p_api_version         IN	NUMBER,
59   p_init_msg_list	IN	VARCHAR2	:= FND_API.G_FALSE,
60   p_commit	    	IN  	VARCHAR2 	:= FND_API.G_FALSE,
61   p_validation_level	IN  	NUMBER		:= FND_API.G_VALID_LEVEL_FULL,
62   x_return_status	IN OUT NOCOPY VARCHAR2,
63   x_msg_count		IN OUT NOCOPY NUMBER,
64   x_msg_data		IN OUT NOCOPY VARCHAR2,
65   p_organization_id  	IN	NUMBER,
66   p_all_organizations  	IN	VARCHAR2 	:= FND_API.G_TRUE,
67   p_commit_rows	    	IN  	NUMBER 		:= 500,
68   p_delete_rows	    	IN  	VARCHAR2 	:= FND_API.G_FALSE
69 );
70 
71 END BOM_RoutingInterface_PUB;