1 package body CTO_CUSTOM_SUPPLY_CHECK_PK as
2 /* $Header: CTOCUSCB.pls 120.1 2005/06/02 13:49:35 appldev $*/
3
4 /*----------------------------------------------------------------------------+
5 | Copyright (c) 2003 Oracle Corporation redwood shores, California, USA
6 | All rights reserved.
7 | Oracle Manufacturing
8 |
9 |FILE NAME : CTOCUSCB.pls
10 |
11 |DESCRIPTION : This package is a customization hook to get an input |
12 | regarding the ownership of creating supply |
13 |
14 | This prcoedure should return |
15 | Y, if CTO can recommend creation of Supply . |
16 | N, if CTO is not supposed to recommend creation of supply
17 | (planning will recommend creation of supply) |
18 | |
19 | If 'N' is returned CTO will not recommend creation of supply
20 | and leave the decision to planning |
21 |
22 | If 'Y' is returned CTO will perform its OWN intelligence and |
23 | decide if it can recommend the supply or leave the decision to
24 | planning
25 | |
26 | Input parameters
27 | 1.invetory_item_id of the item for which supply needs to be
28 | created
29 | 2. Current organization(ship from organization) id in which |
30 | supply is desired |
31 |
32 | Output parameters
33 | 'Y' or 'N'
34 | |
35 | |
36 | HISTORY : 09/05/2003 Kiran Konada |
37 | 06/01/2005 Renga Kannan |
38 | Added NOCOPY hint to all OUT parameters.
39 | |
40 | |
41 *============================================================================*/
42
43
44
45 PROCEDURE Check_Supply(
46 P_in_params_rec IN CTO_CUSTOM_SUPPLY_CHECK_PK.in_params_rec_type,
47 X_out_params_rec OUT NOCOPY CTO_CUSTOM_SUPPLY_CHECK_PK.out_params_rec_type,
48 X_return_status OUT NOCOPY varchar2,
49 X_msg_count OUT NOCOPY number,
50 X_msg_data OUT NOCOPY varchar2
51
52 )
53 IS
54
55 BEGIN
56 /*----------------------------------------------------------------+
57 This procedure can be replaced by custom code that will return
58 either Y or N
59 Y, means CTO do its own intelligence and decide if CTO can recommend
60 the creation of supply or planning needs to do the recommendation
61 N, if CTO is not supposed to recommend creation of supply
62 (planning will recommend creation of supply)
63
64 By default : Y is answer, CTO will decide who recommends the creation of
65 supply
66 +-----------------------------------------------------------------*/
67
68 X_return_status := FND_API.G_RET_STS_SUCCESS;
69 X_out_params_rec.can_cto_create_supply := 'Y';
70
71 END Check_Supply;
72
73 END CTO_CUSTOM_SUPPLY_CHECK_PK ;
74