DBA Data[Home] [Help]

APPS.PSB_POSITION_PAY_DISTR_PVT dependencies on FND_API

Line 6: p_init_msg_list IN VARCHAR2 := fnd_api.g_false,

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,

Line 7: p_commit IN VARCHAR2 := fnd_api.g_false,

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,

Line 8: p_validation_level IN NUMBER := fnd_api.g_valid_level_full,

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,

Line 16: p_worksheet_id IN NUMBER := FND_API.G_MISS_NUM,

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,

Line 24: p_project_id IN NUMBER:= FND_API.G_MISS_NUM,

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,

Line 25: p_task_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,

Line 26: p_award_id IN NUMBER:= FND_API.G_MISS_NUM,

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'

Line 27: p_expenditure_type IN VARCHAR2:= FND_API.G_MISS_CHAR,

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: );

Line 28: p_expenditure_organization_id IN NUMBER:= FND_API.G_MISS_NUM,

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: --

Line 29: p_description IN VARCHAR2:= FND_API.G_MISS_CHAR,

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: --

Line 38: p_init_msg_list IN VARCHAR2 := fnd_api.g_false,

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,

Line 39: p_commit IN VARCHAR2 := fnd_api.g_false,

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,

Line 40: p_validation_level IN NUMBER := fnd_api.g_valid_level_full,

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,

Line 48: p_worksheet_id IN NUMBER := FND_API.G_MISS_NUM,

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,

Line 56: p_project_id IN NUMBER:= FND_API.G_MISS_NUM,

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,

Line 57: p_task_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

Line 58: p_award_id IN NUMBER:= FND_API.G_MISS_NUM,

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: );

Line 59: p_expenditure_type IN VARCHAR2:= FND_API.G_MISS_CHAR,

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:

Line 60: p_expenditure_organization_id IN NUMBER:= FND_API.G_MISS_NUM,

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: --

Line 61: p_description IN VARCHAR2:= FND_API.G_MISS_CHAR

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: --

Line 69: p_init_msg_list IN VARCHAR2 := fnd_api.g_false,

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,

Line 70: p_commit IN VARCHAR2 := fnd_api.g_false,

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,

Line 71: p_validation_level IN NUMBER := fnd_api.g_valid_level_full,

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,

Line 77: p_effective_start_date IN DATE := FND_API.G_MISS_DATE,

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,

Line 78: p_effective_end_date IN DATE := FND_API.G_MISS_DATE,

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,

Line 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,

Line 83: p_task_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,

Line 84: p_award_id IN NUMBER:= FND_API.G_MISS_NUM,

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'

Line 85: p_expenditure_type IN VARCHAR2:= FND_API.G_MISS_CHAR,

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: );

Line 86: p_expenditure_organization_id IN NUMBER:= FND_API.G_MISS_NUM,

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: --

Line 87: p_description IN VARCHAR2:= FND_API.G_MISS_CHAR,

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: --

Line 95: p_init_msg_list IN VARCHAR2 := fnd_api.g_false,

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,

Line 96: p_commit IN VARCHAR2 := fnd_api.g_false,

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,

Line 97: p_validation_level IN NUMBER := fnd_api.g_valid_level_full,

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,

Line 113: p_project_id IN NUMBER:= FND_API.G_MISS_NUM,

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,

Line 114: p_task_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,

Line 115: p_award_id IN NUMBER:= FND_API.G_MISS_NUM,

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'

Line 116: p_expenditure_type IN VARCHAR2:= FND_API.G_MISS_CHAR,

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:

Line 117: p_expenditure_organization_id IN NUMBER:= FND_API.G_MISS_NUM,

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: );

Line 118: p_description IN VARCHAR2:= FND_API.G_MISS_CHAR,

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: --

Line 127: p_init_msg_list IN VARCHAR2 := fnd_api.g_false,

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,

Line 128: p_commit IN VARCHAR2 := fnd_api.g_false,

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,

Line 129: p_validation_level IN NUMBER := fnd_api.g_valid_level_full,

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

Line 139: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,

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,

Line 140: p_commit IN VARCHAR2 := FND_API.G_FALSE,

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,

Line 141: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,

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

Line 150: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,

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,

Line 151: p_commit IN VARCHAR2 := FND_API.G_FALSE,

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,

Line 152: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,

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,

Line 164: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,

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,

Line 165: p_commit IN VARCHAR2 := FND_API.G_FALSE,

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,

Line 166: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,

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,

Line 171: p_worksheet_id IN NUMBER := FND_API.G_MISS_NUM,

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,

Line 183: p_project_id IN NUMBER:= FND_API.G_MISS_NUM,

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,

Line 184: p_task_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,

Line 185: p_award_id IN NUMBER:= FND_API.G_MISS_NUM,

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,

Line 186: p_expenditure_type IN VARCHAR2:= FND_API.G_MISS_CHAR,

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',

Line 187: p_expenditure_organization_id IN NUMBER:= FND_API.G_MISS_NUM,

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

Line 188: p_description IN VARCHAR2:= FND_API.G_MISS_CHAR,

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: );

Line 189: p_budget_revision_pos_line_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: );
193:

Line 196: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,

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,

Line 197: p_commit IN VARCHAR2 := FND_API.G_FALSE,

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,

Line 198: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,

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,

Line 205: p_worksheet_id IN NUMBER := FND_API.G_MISS_NUM,

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,

Line 214: p_project_id IN NUMBER:= FND_API.G_MISS_NUM,

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,

Line 215: p_task_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,

Line 216: p_award_id IN NUMBER:= FND_API.G_MISS_NUM,

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'

Line 217: p_expenditure_type IN VARCHAR2:= FND_API.G_MISS_CHAR,

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: );

Line 218: p_expenditure_organization_id IN NUMBER:= FND_API.G_MISS_NUM,

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:

Line 219: p_description IN VARCHAR2:= FND_API.G_MISS_CHAR,

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

Line 225: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,

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,

Line 226: p_commit IN VARCHAR2 := FND_API.G_FALSE,

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,

Line 227: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,

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,

Line 243: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,

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,

Line 244: p_commit IN VARCHAR2 := FND_API.G_FALSE,

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,

Line 245: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,

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,

Line 262: p_project_id IN NUMBER:= FND_API.G_MISS_NUM,

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,

Line 263: p_task_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,

Line 264: p_award_id IN NUMBER:= FND_API.G_MISS_NUM,

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');

Line 265: p_expenditure_type IN VARCHAR2:= FND_API.G_MISS_CHAR,

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:

Line 266: p_expenditure_organization_id IN NUMBER:= FND_API.G_MISS_NUM,

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 */

Line 267: p_description IN VARCHAR2:= FND_API.G_MISS_CHAR,

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: