[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;