PACKAGE: APPS.CTO_UPDATE_ITEMS_PK

Source

1 package CTO_UPDATE_ITEMS_PK AUTHID CURRENT_USER as
2 /* $Header: CTOUITMS.pls 120.1 2010/11/11 11:55:36 abhissri ship $ */
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 	--Bugfix 10240482: Adding new parameter p_max_seq
24 	p_max_seq IN number,
25 	xReturnStatus OUT NOCOPY varchar2,
26 	xMsgCount OUT NOCOPY number,
27 	xMsgData  OUT NOCOPY varchar2);
28 
29 
30 PROCEDURE Update_Bcso(
31 	p_ato_line_id IN number,
32 	l_return_status OUT NOCOPY varchar2,
33 	l_msg_count OUT NOCOPY number,
34 	l_msg_data OUT NOCOPY varchar2);
35 
36 
37 PROCEDURE Update_Acc_Items(
38 	xReturnStatus OUT NOCOPY varchar2,
39 	xMsgCount OUT NOCOPY number,
40 	xMsgData OUT NOCOPY varchar2);
41 
42 function get_attribute_control( p_attribute_name in varchar2)
43 return number;
44 
45 function get_cost_group( pOrgId  in number,
46                          pLineID in number)
47 return integer;
48 
49 
50 PROCEDURE Update_Item_Data(
51 	p_cat_id IN number,
52 	xReturnStatus OUT NOCOPY varchar2,
53 	xMsgCount OUT NOCOPY number,
54 	xMsgData OUT NOCOPY varchar2);
55 
56 
57 PROCEDURE Update_Pc_Items(
58 	xReturnStatus OUT NOCOPY varchar2,
59 	xMsgCount OUT NOCOPY number,
60 	xMsgData OUT NOCOPY varchar2);
61 
62 
63 PROCEDURE WriteToLog (p_message in varchar2 default null,
64 		      p_level   in number default 0);
65 
66 
67 end CTO_UPDATE_ITEMS_PK;