1 PACKAGE RCV_INSPECTION_GRP AS
2 /* $Header: rcvginss.pls 120.4.12010000.1 2008/07/24 14:43:39 appldev ship $*/
3 --
4 -- API name : RCV_INSPECTION_GRP.INSERT_INSPECTION
5 --
6 -- Type : Group.
7 --
8 -- Function : This API serves to insert inspection transaction
9 -- to the po interface table
10 --
11 -- Pre-reqs : None.
12 --
13 -- Parameters :
14 --
15 -- IN : p_api_version IN NUMBER Required
16 -- p_init_msg_list IN VARCHAR2 Optional
17 -- Default = FND_API.G_FALSE
18 -- p_commit IN VARCHAR2 Optional
19 -- Default = FND_API.G_FALSE
20 -- p_validation_level IN NUMBER Optional
21 -- Default = FND_API.G_VALID_LEVEL_FULL
22 -- p_created_by IN NUMBER Required
23 -- p_last_updated_by IN NUMBER Required
24 -- p_last_update_login IN NUMBER Required
25 -- p_employee_id IN NUMBER Required
26 -- p_group_id IN NUMBER Required
27 -- (Transaction Group Id)
28 -- p_transaction_id IN NUMBER Required
29 -- (Parent Transaction Id)
30 -- p_transaction_type IN VARCHAR2 Required
31 -- (Reject or Accept)
32 -- p_processing_mode IN VARCHAR2 Required
33 -- ( 'ONLINE, 'IMMEDIATE', or 'BATCH')
34 -- p_quantity IN VARCHAR2 Required
35 -- p_uom IN VARCHAR2 Required
36 -- p_quality_code IN VARCHAR2 Optional
37 -- Default = NULL
38 -- p_transaction_date IN DATE Required
39 -- p_comments IN VARCHAR2 Optional
40 -- Default = NULL
41 -- p_reason_id IN NUMBER Optional
42 -- Default = NULL
43 -- p_vendor_lot IN VARCHAR2 Optional
44 -- Default = NULL
45 -- p_lpn_id IN NUMBER Optional
46 -- Default = NULL
47 -- p_transfer_lpn_id IN NUMBER Optional
48 -- Default = NULL
49 --
50 -- p_qa_collection_id IN NUMBER Required
51 -- OUT : p_return_status OUT VARCHAR2(1)
52 -- 'S' -- success
53 -- 'U' -- unsuccess
54 -- p_msg_count OUT NUMBER
55 -- p_msg_data OUT VARCHAR2(2000)
56 --
57 -- Version : Current version 1.1
58 -- previous version 1.0
59 -- Initial version 1.0
60 -- History : 1.1 - Added lpn_id and transfer_lpn_id
61 --
62 -- Notes : User should pass the current version value to p_api_version
63 -- If user needs to commit, pass 'T' to p_commit.
64 --
65
66 PROCEDURE Insert_Inspection
67 ( p_api_version IN NUMBER ,
68 p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE ,
69 p_commit IN VARCHAR2 := FND_API.G_FALSE ,
70 p_validation_level IN NUMBER :=
71 FND_API.G_VALID_LEVEL_FULL ,
72 p_created_by IN NUMBER ,
73 p_last_updated_by IN NUMBER ,
74 p_last_update_login IN NUMBER ,
75 p_employee_id IN NUMBER ,
76 p_group_id IN NUMBER ,
77 p_transaction_id IN NUMBER ,
78 p_transaction_type IN VARCHAR2 ,
79 p_processing_mode IN VARCHAR2 ,
80 p_quantity IN NUMBER ,
81 p_uom IN VARCHAR2 ,
82 p_quality_code IN VARCHAR2 := NULL ,
83 p_transaction_date IN DATE ,
84 p_comments IN VARCHAR2 := NULL ,
85 p_reason_id IN NUMBER := NULL ,
86 p_vendor_lot IN VARCHAR2 := NULL ,
87 p_qa_collection_id IN NUMBER ,
88 p_lpn_id IN NUMBER := NULL,
89 p_transfer_lpn_id IN NUMBER := NULL,
90 p_from_subinventory IN VARCHAR2 DEFAULT NULL , -- Added bug # 6529950
91 p_from_locator_id IN NUMBER DEFAULT NULL , -- Added bug # 6529950
92 p_subinventory IN VARCHAR2 DEFAULT NULL , -- Added bug # 6529950
93 p_locator_id IN NUMBER DEFAULT NULL , -- Added bug # 6529950
94 p_return_status OUT NOCOPY VARCHAR2 ,
95 p_msg_count OUT NOCOPY NUMBER ,
96 p_msg_data OUT NOCOPY VARCHAR2
97
98 );
99
100
101 END;