2: /* $Header: PSBVPYDS.pls 120.3 2005/10/14 16:33:17 matthoma ship $ */
3:
4: PROCEDURE INSERT_ROW
5: ( p_api_version IN NUMBER,
6: p_init_msg_list IN VARCHAR2 := fnd_api.g_false,
7: p_commit IN VARCHAR2 := fnd_api.g_false,
8: p_validation_level IN NUMBER := fnd_api.g_valid_level_full,
9: p_return_status OUT NOCOPY VARCHAR2,
10: p_msg_count OUT NOCOPY NUMBER,
3:
4: PROCEDURE INSERT_ROW
5: ( p_api_version IN NUMBER,
6: p_init_msg_list IN VARCHAR2 := fnd_api.g_false,
7: p_commit IN VARCHAR2 := fnd_api.g_false,
8: p_validation_level IN NUMBER := fnd_api.g_valid_level_full,
9: p_return_status OUT NOCOPY VARCHAR2,
10: p_msg_count OUT NOCOPY NUMBER,
11: p_msg_data OUT NOCOPY VARCHAR2,
4: PROCEDURE INSERT_ROW
5: ( p_api_version IN NUMBER,
6: p_init_msg_list IN VARCHAR2 := fnd_api.g_false,
7: p_commit IN VARCHAR2 := fnd_api.g_false,
8: p_validation_level IN NUMBER := fnd_api.g_valid_level_full,
9: p_return_status OUT NOCOPY VARCHAR2,
10: p_msg_count OUT NOCOPY NUMBER,
11: p_msg_data OUT NOCOPY VARCHAR2,
12: p_rowid IN OUT NOCOPY VARCHAR2,
12: p_rowid IN OUT NOCOPY VARCHAR2,
13: p_distribution_id IN NUMBER,
14: p_position_id IN NUMBER,
15: p_data_extract_id IN NUMBER,
16: p_worksheet_id IN NUMBER := FND_API.G_MISS_NUM,
17: p_effective_start_date IN DATE,
18: p_effective_end_date IN DATE,
19: p_chart_of_accounts_id IN NUMBER,
20: p_code_combination_id IN NUMBER,
20: p_code_combination_id IN NUMBER,
21: p_distribution_percent IN NUMBER,
22: p_global_default_flag IN VARCHAR2,
23: p_distribution_default_rule_id IN NUMBER,
24: p_project_id IN NUMBER:= FND_API.G_MISS_NUM,
25: p_task_id IN NUMBER:= FND_API.G_MISS_NUM,
26: p_award_id IN NUMBER:= FND_API.G_MISS_NUM,
27: p_expenditure_type IN VARCHAR2:= FND_API.G_MISS_CHAR,
28: p_expenditure_organization_id IN NUMBER:= FND_API.G_MISS_NUM,
21: p_distribution_percent IN NUMBER,
22: p_global_default_flag IN VARCHAR2,
23: p_distribution_default_rule_id IN NUMBER,
24: p_project_id IN NUMBER:= FND_API.G_MISS_NUM,
25: p_task_id IN NUMBER:= FND_API.G_MISS_NUM,
26: p_award_id IN NUMBER:= FND_API.G_MISS_NUM,
27: p_expenditure_type IN VARCHAR2:= FND_API.G_MISS_CHAR,
28: p_expenditure_organization_id IN NUMBER:= FND_API.G_MISS_NUM,
29: p_description IN VARCHAR2:= FND_API.G_MISS_CHAR,
22: p_global_default_flag IN VARCHAR2,
23: p_distribution_default_rule_id IN NUMBER,
24: p_project_id IN NUMBER:= FND_API.G_MISS_NUM,
25: p_task_id IN NUMBER:= FND_API.G_MISS_NUM,
26: p_award_id IN NUMBER:= FND_API.G_MISS_NUM,
27: p_expenditure_type IN VARCHAR2:= FND_API.G_MISS_CHAR,
28: p_expenditure_organization_id IN NUMBER:= FND_API.G_MISS_NUM,
29: p_description IN VARCHAR2:= FND_API.G_MISS_CHAR,
30: p_mode in varchar2 default 'R'
23: p_distribution_default_rule_id IN NUMBER,
24: p_project_id IN NUMBER:= FND_API.G_MISS_NUM,
25: p_task_id IN NUMBER:= FND_API.G_MISS_NUM,
26: p_award_id IN NUMBER:= FND_API.G_MISS_NUM,
27: p_expenditure_type IN VARCHAR2:= FND_API.G_MISS_CHAR,
28: p_expenditure_organization_id IN NUMBER:= FND_API.G_MISS_NUM,
29: p_description IN VARCHAR2:= FND_API.G_MISS_CHAR,
30: p_mode in varchar2 default 'R'
31: );
24: p_project_id IN NUMBER:= FND_API.G_MISS_NUM,
25: p_task_id IN NUMBER:= FND_API.G_MISS_NUM,
26: p_award_id IN NUMBER:= FND_API.G_MISS_NUM,
27: p_expenditure_type IN VARCHAR2:= FND_API.G_MISS_CHAR,
28: p_expenditure_organization_id IN NUMBER:= FND_API.G_MISS_NUM,
29: p_description IN VARCHAR2:= FND_API.G_MISS_CHAR,
30: p_mode in varchar2 default 'R'
31: );
32: --
25: p_task_id IN NUMBER:= FND_API.G_MISS_NUM,
26: p_award_id IN NUMBER:= FND_API.G_MISS_NUM,
27: p_expenditure_type IN VARCHAR2:= FND_API.G_MISS_CHAR,
28: p_expenditure_organization_id IN NUMBER:= FND_API.G_MISS_NUM,
29: p_description IN VARCHAR2:= FND_API.G_MISS_CHAR,
30: p_mode in varchar2 default 'R'
31: );
32: --
33: --
34: --
35:
36: PROCEDURE LOCK_ROW (
37: p_api_version IN NUMBER,
38: p_init_msg_list IN VARCHAR2 := fnd_api.g_false,
39: p_commit IN VARCHAR2 := fnd_api.g_false,
40: p_validation_level IN NUMBER := fnd_api.g_valid_level_full,
41: p_return_status OUT NOCOPY VARCHAR2,
42: p_msg_count OUT NOCOPY NUMBER,
35:
36: PROCEDURE LOCK_ROW (
37: p_api_version IN NUMBER,
38: p_init_msg_list IN VARCHAR2 := fnd_api.g_false,
39: p_commit IN VARCHAR2 := fnd_api.g_false,
40: p_validation_level IN NUMBER := fnd_api.g_valid_level_full,
41: p_return_status OUT NOCOPY VARCHAR2,
42: p_msg_count OUT NOCOPY NUMBER,
43: p_msg_data OUT NOCOPY VARCHAR2,
36: PROCEDURE LOCK_ROW (
37: p_api_version IN NUMBER,
38: p_init_msg_list IN VARCHAR2 := fnd_api.g_false,
39: p_commit IN VARCHAR2 := fnd_api.g_false,
40: p_validation_level IN NUMBER := fnd_api.g_valid_level_full,
41: p_return_status OUT NOCOPY VARCHAR2,
42: p_msg_count OUT NOCOPY NUMBER,
43: p_msg_data OUT NOCOPY VARCHAR2,
44: p_row_locked OUT NOCOPY VARCHAR2,
44: p_row_locked OUT NOCOPY VARCHAR2,
45: p_distribution_id IN NUMBER,
46: p_position_id IN NUMBER,
47: p_data_extract_id IN NUMBER,
48: p_worksheet_id IN NUMBER := FND_API.G_MISS_NUM,
49: p_effective_start_date IN DATE,
50: p_effective_end_date IN DATE,
51: p_chart_of_accounts_id IN NUMBER,
52: p_code_combination_id IN NUMBER,
52: p_code_combination_id IN NUMBER,
53: p_distribution_percent IN NUMBER,
54: p_global_default_flag IN VARCHAR2,
55: p_distribution_default_rule_id IN NUMBER,
56: p_project_id IN NUMBER:= FND_API.G_MISS_NUM,
57: p_task_id IN NUMBER:= FND_API.G_MISS_NUM,
58: p_award_id IN NUMBER:= FND_API.G_MISS_NUM,
59: p_expenditure_type IN VARCHAR2:= FND_API.G_MISS_CHAR,
60: p_expenditure_organization_id IN NUMBER:= FND_API.G_MISS_NUM,
53: p_distribution_percent IN NUMBER,
54: p_global_default_flag IN VARCHAR2,
55: p_distribution_default_rule_id IN NUMBER,
56: p_project_id IN NUMBER:= FND_API.G_MISS_NUM,
57: p_task_id IN NUMBER:= FND_API.G_MISS_NUM,
58: p_award_id IN NUMBER:= FND_API.G_MISS_NUM,
59: p_expenditure_type IN VARCHAR2:= FND_API.G_MISS_CHAR,
60: p_expenditure_organization_id IN NUMBER:= FND_API.G_MISS_NUM,
61: p_description IN VARCHAR2:= FND_API.G_MISS_CHAR
54: p_global_default_flag IN VARCHAR2,
55: p_distribution_default_rule_id IN NUMBER,
56: p_project_id IN NUMBER:= FND_API.G_MISS_NUM,
57: p_task_id IN NUMBER:= FND_API.G_MISS_NUM,
58: p_award_id IN NUMBER:= FND_API.G_MISS_NUM,
59: p_expenditure_type IN VARCHAR2:= FND_API.G_MISS_CHAR,
60: p_expenditure_organization_id IN NUMBER:= FND_API.G_MISS_NUM,
61: p_description IN VARCHAR2:= FND_API.G_MISS_CHAR
62: );
55: p_distribution_default_rule_id IN NUMBER,
56: p_project_id IN NUMBER:= FND_API.G_MISS_NUM,
57: p_task_id IN NUMBER:= FND_API.G_MISS_NUM,
58: p_award_id IN NUMBER:= FND_API.G_MISS_NUM,
59: p_expenditure_type IN VARCHAR2:= FND_API.G_MISS_CHAR,
60: p_expenditure_organization_id IN NUMBER:= FND_API.G_MISS_NUM,
61: p_description IN VARCHAR2:= FND_API.G_MISS_CHAR
62: );
63:
56: p_project_id IN NUMBER:= FND_API.G_MISS_NUM,
57: p_task_id IN NUMBER:= FND_API.G_MISS_NUM,
58: p_award_id IN NUMBER:= FND_API.G_MISS_NUM,
59: p_expenditure_type IN VARCHAR2:= FND_API.G_MISS_CHAR,
60: p_expenditure_organization_id IN NUMBER:= FND_API.G_MISS_NUM,
61: p_description IN VARCHAR2:= FND_API.G_MISS_CHAR
62: );
63:
64: --
57: p_task_id IN NUMBER:= FND_API.G_MISS_NUM,
58: p_award_id IN NUMBER:= FND_API.G_MISS_NUM,
59: p_expenditure_type IN VARCHAR2:= FND_API.G_MISS_CHAR,
60: p_expenditure_organization_id IN NUMBER:= FND_API.G_MISS_NUM,
61: p_description IN VARCHAR2:= FND_API.G_MISS_CHAR
62: );
63:
64: --
65: --
65: --
66: --
67: PROCEDURE UPDATE_ROW (
68: p_api_version IN NUMBER,
69: p_init_msg_list IN VARCHAR2 := fnd_api.g_false,
70: p_commit IN VARCHAR2 := fnd_api.g_false,
71: p_validation_level IN NUMBER := fnd_api.g_valid_level_full,
72: p_return_status OUT NOCOPY VARCHAR2,
73: p_msg_count OUT NOCOPY NUMBER,
66: --
67: PROCEDURE UPDATE_ROW (
68: p_api_version IN NUMBER,
69: p_init_msg_list IN VARCHAR2 := fnd_api.g_false,
70: p_commit IN VARCHAR2 := fnd_api.g_false,
71: p_validation_level IN NUMBER := fnd_api.g_valid_level_full,
72: p_return_status OUT NOCOPY VARCHAR2,
73: p_msg_count OUT NOCOPY NUMBER,
74: p_msg_data OUT NOCOPY VARCHAR2,
67: PROCEDURE UPDATE_ROW (
68: p_api_version IN NUMBER,
69: p_init_msg_list IN VARCHAR2 := fnd_api.g_false,
70: p_commit IN VARCHAR2 := fnd_api.g_false,
71: p_validation_level IN NUMBER := fnd_api.g_valid_level_full,
72: p_return_status OUT NOCOPY VARCHAR2,
73: p_msg_count OUT NOCOPY NUMBER,
74: p_msg_data OUT NOCOPY VARCHAR2,
75: p_distribution_id IN NUMBER,
73: p_msg_count OUT NOCOPY NUMBER,
74: p_msg_data OUT NOCOPY VARCHAR2,
75: p_distribution_id IN NUMBER,
76: p_code_combination_id IN NUMBER,
77: p_effective_start_date IN DATE := FND_API.G_MISS_DATE,
78: p_effective_end_date IN DATE := FND_API.G_MISS_DATE,
79: p_distribution_percent IN NUMBER,
80: p_global_default_flag IN VARCHAR2,
81: p_distribution_default_rule_id IN NUMBER,
74: p_msg_data OUT NOCOPY VARCHAR2,
75: p_distribution_id IN NUMBER,
76: p_code_combination_id IN NUMBER,
77: p_effective_start_date IN DATE := FND_API.G_MISS_DATE,
78: p_effective_end_date IN DATE := FND_API.G_MISS_DATE,
79: p_distribution_percent IN NUMBER,
80: p_global_default_flag IN VARCHAR2,
81: p_distribution_default_rule_id IN NUMBER,
82: p_project_id IN NUMBER:= FND_API.G_MISS_NUM,
78: p_effective_end_date IN DATE := FND_API.G_MISS_DATE,
79: p_distribution_percent IN NUMBER,
80: p_global_default_flag IN VARCHAR2,
81: p_distribution_default_rule_id IN NUMBER,
82: p_project_id IN NUMBER:= FND_API.G_MISS_NUM,
83: p_task_id IN NUMBER:= FND_API.G_MISS_NUM,
84: p_award_id IN NUMBER:= FND_API.G_MISS_NUM,
85: p_expenditure_type IN VARCHAR2:= FND_API.G_MISS_CHAR,
86: p_expenditure_organization_id IN NUMBER:= FND_API.G_MISS_NUM,
79: p_distribution_percent IN NUMBER,
80: p_global_default_flag IN VARCHAR2,
81: p_distribution_default_rule_id IN NUMBER,
82: p_project_id IN NUMBER:= FND_API.G_MISS_NUM,
83: p_task_id IN NUMBER:= FND_API.G_MISS_NUM,
84: p_award_id IN NUMBER:= FND_API.G_MISS_NUM,
85: p_expenditure_type IN VARCHAR2:= FND_API.G_MISS_CHAR,
86: p_expenditure_organization_id IN NUMBER:= FND_API.G_MISS_NUM,
87: p_description IN VARCHAR2:= FND_API.G_MISS_CHAR,
80: p_global_default_flag IN VARCHAR2,
81: p_distribution_default_rule_id IN NUMBER,
82: p_project_id IN NUMBER:= FND_API.G_MISS_NUM,
83: p_task_id IN NUMBER:= FND_API.G_MISS_NUM,
84: p_award_id IN NUMBER:= FND_API.G_MISS_NUM,
85: p_expenditure_type IN VARCHAR2:= FND_API.G_MISS_CHAR,
86: p_expenditure_organization_id IN NUMBER:= FND_API.G_MISS_NUM,
87: p_description IN VARCHAR2:= FND_API.G_MISS_CHAR,
88: p_mode in varchar2 default 'R'
81: p_distribution_default_rule_id IN NUMBER,
82: p_project_id IN NUMBER:= FND_API.G_MISS_NUM,
83: p_task_id IN NUMBER:= FND_API.G_MISS_NUM,
84: p_award_id IN NUMBER:= FND_API.G_MISS_NUM,
85: p_expenditure_type IN VARCHAR2:= FND_API.G_MISS_CHAR,
86: p_expenditure_organization_id IN NUMBER:= FND_API.G_MISS_NUM,
87: p_description IN VARCHAR2:= FND_API.G_MISS_CHAR,
88: p_mode in varchar2 default 'R'
89: );
82: p_project_id IN NUMBER:= FND_API.G_MISS_NUM,
83: p_task_id IN NUMBER:= FND_API.G_MISS_NUM,
84: p_award_id IN NUMBER:= FND_API.G_MISS_NUM,
85: p_expenditure_type IN VARCHAR2:= FND_API.G_MISS_CHAR,
86: p_expenditure_organization_id IN NUMBER:= FND_API.G_MISS_NUM,
87: p_description IN VARCHAR2:= FND_API.G_MISS_CHAR,
88: p_mode in varchar2 default 'R'
89: );
90: --
83: p_task_id IN NUMBER:= FND_API.G_MISS_NUM,
84: p_award_id IN NUMBER:= FND_API.G_MISS_NUM,
85: p_expenditure_type IN VARCHAR2:= FND_API.G_MISS_CHAR,
86: p_expenditure_organization_id IN NUMBER:= FND_API.G_MISS_NUM,
87: p_description IN VARCHAR2:= FND_API.G_MISS_CHAR,
88: p_mode in varchar2 default 'R'
89: );
90: --
91: --
91: --
92: --
93: PROCEDURE ADD_ROW (
94: p_api_version IN NUMBER,
95: p_init_msg_list IN VARCHAR2 := fnd_api.g_false,
96: p_commit IN VARCHAR2 := fnd_api.g_false,
97: p_validation_level IN NUMBER := fnd_api.g_valid_level_full,
98: p_return_status OUT NOCOPY VARCHAR2,
99: p_msg_count OUT NOCOPY NUMBER,
92: --
93: PROCEDURE ADD_ROW (
94: p_api_version IN NUMBER,
95: p_init_msg_list IN VARCHAR2 := fnd_api.g_false,
96: p_commit IN VARCHAR2 := fnd_api.g_false,
97: p_validation_level IN NUMBER := fnd_api.g_valid_level_full,
98: p_return_status OUT NOCOPY VARCHAR2,
99: p_msg_count OUT NOCOPY NUMBER,
100: p_msg_data OUT NOCOPY VARCHAR2,
93: PROCEDURE ADD_ROW (
94: p_api_version IN NUMBER,
95: p_init_msg_list IN VARCHAR2 := fnd_api.g_false,
96: p_commit IN VARCHAR2 := fnd_api.g_false,
97: p_validation_level IN NUMBER := fnd_api.g_valid_level_full,
98: p_return_status OUT NOCOPY VARCHAR2,
99: p_msg_count OUT NOCOPY NUMBER,
100: p_msg_data OUT NOCOPY VARCHAR2,
101: p_rowid IN OUT NOCOPY VARCHAR2,
109: p_code_combination_id IN NUMBER,
110: p_distribution_percent IN NUMBER,
111: p_global_default_flag IN VARCHAR2,
112: p_distribution_default_rule_id IN NUMBER,
113: p_project_id IN NUMBER:= FND_API.G_MISS_NUM,
114: p_task_id IN NUMBER:= FND_API.G_MISS_NUM,
115: p_award_id IN NUMBER:= FND_API.G_MISS_NUM,
116: p_expenditure_type IN VARCHAR2:= FND_API.G_MISS_CHAR,
117: p_expenditure_organization_id IN NUMBER:= FND_API.G_MISS_NUM,
110: p_distribution_percent IN NUMBER,
111: p_global_default_flag IN VARCHAR2,
112: p_distribution_default_rule_id IN NUMBER,
113: p_project_id IN NUMBER:= FND_API.G_MISS_NUM,
114: p_task_id IN NUMBER:= FND_API.G_MISS_NUM,
115: p_award_id IN NUMBER:= FND_API.G_MISS_NUM,
116: p_expenditure_type IN VARCHAR2:= FND_API.G_MISS_CHAR,
117: p_expenditure_organization_id IN NUMBER:= FND_API.G_MISS_NUM,
118: p_description IN VARCHAR2:= FND_API.G_MISS_CHAR,
111: p_global_default_flag IN VARCHAR2,
112: p_distribution_default_rule_id IN NUMBER,
113: p_project_id IN NUMBER:= FND_API.G_MISS_NUM,
114: p_task_id IN NUMBER:= FND_API.G_MISS_NUM,
115: p_award_id IN NUMBER:= FND_API.G_MISS_NUM,
116: p_expenditure_type IN VARCHAR2:= FND_API.G_MISS_CHAR,
117: p_expenditure_organization_id IN NUMBER:= FND_API.G_MISS_NUM,
118: p_description IN VARCHAR2:= FND_API.G_MISS_CHAR,
119: p_mode in varchar2 default 'R'
112: p_distribution_default_rule_id IN NUMBER,
113: p_project_id IN NUMBER:= FND_API.G_MISS_NUM,
114: p_task_id IN NUMBER:= FND_API.G_MISS_NUM,
115: p_award_id IN NUMBER:= FND_API.G_MISS_NUM,
116: p_expenditure_type IN VARCHAR2:= FND_API.G_MISS_CHAR,
117: p_expenditure_organization_id IN NUMBER:= FND_API.G_MISS_NUM,
118: p_description IN VARCHAR2:= FND_API.G_MISS_CHAR,
119: p_mode in varchar2 default 'R'
120:
113: p_project_id IN NUMBER:= FND_API.G_MISS_NUM,
114: p_task_id IN NUMBER:= FND_API.G_MISS_NUM,
115: p_award_id IN NUMBER:= FND_API.G_MISS_NUM,
116: p_expenditure_type IN VARCHAR2:= FND_API.G_MISS_CHAR,
117: p_expenditure_organization_id IN NUMBER:= FND_API.G_MISS_NUM,
118: p_description IN VARCHAR2:= FND_API.G_MISS_CHAR,
119: p_mode in varchar2 default 'R'
120:
121: );
114: p_task_id IN NUMBER:= FND_API.G_MISS_NUM,
115: p_award_id IN NUMBER:= FND_API.G_MISS_NUM,
116: p_expenditure_type IN VARCHAR2:= FND_API.G_MISS_CHAR,
117: p_expenditure_organization_id IN NUMBER:= FND_API.G_MISS_NUM,
118: p_description IN VARCHAR2:= FND_API.G_MISS_CHAR,
119: p_mode in varchar2 default 'R'
120:
121: );
122: --
123: --
124: --
125: PROCEDURE DELETE_ROW (
126: p_api_version IN NUMBER,
127: p_init_msg_list IN VARCHAR2 := fnd_api.g_false,
128: p_commit IN VARCHAR2 := fnd_api.g_false,
129: p_validation_level IN NUMBER := fnd_api.g_valid_level_full,
130: p_return_status OUT NOCOPY VARCHAR2,
131: p_msg_count OUT NOCOPY NUMBER,
124: --
125: PROCEDURE DELETE_ROW (
126: p_api_version IN NUMBER,
127: p_init_msg_list IN VARCHAR2 := fnd_api.g_false,
128: p_commit IN VARCHAR2 := fnd_api.g_false,
129: p_validation_level IN NUMBER := fnd_api.g_valid_level_full,
130: p_return_status OUT NOCOPY VARCHAR2,
131: p_msg_count OUT NOCOPY NUMBER,
132: p_msg_data OUT NOCOPY VARCHAR2,
125: PROCEDURE DELETE_ROW (
126: p_api_version IN NUMBER,
127: p_init_msg_list IN VARCHAR2 := fnd_api.g_false,
128: p_commit IN VARCHAR2 := fnd_api.g_false,
129: p_validation_level IN NUMBER := fnd_api.g_valid_level_full,
130: p_return_status OUT NOCOPY VARCHAR2,
131: p_msg_count OUT NOCOPY NUMBER,
132: p_msg_data OUT NOCOPY VARCHAR2,
133: p_distribution_id IN NUMBER
135: --
136:
137: PROCEDURE Delete_Distributions
138: ( p_api_version IN NUMBER,
139: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
140: p_commit IN VARCHAR2 := FND_API.G_FALSE,
141: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
142: p_return_status OUT NOCOPY VARCHAR2,
143: p_msg_count OUT NOCOPY NUMBER,
136:
137: PROCEDURE Delete_Distributions
138: ( p_api_version IN NUMBER,
139: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
140: p_commit IN VARCHAR2 := FND_API.G_FALSE,
141: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
142: p_return_status OUT NOCOPY VARCHAR2,
143: p_msg_count OUT NOCOPY NUMBER,
144: p_msg_data OUT NOCOPY VARCHAR2,
137: PROCEDURE Delete_Distributions
138: ( p_api_version IN NUMBER,
139: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
140: p_commit IN VARCHAR2 := FND_API.G_FALSE,
141: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
142: p_return_status OUT NOCOPY VARCHAR2,
143: p_msg_count OUT NOCOPY NUMBER,
144: p_msg_data OUT NOCOPY VARCHAR2,
145: p_data_extract_id IN NUMBER
146: );
147:
148: PROCEDURE Delete_Distributions_Position
149: ( p_api_version IN NUMBER,
150: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
151: p_commit IN VARCHAR2 := FND_API.G_FALSE,
152: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
153: p_return_status OUT NOCOPY VARCHAR2,
154: p_msg_count OUT NOCOPY NUMBER,
147:
148: PROCEDURE Delete_Distributions_Position
149: ( p_api_version IN NUMBER,
150: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
151: p_commit IN VARCHAR2 := FND_API.G_FALSE,
152: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
153: p_return_status OUT NOCOPY VARCHAR2,
154: p_msg_count OUT NOCOPY NUMBER,
155: p_msg_data OUT NOCOPY VARCHAR2,
148: PROCEDURE Delete_Distributions_Position
149: ( p_api_version IN NUMBER,
150: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
151: p_commit IN VARCHAR2 := FND_API.G_FALSE,
152: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
153: p_return_status OUT NOCOPY VARCHAR2,
154: p_msg_count OUT NOCOPY NUMBER,
155: p_msg_data OUT NOCOPY VARCHAR2,
156: p_position_id IN NUMBER,
160: --
161:
162: PROCEDURE Modify_Distribution_WS
163: ( p_api_version IN NUMBER,
164: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
165: p_commit IN VARCHAR2 := FND_API.G_FALSE,
166: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
167: p_return_status OUT NOCOPY VARCHAR2,
168: p_msg_count OUT NOCOPY NUMBER,
161:
162: PROCEDURE Modify_Distribution_WS
163: ( p_api_version IN NUMBER,
164: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
165: p_commit IN VARCHAR2 := FND_API.G_FALSE,
166: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
167: p_return_status OUT NOCOPY VARCHAR2,
168: p_msg_count OUT NOCOPY NUMBER,
169: p_msg_data OUT NOCOPY VARCHAR2,
162: PROCEDURE Modify_Distribution_WS
163: ( p_api_version IN NUMBER,
164: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
165: p_commit IN VARCHAR2 := FND_API.G_FALSE,
166: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
167: p_return_status OUT NOCOPY VARCHAR2,
168: p_msg_count OUT NOCOPY NUMBER,
169: p_msg_data OUT NOCOPY VARCHAR2,
170: p_distribution_id IN OUT NOCOPY NUMBER,
167: p_return_status OUT NOCOPY VARCHAR2,
168: p_msg_count OUT NOCOPY NUMBER,
169: p_msg_data OUT NOCOPY VARCHAR2,
170: p_distribution_id IN OUT NOCOPY NUMBER,
171: p_worksheet_id IN NUMBER := FND_API.G_MISS_NUM,
172: p_position_id IN NUMBER,
173: p_data_extract_id IN NUMBER,
174: p_effective_start_date IN DATE,
175: p_effective_end_date IN DATE,
179: p_distribution_percent IN NUMBER,
180: p_global_default_flag IN VARCHAR2,
181: p_distribution_default_rule_id IN NUMBER,
182: p_rowid IN OUT NOCOPY VARCHAR2,
183: p_project_id IN NUMBER:= FND_API.G_MISS_NUM,
184: p_task_id IN NUMBER:= FND_API.G_MISS_NUM,
185: p_award_id IN NUMBER:= FND_API.G_MISS_NUM,
186: p_expenditure_type IN VARCHAR2:= FND_API.G_MISS_CHAR,
187: p_expenditure_organization_id IN NUMBER:= FND_API.G_MISS_NUM,
180: p_global_default_flag IN VARCHAR2,
181: p_distribution_default_rule_id IN NUMBER,
182: p_rowid IN OUT NOCOPY VARCHAR2,
183: p_project_id IN NUMBER:= FND_API.G_MISS_NUM,
184: p_task_id IN NUMBER:= FND_API.G_MISS_NUM,
185: p_award_id IN NUMBER:= FND_API.G_MISS_NUM,
186: p_expenditure_type IN VARCHAR2:= FND_API.G_MISS_CHAR,
187: p_expenditure_organization_id IN NUMBER:= FND_API.G_MISS_NUM,
188: p_description IN VARCHAR2:= FND_API.G_MISS_CHAR,
181: p_distribution_default_rule_id IN NUMBER,
182: p_rowid IN OUT NOCOPY VARCHAR2,
183: p_project_id IN NUMBER:= FND_API.G_MISS_NUM,
184: p_task_id IN NUMBER:= FND_API.G_MISS_NUM,
185: p_award_id IN NUMBER:= FND_API.G_MISS_NUM,
186: p_expenditure_type IN VARCHAR2:= FND_API.G_MISS_CHAR,
187: p_expenditure_organization_id IN NUMBER:= FND_API.G_MISS_NUM,
188: p_description IN VARCHAR2:= FND_API.G_MISS_CHAR,
189: p_budget_revision_pos_line_id IN NUMBER:= FND_API.G_MISS_NUM,
182: p_rowid IN OUT NOCOPY VARCHAR2,
183: p_project_id IN NUMBER:= FND_API.G_MISS_NUM,
184: p_task_id IN NUMBER:= FND_API.G_MISS_NUM,
185: p_award_id IN NUMBER:= FND_API.G_MISS_NUM,
186: p_expenditure_type IN VARCHAR2:= FND_API.G_MISS_CHAR,
187: p_expenditure_organization_id IN NUMBER:= FND_API.G_MISS_NUM,
188: p_description IN VARCHAR2:= FND_API.G_MISS_CHAR,
189: p_budget_revision_pos_line_id IN NUMBER:= FND_API.G_MISS_NUM,
190: p_mode IN VARCHAR2 default 'R',
183: p_project_id IN NUMBER:= FND_API.G_MISS_NUM,
184: p_task_id IN NUMBER:= FND_API.G_MISS_NUM,
185: p_award_id IN NUMBER:= FND_API.G_MISS_NUM,
186: p_expenditure_type IN VARCHAR2:= FND_API.G_MISS_CHAR,
187: p_expenditure_organization_id IN NUMBER:= FND_API.G_MISS_NUM,
188: p_description IN VARCHAR2:= FND_API.G_MISS_CHAR,
189: p_budget_revision_pos_line_id IN NUMBER:= FND_API.G_MISS_NUM,
190: p_mode IN VARCHAR2 default 'R',
191: p_ruleset_id IN NUMBER := NULL
184: p_task_id IN NUMBER:= FND_API.G_MISS_NUM,
185: p_award_id IN NUMBER:= FND_API.G_MISS_NUM,
186: p_expenditure_type IN VARCHAR2:= FND_API.G_MISS_CHAR,
187: p_expenditure_organization_id IN NUMBER:= FND_API.G_MISS_NUM,
188: p_description IN VARCHAR2:= FND_API.G_MISS_CHAR,
189: p_budget_revision_pos_line_id IN NUMBER:= FND_API.G_MISS_NUM,
190: p_mode IN VARCHAR2 default 'R',
191: p_ruleset_id IN NUMBER := NULL
192: );
185: p_award_id IN NUMBER:= FND_API.G_MISS_NUM,
186: p_expenditure_type IN VARCHAR2:= FND_API.G_MISS_CHAR,
187: p_expenditure_organization_id IN NUMBER:= FND_API.G_MISS_NUM,
188: p_description IN VARCHAR2:= FND_API.G_MISS_CHAR,
189: p_budget_revision_pos_line_id IN NUMBER:= FND_API.G_MISS_NUM,
190: p_mode IN VARCHAR2 default 'R',
191: p_ruleset_id IN NUMBER := NULL
192: );
193:
192: );
193:
194: PROCEDURE Modify_Distribution
195: ( p_api_version IN NUMBER,
196: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
197: p_commit IN VARCHAR2 := FND_API.G_FALSE,
198: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
199: p_return_status OUT NOCOPY VARCHAR2,
200: p_msg_count OUT NOCOPY NUMBER,
193:
194: PROCEDURE Modify_Distribution
195: ( p_api_version IN NUMBER,
196: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
197: p_commit IN VARCHAR2 := FND_API.G_FALSE,
198: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
199: p_return_status OUT NOCOPY VARCHAR2,
200: p_msg_count OUT NOCOPY NUMBER,
201: p_msg_data OUT NOCOPY VARCHAR2,
194: PROCEDURE Modify_Distribution
195: ( p_api_version IN NUMBER,
196: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
197: p_commit IN VARCHAR2 := FND_API.G_FALSE,
198: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
199: p_return_status OUT NOCOPY VARCHAR2,
200: p_msg_count OUT NOCOPY NUMBER,
201: p_msg_data OUT NOCOPY VARCHAR2,
202: p_distribution_id IN OUT NOCOPY NUMBER,
201: p_msg_data OUT NOCOPY VARCHAR2,
202: p_distribution_id IN OUT NOCOPY NUMBER,
203: p_position_id IN NUMBER,
204: p_data_extract_id IN NUMBER,
205: p_worksheet_id IN NUMBER := FND_API.G_MISS_NUM,
206: p_effective_start_date IN DATE,
207: p_effective_end_date IN DATE,
208: p_chart_of_accounts_id IN NUMBER,
209: p_code_combination_id IN NUMBER,
210: p_distribution_percent IN NUMBER,
211: p_global_default_flag IN VARCHAR2,
212: p_distribution_default_rule_id IN NUMBER,
213: p_rowid IN OUT NOCOPY VARCHAR2,
214: p_project_id IN NUMBER:= FND_API.G_MISS_NUM,
215: p_task_id IN NUMBER:= FND_API.G_MISS_NUM,
216: p_award_id IN NUMBER:= FND_API.G_MISS_NUM,
217: p_expenditure_type IN VARCHAR2:= FND_API.G_MISS_CHAR,
218: p_expenditure_organization_id IN NUMBER:= FND_API.G_MISS_NUM,
211: p_global_default_flag IN VARCHAR2,
212: p_distribution_default_rule_id IN NUMBER,
213: p_rowid IN OUT NOCOPY VARCHAR2,
214: p_project_id IN NUMBER:= FND_API.G_MISS_NUM,
215: p_task_id IN NUMBER:= FND_API.G_MISS_NUM,
216: p_award_id IN NUMBER:= FND_API.G_MISS_NUM,
217: p_expenditure_type IN VARCHAR2:= FND_API.G_MISS_CHAR,
218: p_expenditure_organization_id IN NUMBER:= FND_API.G_MISS_NUM,
219: p_description IN VARCHAR2:= FND_API.G_MISS_CHAR,
212: p_distribution_default_rule_id IN NUMBER,
213: p_rowid IN OUT NOCOPY VARCHAR2,
214: p_project_id IN NUMBER:= FND_API.G_MISS_NUM,
215: p_task_id IN NUMBER:= FND_API.G_MISS_NUM,
216: p_award_id IN NUMBER:= FND_API.G_MISS_NUM,
217: p_expenditure_type IN VARCHAR2:= FND_API.G_MISS_CHAR,
218: p_expenditure_organization_id IN NUMBER:= FND_API.G_MISS_NUM,
219: p_description IN VARCHAR2:= FND_API.G_MISS_CHAR,
220: p_mode IN VARCHAR2 default 'R'
213: p_rowid IN OUT NOCOPY VARCHAR2,
214: p_project_id IN NUMBER:= FND_API.G_MISS_NUM,
215: p_task_id IN NUMBER:= FND_API.G_MISS_NUM,
216: p_award_id IN NUMBER:= FND_API.G_MISS_NUM,
217: p_expenditure_type IN VARCHAR2:= FND_API.G_MISS_CHAR,
218: p_expenditure_organization_id IN NUMBER:= FND_API.G_MISS_NUM,
219: p_description IN VARCHAR2:= FND_API.G_MISS_CHAR,
220: p_mode IN VARCHAR2 default 'R'
221: );
214: p_project_id IN NUMBER:= FND_API.G_MISS_NUM,
215: p_task_id IN NUMBER:= FND_API.G_MISS_NUM,
216: p_award_id IN NUMBER:= FND_API.G_MISS_NUM,
217: p_expenditure_type IN VARCHAR2:= FND_API.G_MISS_CHAR,
218: p_expenditure_organization_id IN NUMBER:= FND_API.G_MISS_NUM,
219: p_description IN VARCHAR2:= FND_API.G_MISS_CHAR,
220: p_mode IN VARCHAR2 default 'R'
221: );
222:
215: p_task_id IN NUMBER:= FND_API.G_MISS_NUM,
216: p_award_id IN NUMBER:= FND_API.G_MISS_NUM,
217: p_expenditure_type IN VARCHAR2:= FND_API.G_MISS_CHAR,
218: p_expenditure_organization_id IN NUMBER:= FND_API.G_MISS_NUM,
219: p_description IN VARCHAR2:= FND_API.G_MISS_CHAR,
220: p_mode IN VARCHAR2 default 'R'
221: );
222:
223: PROCEDURE Modify_Extract_Distribution
221: );
222:
223: PROCEDURE Modify_Extract_Distribution
224: ( p_api_version IN NUMBER,
225: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
226: p_commit IN VARCHAR2 := FND_API.G_FALSE,
227: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
228: p_return_status OUT NOCOPY VARCHAR2,
229: p_msg_count OUT NOCOPY NUMBER,
222:
223: PROCEDURE Modify_Extract_Distribution
224: ( p_api_version IN NUMBER,
225: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
226: p_commit IN VARCHAR2 := FND_API.G_FALSE,
227: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
228: p_return_status OUT NOCOPY VARCHAR2,
229: p_msg_count OUT NOCOPY NUMBER,
230: p_msg_data OUT NOCOPY VARCHAR2,
223: PROCEDURE Modify_Extract_Distribution
224: ( p_api_version IN NUMBER,
225: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
226: p_commit IN VARCHAR2 := FND_API.G_FALSE,
227: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
228: p_return_status OUT NOCOPY VARCHAR2,
229: p_msg_count OUT NOCOPY NUMBER,
230: p_msg_data OUT NOCOPY VARCHAR2,
231: p_position_id IN NUMBER,
239: -- This api is used for applying distribution default rules.
240:
241: PROCEDURE Apply_Position_Pay_Distr
242: ( p_api_version IN NUMBER,
243: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
244: p_commit IN VARCHAR2 := FND_API.G_FALSE,
245: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
246: x_return_status OUT NOCOPY VARCHAR2,
247: x_msg_count OUT NOCOPY NUMBER,
240:
241: PROCEDURE Apply_Position_Pay_Distr
242: ( p_api_version IN NUMBER,
243: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
244: p_commit IN VARCHAR2 := FND_API.G_FALSE,
245: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
246: x_return_status OUT NOCOPY VARCHAR2,
247: x_msg_count OUT NOCOPY NUMBER,
248: x_msg_data OUT NOCOPY VARCHAR2,
241: PROCEDURE Apply_Position_Pay_Distr
242: ( p_api_version IN NUMBER,
243: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
244: p_commit IN VARCHAR2 := FND_API.G_FALSE,
245: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
246: x_return_status OUT NOCOPY VARCHAR2,
247: x_msg_count OUT NOCOPY NUMBER,
248: x_msg_data OUT NOCOPY VARCHAR2,
249: p_distribution_id IN OUT NOCOPY NUMBER,
258: p_distribution_percent IN NUMBER,
259: p_global_default_flag IN VARCHAR2,
260: p_distribution_default_rule_id IN NUMBER,
261: p_rowid IN OUT NOCOPY VARCHAR2,
262: p_project_id IN NUMBER:= FND_API.G_MISS_NUM,
263: p_task_id IN NUMBER:= FND_API.G_MISS_NUM,
264: p_award_id IN NUMBER:= FND_API.G_MISS_NUM,
265: p_expenditure_type IN VARCHAR2:= FND_API.G_MISS_CHAR,
266: p_expenditure_organization_id IN NUMBER:= FND_API.G_MISS_NUM,
259: p_global_default_flag IN VARCHAR2,
260: p_distribution_default_rule_id IN NUMBER,
261: p_rowid IN OUT NOCOPY VARCHAR2,
262: p_project_id IN NUMBER:= FND_API.G_MISS_NUM,
263: p_task_id IN NUMBER:= FND_API.G_MISS_NUM,
264: p_award_id IN NUMBER:= FND_API.G_MISS_NUM,
265: p_expenditure_type IN VARCHAR2:= FND_API.G_MISS_CHAR,
266: p_expenditure_organization_id IN NUMBER:= FND_API.G_MISS_NUM,
267: p_description IN VARCHAR2:= FND_API.G_MISS_CHAR,
260: p_distribution_default_rule_id IN NUMBER,
261: p_rowid IN OUT NOCOPY VARCHAR2,
262: p_project_id IN NUMBER:= FND_API.G_MISS_NUM,
263: p_task_id IN NUMBER:= FND_API.G_MISS_NUM,
264: p_award_id IN NUMBER:= FND_API.G_MISS_NUM,
265: p_expenditure_type IN VARCHAR2:= FND_API.G_MISS_CHAR,
266: p_expenditure_organization_id IN NUMBER:= FND_API.G_MISS_NUM,
267: p_description IN VARCHAR2:= FND_API.G_MISS_CHAR,
268: p_mode IN VARCHAR2 := 'R');
261: p_rowid IN OUT NOCOPY VARCHAR2,
262: p_project_id IN NUMBER:= FND_API.G_MISS_NUM,
263: p_task_id IN NUMBER:= FND_API.G_MISS_NUM,
264: p_award_id IN NUMBER:= FND_API.G_MISS_NUM,
265: p_expenditure_type IN VARCHAR2:= FND_API.G_MISS_CHAR,
266: p_expenditure_organization_id IN NUMBER:= FND_API.G_MISS_NUM,
267: p_description IN VARCHAR2:= FND_API.G_MISS_CHAR,
268: p_mode IN VARCHAR2 := 'R');
269:
262: p_project_id IN NUMBER:= FND_API.G_MISS_NUM,
263: p_task_id IN NUMBER:= FND_API.G_MISS_NUM,
264: p_award_id IN NUMBER:= FND_API.G_MISS_NUM,
265: p_expenditure_type IN VARCHAR2:= FND_API.G_MISS_CHAR,
266: p_expenditure_organization_id IN NUMBER:= FND_API.G_MISS_NUM,
267: p_description IN VARCHAR2:= FND_API.G_MISS_CHAR,
268: p_mode IN VARCHAR2 := 'R');
269:
270: /* Bug 1308558 End */
263: p_task_id IN NUMBER:= FND_API.G_MISS_NUM,
264: p_award_id IN NUMBER:= FND_API.G_MISS_NUM,
265: p_expenditure_type IN VARCHAR2:= FND_API.G_MISS_CHAR,
266: p_expenditure_organization_id IN NUMBER:= FND_API.G_MISS_NUM,
267: p_description IN VARCHAR2:= FND_API.G_MISS_CHAR,
268: p_mode IN VARCHAR2 := 'R');
269:
270: /* Bug 1308558 End */
271: