1 PACKAGE AHL_PRD_SERN_CHANGE_PVT AS
2 /* $Header: AHLVSNCS.pls 120.2 2008/03/05 23:29:59 adivenka ship $ */
3
4 ---------------------------------------------------------------------
5 -- Define Record Types for record structures needed by the APIs --
6 ---------------------------------------------------------------------
7
8 TYPE Sernum_Change_Rec_Type IS RECORD (
9 WORKORDER_ID NUMBER ,
10 JOB_NUMBER VARCHAR2(80) ,
11 ITEM_NUMBER VARCHAR2(40) ,
12 NEW_ITEM_NUMBER VARCHAR2(40) ,
13 NEW_LOT_NUMBER VARCHAR2(30) ,
14 NEW_ITEM_REV_NUMBER VARCHAR2(3) ,
15 OSP_LINE_ID NUMBER ,
16 INSTANCE_ID NUMBER ,
17 CURRENT_SERIAL_NUMBER VARCHAR2(30) ,
18 CURRENT_SERAIL_TAG VARCHAR2(80) ,
19 NEW_SERIAL_NUMBER VARCHAR2(30) ,
20 NEW_SERIAL_TAG_CODE VARCHAR2(30) ,
21 NEW_SERIAL_TAG_MEAN VARCHAR2(80)
22 );
23
24 ----------------------------------------------
25 -- Define Table Type for records structures --
26 ----------------------------------------------
27 TYPE Sernum_Change_Tbl_Type IS TABLE OF Sernum_Change_Rec_Type INDEX BY BINARY_INTEGER;
28
29 -- Function to Get Serial Tag Code
30 FUNCTION get_serialtag_code
31 (
32 p_instance_id IN NUMBER
33 ) RETURN VARCHAR2;
34 --Function to get Serial Tag Meaning
35 FUNCTION get_serialtag_meaning
36 (
37 p_instance_id IN NUMBER
38 ) RETURN VARCHAR2;
39
40 -- Start of Comments --
41 -- Procedure name : Process_Serialnum_Change
42 -- Type : Private
43 -- Function :
44 -- Pre-reqs :
45 -- Parameters :
46 --
47 -- Standard IN Parameters :
48 -- p_api_version IN NUMBER Required
49 -- p_init_msg_list IN VARCHAR2 Default FND_API.G_FALSE
50 -- p_commit IN VARCHAR2 Default FND_API.G_FALSE
51 -- p_validation_level IN NUMBER Default FND_API.G_VALID_LEVEL_FULL
52 -- Based on this flag, the API will set the default attributes.
53 -- p_module_type In VARCHAR2 Default NULL
54 -- This will be null.
55 -- Standard OUT Parameters :
56 -- x_return_status OUT VARCHAR2 Required
57 -- x_msg_count OUT NUMBER Required
58 -- x_msg_data OUT VARCHAR2 Required
59 --
60 -- Process_Serialnum_Change Parameters :
61 -- p_serialnum_change_rec IN Serialnum_Change_Rec_Type, Required
62 -- Adithya added the x_warning_msg_tbl parameter: Bug# 6723950
63 -- x_warning_msg_tbl OUT ahl_uc_validation_pub.error_tbl_type
64 -- List of Part number change attributes
65 PROCEDURE Process_Serialnum_Change (
66 p_api_version IN NUMBER,
67 p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
68 p_commit IN VARCHAR2 := FND_API.G_FALSE,
69 p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
70 p_serialnum_change_rec IN Sernum_Change_Rec_Type,
71 x_return_status OUT NOCOPY VARCHAR2,
72 x_msg_count OUT NOCOPY NUMBER,
73 x_msg_data OUT NOCOPY VARCHAR2,
74 --Adithya added the x_warning_msg_tbl parameter: Bug# 6683990
75 x_warning_msg_tbl OUT NOCOPY ahl_uc_validation_pub.error_tbl_type);
76
77 END AHL_PRD_SERN_CHANGE_PVT;