3:
4:
5: PROCEDURE INSERT_ROW
6: ( p_api_version IN NUMBER,
7: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
8: p_commit IN VARCHAR2 := FND_API.G_FALSE,
9: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
10: p_return_status OUT NOCOPY VARCHAR2,
11: p_msg_count OUT NOCOPY NUMBER,
4:
5: PROCEDURE INSERT_ROW
6: ( p_api_version IN NUMBER,
7: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
8: p_commit IN VARCHAR2 := FND_API.G_FALSE,
9: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
10: p_return_status OUT NOCOPY VARCHAR2,
11: p_msg_count OUT NOCOPY NUMBER,
12: p_msg_data OUT NOCOPY VARCHAR2,
5: PROCEDURE INSERT_ROW
6: ( p_api_version IN NUMBER,
7: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
8: p_commit IN VARCHAR2 := FND_API.G_FALSE,
9: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
10: p_return_status OUT NOCOPY VARCHAR2,
11: p_msg_count OUT NOCOPY NUMBER,
12: p_msg_data OUT NOCOPY VARCHAR2,
13: --
24: );
25:
26: PROCEDURE UPDATE_ROW
27: ( p_api_version IN NUMBER,
28: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
29: p_commit IN VARCHAR2 := FND_API.G_FALSE,
30: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
31: p_return_status OUT NOCOPY VARCHAR2,
32: p_msg_count OUT NOCOPY NUMBER,
25:
26: PROCEDURE UPDATE_ROW
27: ( p_api_version IN NUMBER,
28: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
29: p_commit IN VARCHAR2 := FND_API.G_FALSE,
30: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
31: p_return_status OUT NOCOPY VARCHAR2,
32: p_msg_count OUT NOCOPY NUMBER,
33: p_msg_data OUT NOCOPY VARCHAR2,
26: PROCEDURE UPDATE_ROW
27: ( p_api_version IN NUMBER,
28: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
29: p_commit IN VARCHAR2 := FND_API.G_FALSE,
30: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
31: p_return_status OUT NOCOPY VARCHAR2,
32: p_msg_count OUT NOCOPY NUMBER,
33: p_msg_data OUT NOCOPY VARCHAR2,
34: --
43: );
44:
45: PROCEDURE DELETE_ROW
46: ( p_api_version IN NUMBER,
47: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
48: p_commit IN VARCHAR2 := FND_API.G_FALSE,
49: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
50: p_return_status OUT NOCOPY VARCHAR2,
51: p_msg_count OUT NOCOPY NUMBER,
44:
45: PROCEDURE DELETE_ROW
46: ( p_api_version IN NUMBER,
47: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
48: p_commit IN VARCHAR2 := FND_API.G_FALSE,
49: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
50: p_return_status OUT NOCOPY VARCHAR2,
51: p_msg_count OUT NOCOPY NUMBER,
52: p_msg_data OUT NOCOPY VARCHAR2,
45: PROCEDURE DELETE_ROW
46: ( p_api_version IN NUMBER,
47: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
48: p_commit IN VARCHAR2 := FND_API.G_FALSE,
49: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
50: p_return_status OUT NOCOPY VARCHAR2,
51: p_msg_count OUT NOCOPY NUMBER,
52: p_msg_data OUT NOCOPY VARCHAR2,
53: --
56: );
57:
58: PROCEDURE LOCK_ROW
59: ( p_api_version IN NUMBER,
60: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
61: p_commit IN VARCHAR2 := FND_API.G_FALSE,
62: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
63: p_return_status OUT NOCOPY VARCHAR2,
64: p_msg_count OUT NOCOPY NUMBER,
57:
58: PROCEDURE LOCK_ROW
59: ( p_api_version IN NUMBER,
60: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
61: p_commit IN VARCHAR2 := FND_API.G_FALSE,
62: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
63: p_return_status OUT NOCOPY VARCHAR2,
64: p_msg_count OUT NOCOPY NUMBER,
65: p_msg_data OUT NOCOPY VARCHAR2,
58: PROCEDURE LOCK_ROW
59: ( p_api_version IN NUMBER,
60: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
61: p_commit IN VARCHAR2 := FND_API.G_FALSE,
62: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
63: p_return_status OUT NOCOPY VARCHAR2,
64: p_msg_count OUT NOCOPY NUMBER,
65: p_msg_data OUT NOCOPY VARCHAR2,
66: --
75:
76: PROCEDURE Check_Unique
77: (
78: p_api_version IN NUMBER,
79: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
80: p_commit IN VARCHAR2 := FND_API.G_FALSE,
81: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
82: p_return_status OUT NOCOPY VARCHAR2,
83: p_msg_count OUT NOCOPY NUMBER,
76: PROCEDURE Check_Unique
77: (
78: p_api_version IN NUMBER,
79: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
80: p_commit IN VARCHAR2 := FND_API.G_FALSE,
81: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
82: p_return_status OUT NOCOPY VARCHAR2,
83: p_msg_count OUT NOCOPY NUMBER,
84: p_msg_data OUT NOCOPY VARCHAR2,
77: (
78: p_api_version IN NUMBER,
79: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
80: p_commit IN VARCHAR2 := FND_API.G_FALSE,
81: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
82: p_return_status OUT NOCOPY VARCHAR2,
83: p_msg_count OUT NOCOPY NUMBER,
84: p_msg_data OUT NOCOPY VARCHAR2,
85: --
93:
94: PROCEDURE Check_References
95: (
96: p_api_version IN NUMBER,
97: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
98: p_commit IN VARCHAR2 := FND_API.G_FALSE,
99: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
100: p_return_status OUT NOCOPY VARCHAR2,
101: p_msg_count OUT NOCOPY NUMBER,
94: PROCEDURE Check_References
95: (
96: p_api_version IN NUMBER,
97: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
98: p_commit IN VARCHAR2 := FND_API.G_FALSE,
99: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
100: p_return_status OUT NOCOPY VARCHAR2,
101: p_msg_count OUT NOCOPY NUMBER,
102: p_msg_data OUT NOCOPY VARCHAR2,
95: (
96: p_api_version IN NUMBER,
97: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
98: p_commit IN VARCHAR2 := FND_API.G_FALSE,
99: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
100: p_return_status OUT NOCOPY VARCHAR2,
101: p_msg_count OUT NOCOPY NUMBER,
102: p_msg_data OUT NOCOPY VARCHAR2,
103: --