1 PACKAGE MTL_CCEOI_ACTION_PVT AS
2 /* $Header: INVVCCAS.pls 120.1 2005/06/19 23:22:48 appldev ship $ */
3 --
4 -- Insert the given row into the interface table.
5 --Added NOCOPY hint to x_return_status,x_msg_count,x_msg_data OUT
6 --parameters to comply with GSCC File.Sql.39 standard. Bug:4410902
7 PROCEDURE Export_CountRequest(
8 p_api_version IN NUMBER ,
9 p_init_msg_list IN VARCHAR2 DEFAULT FND_API.G_FALSE,
10 p_commit IN VARCHAR2 DEFAULT FND_API.G_FALSE,
11 p_validation_level IN NUMBER DEFAULT FND_API.G_VALID_LEVEL_FULL,
12 x_return_status OUT NOCOPY VARCHAR2 ,
13 x_msg_count OUT NOCOPY NUMBER ,
14 x_msg_data OUT NOCOPY VARCHAR2 ,
15 p_interface_rec IN MTL_CCEOI_VAR_PVT.INV_CCEOI_TYPE )
16 ;
17 --
18 -- Create unscheduled count requests
19 --Added NOCOPY hint to x_return_status,x_msg_count,x_msg_data OUT
20 --parameters to comply with GSCC File.Sql.39 standard. Bug:4410902
21 PROCEDURE Create_CountRequest(
22 p_api_version IN NUMBER ,
23 p_init_msg_list IN VARCHAR2 DEFAULT FND_API.G_FALSE,
24 p_commit IN VARCHAR2 DEFAULT FND_API.G_FALSE,
25 p_validation_level IN NUMBER DEFAULT FND_API.G_VALID_LEVEL_FULL,
26 x_return_status OUT NOCOPY VARCHAR2 ,
27 x_msg_count OUT NOCOPY NUMBER ,
28 x_msg_data OUT NOCOPY VARCHAR2 ,
29 p_simulate IN VARCHAR2 DEFAULT FND_API.G_FALSE,
30 p_interface_rec IN MTL_CCEOI_VAR_PVT.INV_CCEOI_TYPE )
31 ;
32 --
33 -- processed count request from the interface table
34 --Added NOCOPY hint to x_return_status,x_msg_count,x_msg_data OUT
35 --parameters to comply with GSCC File.Sql.39 standard. Bug:4410902
36 PROCEDURE Process_CountRequest(
37 p_api_version IN NUMBER ,
38 p_init_msg_list IN VARCHAR2 DEFAULT FND_API.G_FALSE,
39 p_commit IN VARCHAR2 DEFAULT FND_API.G_FALSE,
40 p_validation_level IN NUMBER DEFAULT FND_API.G_VALID_LEVEL_FULL,
41 x_return_status OUT NOCOPY VARCHAR2 ,
42 x_msg_count OUT NOCOPY NUMBER ,
43 x_msg_data OUT NOCOPY VARCHAR2 ,
44 p_simulate IN VARCHAR2 DEFAULT FND_API.G_FALSE,
45 p_interface_rec IN MTL_CCEOI_VAR_PVT.INV_CCEOI_TYPE )
46 ;
47 --
48 -- Validate the records in the interface table
49 --Added NOCOPY hint to x_return_status,x_msg_count,x_msg_data OUT
50 --parameters to comply with GSCC File.Sql.39 standard. Bug:4410902
51 PROCEDURE Validate_CountRequest(
52 p_api_version IN NUMBER ,
53 p_init_msg_list IN VARCHAR2 DEFAULT FND_API.G_FALSE,
54 p_commit IN VARCHAR2 DEFAULT FND_API.G_FALSE,
55 p_validation_level IN NUMBER DEFAULT FND_API.G_VALID_LEVEL_NONE,
56 x_return_status OUT NOCOPY VARCHAR2 ,
57 x_msg_count OUT NOCOPY NUMBER ,
58 x_msg_data OUT NOCOPY VARCHAR2 ,
59 p_interface_rec IN MTL_CCEOI_VAR_PVT.INV_CCEOI_TYPE )
60 ;
61 --
62 -- validates and simulates records from interface table
63 --Added NOCOPY hint to x_return_status,x_msg_count,x_msg_data OUT
64 --parameters to comply with GSCC File.Sql.39 standard. Bug:4410902
65 PROCEDURE ValSim_CountRequest(
66 p_api_version IN NUMBER ,
67 p_init_msg_list IN VARCHAR2 DEFAULT FND_API.G_FALSE,
68 p_commit IN VARCHAR2 DEFAULT FND_API.G_FALSE,
69 p_validation_level IN NUMBER DEFAULT FND_API.G_VALID_LEVEL_FULL,
70 x_return_status OUT NOCOPY VARCHAR2 ,
71 x_msg_count OUT NOCOPY NUMBER ,
72 x_msg_data OUT NOCOPY VARCHAR2 ,
73 p_interface_rec IN MTL_CCEOI_VAR_PVT.INV_CCEOI_TYPE )
74 ;
75 --
76 -- Updated or inserted the interface record table
77 --Added NOCOPY hint to x_return_status,x_msg_count,x_msg_data OUT
78 --parameters to comply with GSCC File.Sql.39 standard. Bug:4410902
79 PROCEDURE Update_Insert_CountRequest(
80 p_api_version IN NUMBER ,
81 p_init_msg_list IN VARCHAR2 DEFAULT FND_API.G_FALSE,
82 p_commit IN VARCHAR2 DEFAULT FND_API.G_FALSE,
83 p_validation_level IN NUMBER DEFAULT FND_API.G_VALID_LEVEL_FULL,
84 x_return_status OUT NOCOPY VARCHAR2 ,
85 x_msg_count OUT NOCOPY NUMBER ,
86 x_msg_data OUT NOCOPY VARCHAR2 ,
87 p_interface_rec IN MTL_CCEOI_VAR_PVT.INV_CCEOI_TYPE )
88 ;
89 END MTL_CCEOI_ACTION_PVT;