5: G_DBUG VARCHAR2(2000) := 'start';
6:
7: PROCEDURE DELETE_ROW (
8: p_api_version in number,
9: p_init_msg_list in varchar2 := fnd_api.g_false,
10: p_commit in varchar2 := fnd_api.g_false,
11: p_validation_level in number := fnd_api.g_valid_level_full,
12: p_return_status OUT NOCOPY varchar2,
13: p_msg_count OUT NOCOPY number,
6:
7: PROCEDURE DELETE_ROW (
8: p_api_version in number,
9: p_init_msg_list in varchar2 := fnd_api.g_false,
10: p_commit in varchar2 := fnd_api.g_false,
11: p_validation_level in number := fnd_api.g_valid_level_full,
12: p_return_status OUT NOCOPY varchar2,
13: p_msg_count OUT NOCOPY number,
14: p_msg_data OUT NOCOPY varchar2,
7: PROCEDURE DELETE_ROW (
8: p_api_version in number,
9: p_init_msg_list in varchar2 := fnd_api.g_false,
10: p_commit in varchar2 := fnd_api.g_false,
11: p_validation_level in number := fnd_api.g_valid_level_full,
12: p_return_status OUT NOCOPY varchar2,
13: p_msg_count OUT NOCOPY number,
14: p_msg_data OUT NOCOPY varchar2,
15: p_position_id in number
31: --
32:
33: PROCEDURE DELETE_ROW (
34: p_api_version in number,
35: p_init_msg_list in varchar2 := fnd_api.g_false,
36: p_commit in varchar2 := fnd_api.g_false,
37: p_validation_level in number := fnd_api.g_valid_level_full,
38: p_return_status OUT NOCOPY varchar2,
39: p_msg_count OUT NOCOPY number,
32:
33: PROCEDURE DELETE_ROW (
34: p_api_version in number,
35: p_init_msg_list in varchar2 := fnd_api.g_false,
36: p_commit in varchar2 := fnd_api.g_false,
37: p_validation_level in number := fnd_api.g_valid_level_full,
38: p_return_status OUT NOCOPY varchar2,
39: p_msg_count OUT NOCOPY number,
40: p_msg_data OUT NOCOPY varchar2,
33: PROCEDURE DELETE_ROW (
34: p_api_version in number,
35: p_init_msg_list in varchar2 := fnd_api.g_false,
36: p_commit in varchar2 := fnd_api.g_false,
37: p_validation_level in number := fnd_api.g_valid_level_full,
38: p_return_status OUT NOCOPY varchar2,
39: p_msg_count OUT NOCOPY number,
40: p_msg_data OUT NOCOPY varchar2,
41: p_distribution_id in number
57: --
58:
59: PROCEDURE LOCK_ROW (
60: p_api_version in number,
61: p_init_msg_list in varchar2 := fnd_api.g_false,
62: p_commit in varchar2 := fnd_api.g_false,
63: p_validation_level in number := fnd_api.g_valid_level_full,
64: p_return_status OUT NOCOPY varchar2,
65: p_msg_count OUT NOCOPY number,
58:
59: PROCEDURE LOCK_ROW (
60: p_api_version in number,
61: p_init_msg_list in varchar2 := fnd_api.g_false,
62: p_commit in varchar2 := fnd_api.g_false,
63: p_validation_level in number := fnd_api.g_valid_level_full,
64: p_return_status OUT NOCOPY varchar2,
65: p_msg_count OUT NOCOPY number,
66: p_msg_data OUT NOCOPY varchar2,
59: PROCEDURE LOCK_ROW (
60: p_api_version in number,
61: p_init_msg_list in varchar2 := fnd_api.g_false,
62: p_commit in varchar2 := fnd_api.g_false,
63: p_validation_level in number := fnd_api.g_valid_level_full,
64: p_return_status OUT NOCOPY varchar2,
65: p_msg_count OUT NOCOPY number,
66: p_msg_data OUT NOCOPY varchar2,
67: p_row_locked OUT NOCOPY varchar2,
102:
103: PROCEDURE LOCK_ROW (
104:
105: p_api_version in number,
106: p_init_msg_list in varchar2 := fnd_api.g_false,
107: p_commit in varchar2 := fnd_api.g_false,
108: p_validation_level in number := fnd_api.g_valid_level_full,
109: p_return_status OUT NOCOPY varchar2,
110: p_msg_count OUT NOCOPY number,
103: PROCEDURE LOCK_ROW (
104:
105: p_api_version in number,
106: p_init_msg_list in varchar2 := fnd_api.g_false,
107: p_commit in varchar2 := fnd_api.g_false,
108: p_validation_level in number := fnd_api.g_valid_level_full,
109: p_return_status OUT NOCOPY varchar2,
110: p_msg_count OUT NOCOPY number,
111: p_msg_data OUT NOCOPY varchar2,
104:
105: p_api_version in number,
106: p_init_msg_list in varchar2 := fnd_api.g_false,
107: p_commit in varchar2 := fnd_api.g_false,
108: p_validation_level in number := fnd_api.g_valid_level_full,
109: p_return_status OUT NOCOPY varchar2,
110: p_msg_count OUT NOCOPY number,
111: p_msg_data OUT NOCOPY varchar2,
112: p_row_locked OUT NOCOPY varchar2,
189:
190:
191: PROCEDURE UPDATE_ROW (
192: p_api_version in number,
193: p_init_msg_list in varchar2 := fnd_api.g_false,
194: p_commit in varchar2 := fnd_api.g_false,
195: p_validation_level in number := fnd_api.g_valid_level_full,
196: p_return_status OUT NOCOPY varchar2,
197: p_msg_count OUT NOCOPY number,
190:
191: PROCEDURE UPDATE_ROW (
192: p_api_version in number,
193: p_init_msg_list in varchar2 := fnd_api.g_false,
194: p_commit in varchar2 := fnd_api.g_false,
195: p_validation_level in number := fnd_api.g_valid_level_full,
196: p_return_status OUT NOCOPY varchar2,
197: p_msg_count OUT NOCOPY number,
198: p_msg_data OUT NOCOPY varchar2,
191: PROCEDURE UPDATE_ROW (
192: p_api_version in number,
193: p_init_msg_list in varchar2 := fnd_api.g_false,
194: p_commit in varchar2 := fnd_api.g_false,
195: p_validation_level in number := fnd_api.g_valid_level_full,
196: p_return_status OUT NOCOPY varchar2,
197: p_msg_count OUT NOCOPY number,
198: p_msg_data OUT NOCOPY varchar2,
199: p_position_id in number,
278:
279: --
280: PROCEDURE INSERT_ROW (
281: p_api_version in number,
282: p_init_msg_list in varchar2 := fnd_api.g_false,
283: p_commit in varchar2 := fnd_api.g_false,
284: p_validation_level in number := fnd_api.g_valid_level_full,
285: p_return_status OUT NOCOPY varchar2,
286: p_msg_count OUT NOCOPY number,
279: --
280: PROCEDURE INSERT_ROW (
281: p_api_version in number,
282: p_init_msg_list in varchar2 := fnd_api.g_false,
283: p_commit in varchar2 := fnd_api.g_false,
284: p_validation_level in number := fnd_api.g_valid_level_full,
285: p_return_status OUT NOCOPY varchar2,
286: p_msg_count OUT NOCOPY number,
287: p_msg_data OUT NOCOPY varchar2,
280: PROCEDURE INSERT_ROW (
281: p_api_version in number,
282: p_init_msg_list in varchar2 := fnd_api.g_false,
283: p_commit in varchar2 := fnd_api.g_false,
284: p_validation_level in number := fnd_api.g_valid_level_full,
285: p_return_status OUT NOCOPY varchar2,
286: p_msg_count OUT NOCOPY number,
287: p_msg_data OUT NOCOPY varchar2,
288: p_rowid in OUT NOCOPY varchar2,