1 PACKAGE user_pkg_serial AS
2 /* $Header: INVUDSGS.pls 120.0 2005/05/25 04:43:51 appldev noship $ */
3 /*#
4 * The user defined serial generation procedures allow users to create Serial
5 * Numbers in the system using the logic defined by them, as opposed to the
6 * standard Oracle serial number generation logic.
7 * @rep:scope public
8 * @rep:product INV
9 * @rep:lifecycle active
10 * @rep:displayname User Defined Serial Generation API
11 * @rep:category BUSINESS_ENTITY INV_SERIAL_NUMBER
12 */
13
14 -- PROCEDURE: generate_serial_number
15 -- INPUTS:
16 -- 1) p_org_id: Organization_id is supplied in this parameter
17 -- 2) p_item_id: Inventory_item_id is supplied in this parameter
18
19 -- OUTPUTS:
20 -- 1) x_serial_number: Serial NUMBER created using the User defined
21 -- logic should be returned IN this variable.
22 -- Note that the serial Number returned should not be greater than 30 characters.
23 --
24 -- 2) x_return_status: on successful generation of the serial number using
25 -- the User defined logic, this variable needs TO be assigned the value
26 -- FND_API.G_RET_STS_SUCCESS and returned.
27 -- All other return values returned in the varaible are interpreted as error
28 -- by the calling program
29 --
30 --
31
32 /*#
33 * Use this procedure to define the logic to be used by the system
34 * when generating the serial numbers. This procedure is invoked by the
35 * system while generating a serial number if the serial generation
36 * level is set as 'User Defined' for a particular organization. The
37 * user needs to fill in the logic for generating a serial number in
38 * the stub provided and apply the package to the database.
39 * @ param x_return_status Return status indicating success or failure
40 * @ paraminfo {@rep:required}
41 * @ param x_msg_data Return the error message in case of failure
42 * @ paraminfo {@rep:required}
43 * @ param x_msg_count Return message count from the error stack in case of failure
44 * @ paraminfo {@rep:required}
45 * @ param x_serial_number Return the serial number to be generated
46 * @ paraminfo {@rep:required}
47 * @ param p_org_id Organization Id is passed as input in this variable
48 * @ paraminfo {@rep:required}
49 * @ param p_item_id Inventory Item id passed as input in this variable
50 * @ paraminfo {@rep:required}
51 * @rep:scope public
52 * @rep:lifecycle active
53 * @rep:displayname Generate User Defined Serial Number
54 */
55 procedure generate_serial_number(x_return_status OUT NOCOPY VARCHAR2
56 ,x_msg_data OUT NOCOPY VARCHAR2
57 ,x_msg_count OUT NOCOPY NUMBER
58 ,x_serial_number OUT NOCOPY VARCHAR2
59 ,p_org_id IN NUMBER
60 ,p_item_id IN NUMBER);
61 END user_pkg_serial;