DBA Data[Home] [Help]

PACKAGE: APPS.CTO_UPDATE_ITEMS_PK

Source


1 package CTO_UPDATE_ITEMS_PK AUTHID CURRENT_USER as
2 /* $Header: CTOUITMS.pls 115.4 2004/01/28 01:16:00 rekannan noship $ */
3 
4 /*-----------------------------------------------------------------------------
5 |  Copyright (c) 1993 Oracle Corporation    Belmont, California, USA
6 |                        All rights reserved.
7 |                        Oracle Manufacturing
8 |-----------------------------------------------------------------------------
9 |
10 | File name   : CTOITSCS.pls
11 | Description :
12 |
13 | History     : Created On : 11-OCT-2003 by Sajani Sheth
14 |
15 +------------------------------------------------------------------------------*/
16 gDebugLevel NUMBER :=  to_number(nvl(FND_PROFILE.value('ONT_DEBUG_LEVEL'),0));
17 
18 
19 PROCEDURE Update_Items_And_Sourcing(
20 	p_changed_src IN varchar2,
21 	p_cat_id IN number,
22 	p_upgrade_mode IN Number,
23 	xReturnStatus OUT NOCOPY varchar2,
24 	xMsgCount OUT NOCOPY number,
25 	xMsgData  OUT NOCOPY varchar2);
26 
27 
28 PROCEDURE Update_Bcso(
29 	p_ato_line_id IN number,
30 	l_return_status OUT NOCOPY varchar2,
31 	l_msg_count OUT NOCOPY number,
32 	l_msg_data OUT NOCOPY varchar2);
33 
34 
35 PROCEDURE Update_Acc_Items(
36 	xReturnStatus OUT NOCOPY varchar2,
37 	xMsgCount OUT NOCOPY number,
38 	xMsgData OUT NOCOPY varchar2);
39 
40 function get_attribute_control( p_attribute_name in varchar2)
41 return number;
42 
43 function get_cost_group( pOrgId  in number,
44                          pLineID in number)
45 return integer;
46 
47 
48 PROCEDURE Update_Item_Data(
49 	p_cat_id IN number,
50 	xReturnStatus OUT NOCOPY varchar2,
51 	xMsgCount OUT NOCOPY number,
52 	xMsgData OUT NOCOPY varchar2);
53 
54 
55 PROCEDURE Update_Pc_Items(
56 	xReturnStatus OUT NOCOPY varchar2,
57 	xMsgCount OUT NOCOPY number,
58 	xMsgData OUT NOCOPY varchar2);
59 
60 
61 PROCEDURE WriteToLog (p_message in varchar2 default null,
62 		      p_level   in number default 0);
63 
64 
65 end CTO_UPDATE_ITEMS_PK;