1 package CTO_CUSTOM_SUPPLY_CHECK_PK as
2 /* $Header: CTOCUSCS.pls 120.1 2005/06/02 13:51:31 appldev $*/
3
4 /*----------------------------------------------------------------------------+
5 | Copyright (c) 2003 Oracle Corporation redwood shores, California, USA
6 | All rights reserved.
7 | Oracle Manufacturing
8 |
9 |FILE NAME : CTOCUSCS.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 | |
38 | 06/01/2005 Renga Kannan |
39 | Added NOCOPY hint to all OUT parameters.
40 | |
41 *============================================================================*/
42
43
44 TYPE in_params_rec_type IS RECORD
45 (
46 CONFIG_ITEM_ID number,
47 Org_id number
48 );
49
50 TYPE out_params_rec_type IS RECORD
51 (
52 can_cto_create_supply Varchar2(1)
53 );
54
55
56 /*---------------------------------------------------------------------------+
57 This prcoedure should return
58 Y, if CTO can recommend creation of Supply .
59 N, if CTO is not supposed to recommend creation of supply
60 (planning will recommend creation of supply)
61
62
63 ----------------------------------------------------------------------------*/
64
65
66 PROCEDURE Check_Supply(
67 P_in_params_rec IN CTO_CUSTOM_SUPPLY_CHECK_PK.in_params_rec_type,
68 X_out_params_rec OUT NOCOPY CTO_CUSTOM_SUPPLY_CHECK_PK.out_params_rec_type,
69 X_return_status OUT NOCOPY varchar2,
70 X_msg_count OUT NOCOPY number,
71 X_msg_data OUT NOCOPY varchar2
72
73 );
74
75 end CTO_CUSTOM_SUPPLY_CHECK_PK;