[Home] [Help]
PACKAGE: APPS.BOM_OPEN_INTERFACE_UTL
Source
1 PACKAGE Bom_Open_Interface_Utl AUTHID CURRENT_USER AS
2 /* $Header: BOMUBOIS.pls 120.2 2005/09/08 09:22:11 dikrishn ship $ */
3 /***************************************************************************
4 --
5 -- Copyright (c) 1996 Oracle Corporation, Redwood Shores, CA, USA
6 -- All rights reserved.
7 --
8 -- FILENAME
9 --
10 -- BOMUBOIS.pls
11 --
12 -- DESCRIPTION
13 --
14 -- Spec of package Bom_Open_Interface_Utl
15 --
16 -- NOTES
17 --
18 -- HISTORY
19 --
20 -- 22-NOV-02 Vani Hymavathi Initial Creation
21 -- 01-JUN-05 Bhavnesh Patel Added Batch Id
22 ***************************************************************************/
23 G_Create CONSTANT VARCHAR2(10) := 'CREATE'; -- transaction type
24 G_Update CONSTANT VARCHAR2(10) := 'UPDATE'; -- transaction type
25 G_Delete CONSTANT VARCHAR2(10) := 'DELETE'; -- transaction type
26 G_NoOp CONSTANT VARCHAR2(10) := 'NO_OP'; -- transaction type
27
28
29 FUNCTION Process_Header_Info (
30 org_id NUMBER,
31 all_org NUMBER ,
32 user_id NUMBER,
33 login_id NUMBER,
34 prog_appid NUMBER,
35 prog_id NUMBER,
36 req_id NUMBER,
37 err_text IN OUT NOCOPY VARCHAR2,
38 p_batch_id IN NUMBER
39 )
40 return INTEGER ;
41
42 FUNCTION Process_Comps_Info (
43 org_id NUMBER,
44 all_org NUMBER ,
45 user_id NUMBER,
46 login_id NUMBER,
47 prog_appid NUMBER,
48 prog_id NUMBER,
49 req_id NUMBER,
50 err_text IN OUT NOCOPY VARCHAR2,
51 p_batch_id IN NUMBER
52 )
53 return INTEGER;
54
55 FUNCTION Process_Ref_Degs_Info (
56 org_id NUMBER,
57 all_org NUMBER ,
58 user_id NUMBER,
59 login_id NUMBER,
60 prog_appid NUMBER,
61 prog_id NUMBER,
62 req_id NUMBER,
63 err_text IN OUT NOCOPY VARCHAR2,
64 p_batch_id IN NUMBER
65 )
66 return INTEGER;
67
68 FUNCTION Process_Sub_Comps_Info (
69 org_id NUMBER,
70 all_org NUMBER ,
71 user_id NUMBER,
72 login_id NUMBER,
73 prog_appid NUMBER,
74 prog_id NUMBER,
75 req_id NUMBER,
76 err_text IN OUT NOCOPY VARCHAR2,
77 p_batch_id IN NUMBER
78 )
79 return INTEGER;
80
81 FUNCTION Process_Comp_Ops_Info (
82 org_id NUMBER,
83 all_org NUMBER ,
84 user_id NUMBER,
85 login_id NUMBER,
86 prog_appid NUMBER,
87 prog_id NUMBER,
88 req_id NUMBER,
89 err_text IN OUT NOCOPY VARCHAR2,
90 p_batch_id IN NUMBER
91 )
92 return INTEGER;
93
94 FUNCTION Process_Revision_Info(
95 org_id NUMBER,
96 all_org NUMBER ,
97 user_id NUMBER,
98 login_id NUMBER,
99 prog_appid NUMBER,
100 prog_id NUMBER,
101 req_id NUMBER,
102 err_text IN OUT NOCOPY VARCHAR2,
103 p_set_process_id IN NUMBER
104 )
105 return INTEGER;
106
107 --process entities with null batch id
108 FUNCTION Process_All_Entities(
109 org_id NUMBER,
110 all_org NUMBER ,
111 user_id NUMBER,
112 login_id NUMBER,
113 prog_appid NUMBER,
114 prog_id NUMBER,
115 req_id NUMBER,
116 err_text IN OUT NOCOPY VARCHAR2
117 )
118 return INTEGER;
119
120 --process entities for given batch id
121 FUNCTION Process_All_Entities(
122 org_id NUMBER,
123 all_org NUMBER ,
124 user_id NUMBER,
125 login_id NUMBER,
126 prog_appid NUMBER,
127 prog_id NUMBER,
128 req_id NUMBER,
129 err_text IN OUT NOCOPY VARCHAR2,
130 p_batch_id IN NUMBER
131 )
132 return INTEGER;
133
134 END Bom_Open_Interface_Utl;