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 ,
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 ,
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 )
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 ,
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 ,
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,
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 ,
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 ,
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,
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 ,
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 ,
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 )
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 ,
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 ,
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 )
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 ,
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 ,
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 )