1 PACKAGE PSB_POSITION_ASSIGNMENTS_PVT AS
2 /* $Header: PSBVPOAS.pls 120.2 2005/07/13 11:28:54 shtripat ship $ */
3
4 --
5 --
6 -- T A B L E H A N D L E R S
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,
16 p_msg_data OUT NOCOPY varchar2,
17 p_rowid in OUT NOCOPY varchar2,
18 p_position_assignment_id in OUT NOCOPY number,
19 p_data_extract_id in number,
20 p_worksheet_id in number,
21 p_position_id in number,
22 p_assignment_type in varchar2,
23 p_attribute_id in number,
24 p_attribute_value_id in number,
25 p_attribute_value in varchar2,
26 p_pay_element_id in number,
27 p_pay_element_option_id in number,
28 p_effective_start_date in date,
29 p_effective_end_date in date,
30 p_element_value_type in 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'
40 );
41 --
42 --
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,
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,
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 );
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,
80 p_msg_data OUT NOCOPY varchar2,
81 p_row_locked OUT NOCOPY varchar2,
82 p_position_assignment_id in number,
83 p_data_extract_id in number,
84 p_worksheet_id in number,
85 p_position_id in number,
86 p_assignment_type in varchar2,
87 p_attribute_id in number,
88 p_attribute_value_id in number,
89 p_attribute_value in varchar2,
90 p_pay_element_id in number,
91 p_pay_element_option_id in number,
92 p_effective_start_date in date,
93 p_effective_end_date in date,
94 p_element_value_type in varchar2,
95 p_element_value in number,
96 p_currency_code in varchar2,
97 p_pay_basis in varchar2,
98 p_employee_id in number,
99 p_primary_employee_flag in varchar2,
100 p_global_default_flag in varchar2,
101 p_assignment_default_rule_id in number,
102 p_modify_flag in varchar2
103 );
104
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,
114 p_msg_data OUT NOCOPY varchar2,
115 p_position_assignment_id in number
116 );
117 --
118 --
119 --
120 FUNCTION get_debug RETURN VARCHAR2;
121 --
122 END PSB_POSITION_ASSIGNMENTS_PVT ;