DBA Data[Home] [Help]

APPS.PSB_POSITION_ASSIGNMENTS_PVT dependencies on FND_API

Line 11: p_init_msg_list in varchar2 := fnd_api.g_false,

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,

Line 12: p_commit in varchar2 := fnd_api.g_false,

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,

Line 13: p_validation_level in number := fnd_api.g_valid_level_full,

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,

Line 35: p_primary_employee_flag in varchar2 := FND_API.G_MISS_CHAR,

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'

Line 47: p_init_msg_list in varchar2 := fnd_api.g_false,

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,

Line 48: p_commit in varchar2 := fnd_api.g_false,

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,

Line 49: p_validation_level in number := fnd_api.g_valid_level_full,

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,

Line 54: p_pay_element_id in number := FND_API.G_MISS_NUM,

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,

Line 55: p_pay_element_option_id in number := FND_API.G_MISS_NUM,

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,

Line 56: p_attribute_value_id in number := FND_API.G_MISS_NUM,

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,

Line 57: p_attribute_value 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,

Line 58: p_effective_start_date in date := FND_API.G_MISS_DATE,

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,

Line 59: p_effective_end_date in date := FND_API.G_MISS_DATE,

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,

Line 60: p_element_value_type in varchar2 := FND_API.G_MISS_CHAR,

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,

Line 61: p_element_value 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,
65: p_global_default_flag in varchar2 := FND_API.G_MISS_CHAR,

Line 62: p_pay_basis 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,

Line 63: p_employee_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,

Line 64: p_primary_employee_flag in varchar2 := FND_API.G_MISS_CHAR,

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'

Line 65: p_global_default_flag 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'
69: );

Line 66: p_assignment_default_rule_id 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: );
70: --

Line 75: p_init_msg_list in varchar2 := fnd_api.g_false,

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,

Line 76: p_commit in varchar2 := fnd_api.g_false,

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,

Line 77: p_validation_level in number := fnd_api.g_valid_level_full,

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,

Line 109: p_init_msg_list in varchar2 := fnd_api.g_false,

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,

Line 110: p_commit in varchar2 := fnd_api.g_false,

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,

Line 111: p_validation_level in number := fnd_api.g_valid_level_full,

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