1 PACKAGE BODY CTO_CUSTOM_CONFIG_NUMBER AS
2 /* $Header: CTOCUCNB.pls 115.0 2003/02/01 02:28:31 ksarkar noship $ */
3 /*============================================================================+
4 | Copyright (c) 1999 Oracle Corporation Belmont, California, USA |
5 | All rights reserved. |
6 | Oracle Manufacturing |
7 +=============================================================================+
8 | |
9 | FILE NAME : CTOCUCNB.pls |
10 | DESCRIPTION : |
11 | Package body for package which enables customers |
12 | to assign customized names to lower level configuration items |
13 | created either during pre-configuration process or autocreate |
14 | Configuration item process. |
15 | |
16 | This function is called only when the BOM parameter |
17 | 'Item Numbering Method' is set to 'User defined' and item |
18 | is either pre-configured or autocreated. |
19 | |
20 | 'user_item_number' function skelton is provided in package |
21 | body which needs to be coded by customer. It accepts |
22 | line id of the model line in so_lines_All or item id of the |
23 | model as input parameter and returns configuration Item name |
24 | as output. Param1 to param5 are dummy parameters which can be |
25 | used in future , if need arises. |
26 | |
27 | It must be ensured that the length of the returned value |
28 | is not more than the length of config_item_segment. |
29 | |
30 | You should also make sure that the item number being |
31 | generated is unique ( ATO code will fail if the item number |
32 | already exists in MTL_SYSTEM_ITEMS table.) |
33 | |
34 | HISTORY : 01/20/03 Kundan Sarkar Initial Creation |
35 | |
36 *============================================================================*/
37
38 g_pkg_name CONSTANT VARCHAR2(30) := 'CTO_CUSTOM_CONFIG_NUMBER';
39
40 function user_item_number (
41 model_item_id IN NUMBER,
42 model_line_id IN NUMBER,
43 param1 IN VARCHAR2 DEFAULT NULL,
44 param2 IN VARCHAR2 DEFAULT NULL,
45 param3 IN VARCHAR2 DEFAULT NULL,
46 param4 IN VARCHAR2 DEFAULT NULL,
47 param5 IN VARCHAR2 DEFAULT NULL
48 )
49 return varchar2 is
50 item_num VARCHAR2(40);
51
52 begin
53 /* Remove this dummy assignment line */
54 item_num := 'MyItem';
55 /* Add code here */
56 return item_num;
57 end user_item_number;
58
59 end CTO_CUSTOM_CONFIG_NUMBER;
60
[Home] [Help]