7: --
8:
9: PROCEDURE INSERT_ROW (
10: p_api_version in number,
11: p_init_msg_list in varchar2 := fnd_api.g_false,
12: p_commit in varchar2 := fnd_api.g_false,
13: p_validation_level in number := fnd_api.g_valid_level_full,
14: p_return_status OUT NOCOPY varchar2,
15: p_msg_count OUT NOCOPY number,
8:
9: PROCEDURE INSERT_ROW (
10: p_api_version in number,
11: p_init_msg_list in varchar2 := fnd_api.g_false,
12: p_commit in varchar2 := fnd_api.g_false,
13: p_validation_level in number := fnd_api.g_valid_level_full,
14: p_return_status OUT NOCOPY varchar2,
15: p_msg_count OUT NOCOPY number,
16: p_msg_data OUT NOCOPY varchar2,
9: PROCEDURE INSERT_ROW (
10: p_api_version in number,
11: p_init_msg_list in varchar2 := fnd_api.g_false,
12: p_commit in varchar2 := fnd_api.g_false,
13: p_validation_level in number := fnd_api.g_valid_level_full,
14: p_return_status OUT NOCOPY varchar2,
15: p_msg_count OUT NOCOPY number,
16: p_msg_data OUT NOCOPY varchar2,
17: p_rowid in OUT NOCOPY varchar2,
31: p_element_value in number,
32: p_currency_code in varchar2,
33: p_pay_basis in varchar2,
34: p_employee_id in number,
35: p_primary_employee_flag in varchar2 := FND_API.G_MISS_CHAR,
36: p_global_default_flag in varchar2,
37: p_assignment_default_rule_id in number,
38: p_modify_flag in varchar2,
39: p_mode in varchar2 default 'R'
43: --
44:
45: PROCEDURE UPDATE_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 UPDATE_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 UPDATE_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: p_position_assignment_id in number,
50: p_return_status OUT NOCOPY varchar2,
51: p_msg_count OUT NOCOPY number,
52: p_msg_data OUT NOCOPY varchar2,
53: p_position_assignment_id in number,
54: p_pay_element_id in number := FND_API.G_MISS_NUM,
55: p_pay_element_option_id in number := FND_API.G_MISS_NUM,
56: p_attribute_value_id in number := FND_API.G_MISS_NUM,
57: p_attribute_value in varchar2 := FND_API.G_MISS_CHAR,
58: p_effective_start_date in date := FND_API.G_MISS_DATE,
51: p_msg_count OUT NOCOPY number,
52: p_msg_data OUT NOCOPY varchar2,
53: p_position_assignment_id in number,
54: p_pay_element_id in number := FND_API.G_MISS_NUM,
55: p_pay_element_option_id in number := FND_API.G_MISS_NUM,
56: p_attribute_value_id in number := FND_API.G_MISS_NUM,
57: p_attribute_value in varchar2 := FND_API.G_MISS_CHAR,
58: p_effective_start_date in date := FND_API.G_MISS_DATE,
59: p_effective_end_date in date := FND_API.G_MISS_DATE,
52: p_msg_data OUT NOCOPY varchar2,
53: p_position_assignment_id in number,
54: p_pay_element_id in number := FND_API.G_MISS_NUM,
55: p_pay_element_option_id in number := FND_API.G_MISS_NUM,
56: p_attribute_value_id in number := FND_API.G_MISS_NUM,
57: p_attribute_value in varchar2 := FND_API.G_MISS_CHAR,
58: p_effective_start_date in date := FND_API.G_MISS_DATE,
59: p_effective_end_date in date := FND_API.G_MISS_DATE,
60: p_element_value_type in varchar2 := FND_API.G_MISS_CHAR,
53: p_position_assignment_id in number,
54: p_pay_element_id in number := FND_API.G_MISS_NUM,
55: p_pay_element_option_id in number := FND_API.G_MISS_NUM,
56: p_attribute_value_id in number := FND_API.G_MISS_NUM,
57: p_attribute_value in varchar2 := FND_API.G_MISS_CHAR,
58: p_effective_start_date in date := FND_API.G_MISS_DATE,
59: p_effective_end_date in date := FND_API.G_MISS_DATE,
60: p_element_value_type in varchar2 := FND_API.G_MISS_CHAR,
61: p_element_value in number := FND_API.G_MISS_NUM,
54: p_pay_element_id in number := FND_API.G_MISS_NUM,
55: p_pay_element_option_id in number := FND_API.G_MISS_NUM,
56: p_attribute_value_id in number := FND_API.G_MISS_NUM,
57: p_attribute_value in varchar2 := FND_API.G_MISS_CHAR,
58: p_effective_start_date in date := FND_API.G_MISS_DATE,
59: p_effective_end_date in date := FND_API.G_MISS_DATE,
60: p_element_value_type in varchar2 := FND_API.G_MISS_CHAR,
61: p_element_value in number := FND_API.G_MISS_NUM,
62: p_pay_basis in varchar2 := FND_API.G_MISS_CHAR,
55: p_pay_element_option_id in number := FND_API.G_MISS_NUM,
56: p_attribute_value_id in number := FND_API.G_MISS_NUM,
57: p_attribute_value in varchar2 := FND_API.G_MISS_CHAR,
58: p_effective_start_date in date := FND_API.G_MISS_DATE,
59: p_effective_end_date in date := FND_API.G_MISS_DATE,
60: p_element_value_type in varchar2 := FND_API.G_MISS_CHAR,
61: p_element_value in number := FND_API.G_MISS_NUM,
62: p_pay_basis in varchar2 := FND_API.G_MISS_CHAR,
63: p_employee_id in number := FND_API.G_MISS_NUM,
56: p_attribute_value_id in number := FND_API.G_MISS_NUM,
57: p_attribute_value in varchar2 := FND_API.G_MISS_CHAR,
58: p_effective_start_date in date := FND_API.G_MISS_DATE,
59: p_effective_end_date in date := FND_API.G_MISS_DATE,
60: p_element_value_type in varchar2 := FND_API.G_MISS_CHAR,
61: p_element_value in number := FND_API.G_MISS_NUM,
62: p_pay_basis in varchar2 := FND_API.G_MISS_CHAR,
63: p_employee_id in number := FND_API.G_MISS_NUM,
64: p_primary_employee_flag in varchar2 := FND_API.G_MISS_CHAR,
57: p_attribute_value in varchar2 := FND_API.G_MISS_CHAR,
58: p_effective_start_date in date := FND_API.G_MISS_DATE,
59: p_effective_end_date in date := FND_API.G_MISS_DATE,
60: p_element_value_type in varchar2 := FND_API.G_MISS_CHAR,
61: p_element_value in number := FND_API.G_MISS_NUM,
62: p_pay_basis in varchar2 := FND_API.G_MISS_CHAR,
63: p_employee_id in number := FND_API.G_MISS_NUM,
64: p_primary_employee_flag in varchar2 := FND_API.G_MISS_CHAR,
65: p_global_default_flag in varchar2 := FND_API.G_MISS_CHAR,
58: p_effective_start_date in date := FND_API.G_MISS_DATE,
59: p_effective_end_date in date := FND_API.G_MISS_DATE,
60: p_element_value_type in varchar2 := FND_API.G_MISS_CHAR,
61: p_element_value in number := FND_API.G_MISS_NUM,
62: p_pay_basis in varchar2 := FND_API.G_MISS_CHAR,
63: p_employee_id in number := FND_API.G_MISS_NUM,
64: p_primary_employee_flag in varchar2 := FND_API.G_MISS_CHAR,
65: p_global_default_flag in varchar2 := FND_API.G_MISS_CHAR,
66: p_assignment_default_rule_id in number := FND_API.G_MISS_NUM,
59: p_effective_end_date in date := FND_API.G_MISS_DATE,
60: p_element_value_type in varchar2 := FND_API.G_MISS_CHAR,
61: p_element_value in number := FND_API.G_MISS_NUM,
62: p_pay_basis in varchar2 := FND_API.G_MISS_CHAR,
63: p_employee_id in number := FND_API.G_MISS_NUM,
64: p_primary_employee_flag in varchar2 := FND_API.G_MISS_CHAR,
65: p_global_default_flag in varchar2 := FND_API.G_MISS_CHAR,
66: p_assignment_default_rule_id in number := FND_API.G_MISS_NUM,
67: p_modify_flag in varchar2,
60: p_element_value_type in varchar2 := FND_API.G_MISS_CHAR,
61: p_element_value in number := FND_API.G_MISS_NUM,
62: p_pay_basis in varchar2 := FND_API.G_MISS_CHAR,
63: p_employee_id in number := FND_API.G_MISS_NUM,
64: p_primary_employee_flag in varchar2 := FND_API.G_MISS_CHAR,
65: p_global_default_flag in varchar2 := FND_API.G_MISS_CHAR,
66: p_assignment_default_rule_id in number := FND_API.G_MISS_NUM,
67: p_modify_flag in varchar2,
68: p_mode in varchar2 default 'R'
61: p_element_value in number := FND_API.G_MISS_NUM,
62: p_pay_basis in varchar2 := FND_API.G_MISS_CHAR,
63: p_employee_id in number := FND_API.G_MISS_NUM,
64: p_primary_employee_flag in varchar2 := FND_API.G_MISS_CHAR,
65: p_global_default_flag in varchar2 := FND_API.G_MISS_CHAR,
66: p_assignment_default_rule_id in number := FND_API.G_MISS_NUM,
67: p_modify_flag in varchar2,
68: p_mode in varchar2 default 'R'
69: );
62: p_pay_basis in varchar2 := FND_API.G_MISS_CHAR,
63: p_employee_id in number := FND_API.G_MISS_NUM,
64: p_primary_employee_flag in varchar2 := FND_API.G_MISS_CHAR,
65: p_global_default_flag in varchar2 := FND_API.G_MISS_CHAR,
66: p_assignment_default_rule_id in number := FND_API.G_MISS_NUM,
67: p_modify_flag in varchar2,
68: p_mode in varchar2 default 'R'
69: );
70: --
71:
72:
73: PROCEDURE LOCK_ROW (
74: p_api_version in number,
75: p_init_msg_list in varchar2 := fnd_api.g_false,
76: p_commit in varchar2 := fnd_api.g_false,
77: p_validation_level in number := fnd_api.g_valid_level_full,
78: p_return_status OUT NOCOPY varchar2,
79: p_msg_count OUT NOCOPY number,
72:
73: PROCEDURE LOCK_ROW (
74: p_api_version in number,
75: p_init_msg_list in varchar2 := fnd_api.g_false,
76: p_commit in varchar2 := fnd_api.g_false,
77: p_validation_level in number := fnd_api.g_valid_level_full,
78: p_return_status OUT NOCOPY varchar2,
79: p_msg_count OUT NOCOPY number,
80: p_msg_data OUT NOCOPY varchar2,
73: PROCEDURE LOCK_ROW (
74: p_api_version in number,
75: p_init_msg_list in varchar2 := fnd_api.g_false,
76: p_commit in varchar2 := fnd_api.g_false,
77: p_validation_level in number := fnd_api.g_valid_level_full,
78: p_return_status OUT NOCOPY varchar2,
79: p_msg_count OUT NOCOPY number,
80: p_msg_data OUT NOCOPY varchar2,
81: p_row_locked OUT NOCOPY varchar2,
105: --
106: --
107: PROCEDURE DELETE_ROW (
108: p_api_version in number,
109: p_init_msg_list in varchar2 := fnd_api.g_false,
110: p_commit in varchar2 := fnd_api.g_false,
111: p_validation_level in number := fnd_api.g_valid_level_full,
112: p_return_status OUT NOCOPY varchar2,
113: p_msg_count OUT NOCOPY number,
106: --
107: PROCEDURE DELETE_ROW (
108: p_api_version in number,
109: p_init_msg_list in varchar2 := fnd_api.g_false,
110: p_commit in varchar2 := fnd_api.g_false,
111: p_validation_level in number := fnd_api.g_valid_level_full,
112: p_return_status OUT NOCOPY varchar2,
113: p_msg_count OUT NOCOPY number,
114: p_msg_data OUT NOCOPY varchar2,
107: PROCEDURE DELETE_ROW (
108: p_api_version in number,
109: p_init_msg_list in varchar2 := fnd_api.g_false,
110: p_commit in varchar2 := fnd_api.g_false,
111: p_validation_level in number := fnd_api.g_valid_level_full,
112: p_return_status OUT NOCOPY varchar2,
113: p_msg_count OUT NOCOPY number,
114: p_msg_data OUT NOCOPY varchar2,
115: p_position_assignment_id in number