56: g_soft_error_flag VARCHAR2(1) := 'N';
57:
58: PROCEDURE Delete_Row
59: ( p_api_version IN NUMBER,
60: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
61: p_commit IN VARCHAR2 := FND_API.G_FALSE,
62: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
63: p_return_status OUT NOCOPY VARCHAR2,
64: p_msg_count OUT NOCOPY NUMBER,
57:
58: PROCEDURE Delete_Row
59: ( p_api_version IN NUMBER,
60: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
61: p_commit IN VARCHAR2 := FND_API.G_FALSE,
62: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
63: p_return_status OUT NOCOPY VARCHAR2,
64: p_msg_count OUT NOCOPY NUMBER,
65: p_msg_data OUT NOCOPY VARCHAR2,
58: PROCEDURE Delete_Row
59: ( p_api_version IN NUMBER,
60: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
61: p_commit IN VARCHAR2 := FND_API.G_FALSE,
62: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
63: p_return_status OUT NOCOPY VARCHAR2,
64: p_msg_count OUT NOCOPY NUMBER,
65: p_msg_data OUT NOCOPY VARCHAR2,
66: p_budget_revision_id IN NUMBER);
66: p_budget_revision_id IN NUMBER);
67:
68: PROCEDURE Update_Baseline_Values
69: ( p_api_version IN NUMBER,
70: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
71: p_commit IN VARCHAR2 := FND_API.G_FALSE,
72: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
73: p_return_status OUT NOCOPY VARCHAR2,
74: p_msg_count OUT NOCOPY NUMBER,
67:
68: PROCEDURE Update_Baseline_Values
69: ( p_api_version IN NUMBER,
70: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
71: p_commit IN VARCHAR2 := FND_API.G_FALSE,
72: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
73: p_return_status OUT NOCOPY VARCHAR2,
74: p_msg_count OUT NOCOPY NUMBER,
75: p_msg_data OUT NOCOPY VARCHAR2,
68: PROCEDURE Update_Baseline_Values
69: ( p_api_version IN NUMBER,
70: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
71: p_commit IN VARCHAR2 := FND_API.G_FALSE,
72: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
73: p_return_status OUT NOCOPY VARCHAR2,
74: p_msg_count OUT NOCOPY NUMBER,
75: p_msg_data OUT NOCOPY VARCHAR2,
76: p_budget_revision_id IN NUMBER);
76: p_budget_revision_id IN NUMBER);
77:
78: PROCEDURE Create_Budget_Revision
79: ( p_api_version IN NUMBER,
80: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
81: p_commit IN VARCHAR2 := FND_API.G_FALSE,
82: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
83: p_return_status OUT NOCOPY VARCHAR2,
84: p_msg_count OUT NOCOPY NUMBER,
77:
78: PROCEDURE Create_Budget_Revision
79: ( p_api_version IN NUMBER,
80: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
81: p_commit IN VARCHAR2 := FND_API.G_FALSE,
82: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
83: p_return_status OUT NOCOPY VARCHAR2,
84: p_msg_count OUT NOCOPY NUMBER,
85: p_msg_data OUT NOCOPY VARCHAR2,
78: PROCEDURE Create_Budget_Revision
79: ( p_api_version IN NUMBER,
80: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
81: p_commit IN VARCHAR2 := FND_API.G_FALSE,
82: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
83: p_return_status OUT NOCOPY VARCHAR2,
84: p_msg_count OUT NOCOPY NUMBER,
85: p_msg_data OUT NOCOPY VARCHAR2,
86: p_budget_revision_id IN OUT NOCOPY NUMBER,
83: p_return_status OUT NOCOPY VARCHAR2,
84: p_msg_count OUT NOCOPY NUMBER,
85: p_msg_data OUT NOCOPY VARCHAR2,
86: p_budget_revision_id IN OUT NOCOPY NUMBER,
87: p_budget_group_id IN NUMBER := FND_API.G_MISS_NUM,
88: p_gl_budget_set_id IN NUMBER := FND_API.G_MISS_NUM,
89: p_hr_budget_id IN NUMBER := FND_API.G_MISS_NUM,
90: p_justification IN VARCHAR2 := FND_API.G_MISS_CHAR,
91: p_from_gl_period_name IN VARCHAR2 := FND_API.G_MISS_CHAR,
84: p_msg_count OUT NOCOPY NUMBER,
85: p_msg_data OUT NOCOPY VARCHAR2,
86: p_budget_revision_id IN OUT NOCOPY NUMBER,
87: p_budget_group_id IN NUMBER := FND_API.G_MISS_NUM,
88: p_gl_budget_set_id IN NUMBER := FND_API.G_MISS_NUM,
89: p_hr_budget_id IN NUMBER := FND_API.G_MISS_NUM,
90: p_justification IN VARCHAR2 := FND_API.G_MISS_CHAR,
91: p_from_gl_period_name IN VARCHAR2 := FND_API.G_MISS_CHAR,
92: p_to_gl_period_name IN VARCHAR2 := FND_API.G_MISS_CHAR,
85: p_msg_data OUT NOCOPY VARCHAR2,
86: p_budget_revision_id IN OUT NOCOPY NUMBER,
87: p_budget_group_id IN NUMBER := FND_API.G_MISS_NUM,
88: p_gl_budget_set_id IN NUMBER := FND_API.G_MISS_NUM,
89: p_hr_budget_id IN NUMBER := FND_API.G_MISS_NUM,
90: p_justification IN VARCHAR2 := FND_API.G_MISS_CHAR,
91: p_from_gl_period_name IN VARCHAR2 := FND_API.G_MISS_CHAR,
92: p_to_gl_period_name IN VARCHAR2 := FND_API.G_MISS_CHAR,
93: p_currency_code IN VARCHAR2 := FND_API.G_MISS_CHAR,
86: p_budget_revision_id IN OUT NOCOPY NUMBER,
87: p_budget_group_id IN NUMBER := FND_API.G_MISS_NUM,
88: p_gl_budget_set_id IN NUMBER := FND_API.G_MISS_NUM,
89: p_hr_budget_id IN NUMBER := FND_API.G_MISS_NUM,
90: p_justification IN VARCHAR2 := FND_API.G_MISS_CHAR,
91: p_from_gl_period_name IN VARCHAR2 := FND_API.G_MISS_CHAR,
92: p_to_gl_period_name IN VARCHAR2 := FND_API.G_MISS_CHAR,
93: p_currency_code IN VARCHAR2 := FND_API.G_MISS_CHAR,
94: p_effective_start_date IN DATE := FND_API.G_MISS_DATE,
87: p_budget_group_id IN NUMBER := FND_API.G_MISS_NUM,
88: p_gl_budget_set_id IN NUMBER := FND_API.G_MISS_NUM,
89: p_hr_budget_id IN NUMBER := FND_API.G_MISS_NUM,
90: p_justification IN VARCHAR2 := FND_API.G_MISS_CHAR,
91: p_from_gl_period_name IN VARCHAR2 := FND_API.G_MISS_CHAR,
92: p_to_gl_period_name IN VARCHAR2 := FND_API.G_MISS_CHAR,
93: p_currency_code IN VARCHAR2 := FND_API.G_MISS_CHAR,
94: p_effective_start_date IN DATE := FND_API.G_MISS_DATE,
95: p_effective_end_date IN DATE := FND_API.G_MISS_DATE,
88: p_gl_budget_set_id IN NUMBER := FND_API.G_MISS_NUM,
89: p_hr_budget_id IN NUMBER := FND_API.G_MISS_NUM,
90: p_justification IN VARCHAR2 := FND_API.G_MISS_CHAR,
91: p_from_gl_period_name IN VARCHAR2 := FND_API.G_MISS_CHAR,
92: p_to_gl_period_name IN VARCHAR2 := FND_API.G_MISS_CHAR,
93: p_currency_code IN VARCHAR2 := FND_API.G_MISS_CHAR,
94: p_effective_start_date IN DATE := FND_API.G_MISS_DATE,
95: p_effective_end_date IN DATE := FND_API.G_MISS_DATE,
96: p_budget_revision_type IN VARCHAR2 := FND_API.G_MISS_CHAR,
89: p_hr_budget_id IN NUMBER := FND_API.G_MISS_NUM,
90: p_justification IN VARCHAR2 := FND_API.G_MISS_CHAR,
91: p_from_gl_period_name IN VARCHAR2 := FND_API.G_MISS_CHAR,
92: p_to_gl_period_name IN VARCHAR2 := FND_API.G_MISS_CHAR,
93: p_currency_code IN VARCHAR2 := FND_API.G_MISS_CHAR,
94: p_effective_start_date IN DATE := FND_API.G_MISS_DATE,
95: p_effective_end_date IN DATE := FND_API.G_MISS_DATE,
96: p_budget_revision_type IN VARCHAR2 := FND_API.G_MISS_CHAR,
97: p_transaction_type IN VARCHAR2 := FND_API.G_MISS_CHAR,
90: p_justification IN VARCHAR2 := FND_API.G_MISS_CHAR,
91: p_from_gl_period_name IN VARCHAR2 := FND_API.G_MISS_CHAR,
92: p_to_gl_period_name IN VARCHAR2 := FND_API.G_MISS_CHAR,
93: p_currency_code IN VARCHAR2 := FND_API.G_MISS_CHAR,
94: p_effective_start_date IN DATE := FND_API.G_MISS_DATE,
95: p_effective_end_date IN DATE := FND_API.G_MISS_DATE,
96: p_budget_revision_type IN VARCHAR2 := FND_API.G_MISS_CHAR,
97: p_transaction_type IN VARCHAR2 := FND_API.G_MISS_CHAR,
98: p_permanent_revision IN VARCHAR2 := FND_API.G_MISS_CHAR,
91: p_from_gl_period_name IN VARCHAR2 := FND_API.G_MISS_CHAR,
92: p_to_gl_period_name IN VARCHAR2 := FND_API.G_MISS_CHAR,
93: p_currency_code IN VARCHAR2 := FND_API.G_MISS_CHAR,
94: p_effective_start_date IN DATE := FND_API.G_MISS_DATE,
95: p_effective_end_date IN DATE := FND_API.G_MISS_DATE,
96: p_budget_revision_type IN VARCHAR2 := FND_API.G_MISS_CHAR,
97: p_transaction_type IN VARCHAR2 := FND_API.G_MISS_CHAR,
98: p_permanent_revision IN VARCHAR2 := FND_API.G_MISS_CHAR,
99: p_revise_by_position IN VARCHAR2 := FND_API.G_MISS_CHAR,
92: p_to_gl_period_name IN VARCHAR2 := FND_API.G_MISS_CHAR,
93: p_currency_code IN VARCHAR2 := FND_API.G_MISS_CHAR,
94: p_effective_start_date IN DATE := FND_API.G_MISS_DATE,
95: p_effective_end_date IN DATE := FND_API.G_MISS_DATE,
96: p_budget_revision_type IN VARCHAR2 := FND_API.G_MISS_CHAR,
97: p_transaction_type IN VARCHAR2 := FND_API.G_MISS_CHAR,
98: p_permanent_revision IN VARCHAR2 := FND_API.G_MISS_CHAR,
99: p_revise_by_position IN VARCHAR2 := FND_API.G_MISS_CHAR,
100: p_balance_type IN VARCHAR2 := FND_API.G_MISS_CHAR,
93: p_currency_code IN VARCHAR2 := FND_API.G_MISS_CHAR,
94: p_effective_start_date IN DATE := FND_API.G_MISS_DATE,
95: p_effective_end_date IN DATE := FND_API.G_MISS_DATE,
96: p_budget_revision_type IN VARCHAR2 := FND_API.G_MISS_CHAR,
97: p_transaction_type IN VARCHAR2 := FND_API.G_MISS_CHAR,
98: p_permanent_revision IN VARCHAR2 := FND_API.G_MISS_CHAR,
99: p_revise_by_position IN VARCHAR2 := FND_API.G_MISS_CHAR,
100: p_balance_type IN VARCHAR2 := FND_API.G_MISS_CHAR,
101: p_global_budget_revision IN VARCHAR2 := FND_API.G_MISS_CHAR,
94: p_effective_start_date IN DATE := FND_API.G_MISS_DATE,
95: p_effective_end_date IN DATE := FND_API.G_MISS_DATE,
96: p_budget_revision_type IN VARCHAR2 := FND_API.G_MISS_CHAR,
97: p_transaction_type IN VARCHAR2 := FND_API.G_MISS_CHAR,
98: p_permanent_revision IN VARCHAR2 := FND_API.G_MISS_CHAR,
99: p_revise_by_position IN VARCHAR2 := FND_API.G_MISS_CHAR,
100: p_balance_type IN VARCHAR2 := FND_API.G_MISS_CHAR,
101: p_global_budget_revision IN VARCHAR2 := FND_API.G_MISS_CHAR,
102: p_global_budget_revision_id IN NUMBER := FND_API.G_MISS_NUM,
95: p_effective_end_date IN DATE := FND_API.G_MISS_DATE,
96: p_budget_revision_type IN VARCHAR2 := FND_API.G_MISS_CHAR,
97: p_transaction_type IN VARCHAR2 := FND_API.G_MISS_CHAR,
98: p_permanent_revision IN VARCHAR2 := FND_API.G_MISS_CHAR,
99: p_revise_by_position IN VARCHAR2 := FND_API.G_MISS_CHAR,
100: p_balance_type IN VARCHAR2 := FND_API.G_MISS_CHAR,
101: p_global_budget_revision IN VARCHAR2 := FND_API.G_MISS_CHAR,
102: p_global_budget_revision_id IN NUMBER := FND_API.G_MISS_NUM,
103: p_requestor IN NUMBER := FND_API.G_MISS_NUM,
96: p_budget_revision_type IN VARCHAR2 := FND_API.G_MISS_CHAR,
97: p_transaction_type IN VARCHAR2 := FND_API.G_MISS_CHAR,
98: p_permanent_revision IN VARCHAR2 := FND_API.G_MISS_CHAR,
99: p_revise_by_position IN VARCHAR2 := FND_API.G_MISS_CHAR,
100: p_balance_type IN VARCHAR2 := FND_API.G_MISS_CHAR,
101: p_global_budget_revision IN VARCHAR2 := FND_API.G_MISS_CHAR,
102: p_global_budget_revision_id IN NUMBER := FND_API.G_MISS_NUM,
103: p_requestor IN NUMBER := FND_API.G_MISS_NUM,
104: p_parameter_set_id IN NUMBER := FND_API.G_MISS_NUM,
97: p_transaction_type IN VARCHAR2 := FND_API.G_MISS_CHAR,
98: p_permanent_revision IN VARCHAR2 := FND_API.G_MISS_CHAR,
99: p_revise_by_position IN VARCHAR2 := FND_API.G_MISS_CHAR,
100: p_balance_type IN VARCHAR2 := FND_API.G_MISS_CHAR,
101: p_global_budget_revision IN VARCHAR2 := FND_API.G_MISS_CHAR,
102: p_global_budget_revision_id IN NUMBER := FND_API.G_MISS_NUM,
103: p_requestor IN NUMBER := FND_API.G_MISS_NUM,
104: p_parameter_set_id IN NUMBER := FND_API.G_MISS_NUM,
105: p_constraint_set_id IN NUMBER := FND_API.G_MISS_NUM,
98: p_permanent_revision IN VARCHAR2 := FND_API.G_MISS_CHAR,
99: p_revise_by_position IN VARCHAR2 := FND_API.G_MISS_CHAR,
100: p_balance_type IN VARCHAR2 := FND_API.G_MISS_CHAR,
101: p_global_budget_revision IN VARCHAR2 := FND_API.G_MISS_CHAR,
102: p_global_budget_revision_id IN NUMBER := FND_API.G_MISS_NUM,
103: p_requestor IN NUMBER := FND_API.G_MISS_NUM,
104: p_parameter_set_id IN NUMBER := FND_API.G_MISS_NUM,
105: p_constraint_set_id IN NUMBER := FND_API.G_MISS_NUM,
106: p_submission_date IN DATE := FND_API.G_MISS_DATE,
99: p_revise_by_position IN VARCHAR2 := FND_API.G_MISS_CHAR,
100: p_balance_type IN VARCHAR2 := FND_API.G_MISS_CHAR,
101: p_global_budget_revision IN VARCHAR2 := FND_API.G_MISS_CHAR,
102: p_global_budget_revision_id IN NUMBER := FND_API.G_MISS_NUM,
103: p_requestor IN NUMBER := FND_API.G_MISS_NUM,
104: p_parameter_set_id IN NUMBER := FND_API.G_MISS_NUM,
105: p_constraint_set_id IN NUMBER := FND_API.G_MISS_NUM,
106: p_submission_date IN DATE := FND_API.G_MISS_DATE,
107: p_submission_status IN VARCHAR2 := FND_API.G_MISS_CHAR,
100: p_balance_type IN VARCHAR2 := FND_API.G_MISS_CHAR,
101: p_global_budget_revision IN VARCHAR2 := FND_API.G_MISS_CHAR,
102: p_global_budget_revision_id IN NUMBER := FND_API.G_MISS_NUM,
103: p_requestor IN NUMBER := FND_API.G_MISS_NUM,
104: p_parameter_set_id IN NUMBER := FND_API.G_MISS_NUM,
105: p_constraint_set_id IN NUMBER := FND_API.G_MISS_NUM,
106: p_submission_date IN DATE := FND_API.G_MISS_DATE,
107: p_submission_status IN VARCHAR2 := FND_API.G_MISS_CHAR,
108: p_approval_orig_system IN VARCHAR2 := FND_API.G_MISS_CHAR,
101: p_global_budget_revision IN VARCHAR2 := FND_API.G_MISS_CHAR,
102: p_global_budget_revision_id IN NUMBER := FND_API.G_MISS_NUM,
103: p_requestor IN NUMBER := FND_API.G_MISS_NUM,
104: p_parameter_set_id IN NUMBER := FND_API.G_MISS_NUM,
105: p_constraint_set_id IN NUMBER := FND_API.G_MISS_NUM,
106: p_submission_date IN DATE := FND_API.G_MISS_DATE,
107: p_submission_status IN VARCHAR2 := FND_API.G_MISS_CHAR,
108: p_approval_orig_system IN VARCHAR2 := FND_API.G_MISS_CHAR,
109: p_approval_override_by IN NUMBER := FND_API.G_MISS_NUM,
102: p_global_budget_revision_id IN NUMBER := FND_API.G_MISS_NUM,
103: p_requestor IN NUMBER := FND_API.G_MISS_NUM,
104: p_parameter_set_id IN NUMBER := FND_API.G_MISS_NUM,
105: p_constraint_set_id IN NUMBER := FND_API.G_MISS_NUM,
106: p_submission_date IN DATE := FND_API.G_MISS_DATE,
107: p_submission_status IN VARCHAR2 := FND_API.G_MISS_CHAR,
108: p_approval_orig_system IN VARCHAR2 := FND_API.G_MISS_CHAR,
109: p_approval_override_by IN NUMBER := FND_API.G_MISS_NUM,
110: p_freeze_flag IN VARCHAR2 := FND_API.G_MISS_CHAR,
103: p_requestor IN NUMBER := FND_API.G_MISS_NUM,
104: p_parameter_set_id IN NUMBER := FND_API.G_MISS_NUM,
105: p_constraint_set_id IN NUMBER := FND_API.G_MISS_NUM,
106: p_submission_date IN DATE := FND_API.G_MISS_DATE,
107: p_submission_status IN VARCHAR2 := FND_API.G_MISS_CHAR,
108: p_approval_orig_system IN VARCHAR2 := FND_API.G_MISS_CHAR,
109: p_approval_override_by IN NUMBER := FND_API.G_MISS_NUM,
110: p_freeze_flag IN VARCHAR2 := FND_API.G_MISS_CHAR,
111: p_request_id IN NUMBER := FND_API.G_MISS_NUM,
104: p_parameter_set_id IN NUMBER := FND_API.G_MISS_NUM,
105: p_constraint_set_id IN NUMBER := FND_API.G_MISS_NUM,
106: p_submission_date IN DATE := FND_API.G_MISS_DATE,
107: p_submission_status IN VARCHAR2 := FND_API.G_MISS_CHAR,
108: p_approval_orig_system IN VARCHAR2 := FND_API.G_MISS_CHAR,
109: p_approval_override_by IN NUMBER := FND_API.G_MISS_NUM,
110: p_freeze_flag IN VARCHAR2 := FND_API.G_MISS_CHAR,
111: p_request_id IN NUMBER := FND_API.G_MISS_NUM,
112: p_base_line_revision IN VARCHAR2 := FND_API.G_MISS_CHAR,
105: p_constraint_set_id IN NUMBER := FND_API.G_MISS_NUM,
106: p_submission_date IN DATE := FND_API.G_MISS_DATE,
107: p_submission_status IN VARCHAR2 := FND_API.G_MISS_CHAR,
108: p_approval_orig_system IN VARCHAR2 := FND_API.G_MISS_CHAR,
109: p_approval_override_by IN NUMBER := FND_API.G_MISS_NUM,
110: p_freeze_flag IN VARCHAR2 := FND_API.G_MISS_CHAR,
111: p_request_id IN NUMBER := FND_API.G_MISS_NUM,
112: p_base_line_revision IN VARCHAR2 := FND_API.G_MISS_CHAR,
113: p_attribute1 IN VARCHAR2 := FND_API.G_MISS_CHAR,
106: p_submission_date IN DATE := FND_API.G_MISS_DATE,
107: p_submission_status IN VARCHAR2 := FND_API.G_MISS_CHAR,
108: p_approval_orig_system IN VARCHAR2 := FND_API.G_MISS_CHAR,
109: p_approval_override_by IN NUMBER := FND_API.G_MISS_NUM,
110: p_freeze_flag IN VARCHAR2 := FND_API.G_MISS_CHAR,
111: p_request_id IN NUMBER := FND_API.G_MISS_NUM,
112: p_base_line_revision IN VARCHAR2 := FND_API.G_MISS_CHAR,
113: p_attribute1 IN VARCHAR2 := FND_API.G_MISS_CHAR,
114: p_attribute2 IN VARCHAR2 := FND_API.G_MISS_CHAR,
107: p_submission_status IN VARCHAR2 := FND_API.G_MISS_CHAR,
108: p_approval_orig_system IN VARCHAR2 := FND_API.G_MISS_CHAR,
109: p_approval_override_by IN NUMBER := FND_API.G_MISS_NUM,
110: p_freeze_flag IN VARCHAR2 := FND_API.G_MISS_CHAR,
111: p_request_id IN NUMBER := FND_API.G_MISS_NUM,
112: p_base_line_revision IN VARCHAR2 := FND_API.G_MISS_CHAR,
113: p_attribute1 IN VARCHAR2 := FND_API.G_MISS_CHAR,
114: p_attribute2 IN VARCHAR2 := FND_API.G_MISS_CHAR,
115: p_attribute3 IN VARCHAR2 := FND_API.G_MISS_CHAR,
108: p_approval_orig_system IN VARCHAR2 := FND_API.G_MISS_CHAR,
109: p_approval_override_by IN NUMBER := FND_API.G_MISS_NUM,
110: p_freeze_flag IN VARCHAR2 := FND_API.G_MISS_CHAR,
111: p_request_id IN NUMBER := FND_API.G_MISS_NUM,
112: p_base_line_revision IN VARCHAR2 := FND_API.G_MISS_CHAR,
113: p_attribute1 IN VARCHAR2 := FND_API.G_MISS_CHAR,
114: p_attribute2 IN VARCHAR2 := FND_API.G_MISS_CHAR,
115: p_attribute3 IN VARCHAR2 := FND_API.G_MISS_CHAR,
116: p_attribute4 IN VARCHAR2 := FND_API.G_MISS_CHAR,
109: p_approval_override_by IN NUMBER := FND_API.G_MISS_NUM,
110: p_freeze_flag IN VARCHAR2 := FND_API.G_MISS_CHAR,
111: p_request_id IN NUMBER := FND_API.G_MISS_NUM,
112: p_base_line_revision IN VARCHAR2 := FND_API.G_MISS_CHAR,
113: p_attribute1 IN VARCHAR2 := FND_API.G_MISS_CHAR,
114: p_attribute2 IN VARCHAR2 := FND_API.G_MISS_CHAR,
115: p_attribute3 IN VARCHAR2 := FND_API.G_MISS_CHAR,
116: p_attribute4 IN VARCHAR2 := FND_API.G_MISS_CHAR,
117: p_attribute5 IN VARCHAR2 := FND_API.G_MISS_CHAR,
110: p_freeze_flag IN VARCHAR2 := FND_API.G_MISS_CHAR,
111: p_request_id IN NUMBER := FND_API.G_MISS_NUM,
112: p_base_line_revision IN VARCHAR2 := FND_API.G_MISS_CHAR,
113: p_attribute1 IN VARCHAR2 := FND_API.G_MISS_CHAR,
114: p_attribute2 IN VARCHAR2 := FND_API.G_MISS_CHAR,
115: p_attribute3 IN VARCHAR2 := FND_API.G_MISS_CHAR,
116: p_attribute4 IN VARCHAR2 := FND_API.G_MISS_CHAR,
117: p_attribute5 IN VARCHAR2 := FND_API.G_MISS_CHAR,
118: p_attribute6 IN VARCHAR2 := FND_API.G_MISS_CHAR,
111: p_request_id IN NUMBER := FND_API.G_MISS_NUM,
112: p_base_line_revision IN VARCHAR2 := FND_API.G_MISS_CHAR,
113: p_attribute1 IN VARCHAR2 := FND_API.G_MISS_CHAR,
114: p_attribute2 IN VARCHAR2 := FND_API.G_MISS_CHAR,
115: p_attribute3 IN VARCHAR2 := FND_API.G_MISS_CHAR,
116: p_attribute4 IN VARCHAR2 := FND_API.G_MISS_CHAR,
117: p_attribute5 IN VARCHAR2 := FND_API.G_MISS_CHAR,
118: p_attribute6 IN VARCHAR2 := FND_API.G_MISS_CHAR,
119: p_attribute7 IN VARCHAR2 := FND_API.G_MISS_CHAR,
112: p_base_line_revision IN VARCHAR2 := FND_API.G_MISS_CHAR,
113: p_attribute1 IN VARCHAR2 := FND_API.G_MISS_CHAR,
114: p_attribute2 IN VARCHAR2 := FND_API.G_MISS_CHAR,
115: p_attribute3 IN VARCHAR2 := FND_API.G_MISS_CHAR,
116: p_attribute4 IN VARCHAR2 := FND_API.G_MISS_CHAR,
117: p_attribute5 IN VARCHAR2 := FND_API.G_MISS_CHAR,
118: p_attribute6 IN VARCHAR2 := FND_API.G_MISS_CHAR,
119: p_attribute7 IN VARCHAR2 := FND_API.G_MISS_CHAR,
120: p_attribute8 IN VARCHAR2 := FND_API.G_MISS_CHAR,
113: p_attribute1 IN VARCHAR2 := FND_API.G_MISS_CHAR,
114: p_attribute2 IN VARCHAR2 := FND_API.G_MISS_CHAR,
115: p_attribute3 IN VARCHAR2 := FND_API.G_MISS_CHAR,
116: p_attribute4 IN VARCHAR2 := FND_API.G_MISS_CHAR,
117: p_attribute5 IN VARCHAR2 := FND_API.G_MISS_CHAR,
118: p_attribute6 IN VARCHAR2 := FND_API.G_MISS_CHAR,
119: p_attribute7 IN VARCHAR2 := FND_API.G_MISS_CHAR,
120: p_attribute8 IN VARCHAR2 := FND_API.G_MISS_CHAR,
121: p_attribute9 IN VARCHAR2 := FND_API.G_MISS_CHAR,
114: p_attribute2 IN VARCHAR2 := FND_API.G_MISS_CHAR,
115: p_attribute3 IN VARCHAR2 := FND_API.G_MISS_CHAR,
116: p_attribute4 IN VARCHAR2 := FND_API.G_MISS_CHAR,
117: p_attribute5 IN VARCHAR2 := FND_API.G_MISS_CHAR,
118: p_attribute6 IN VARCHAR2 := FND_API.G_MISS_CHAR,
119: p_attribute7 IN VARCHAR2 := FND_API.G_MISS_CHAR,
120: p_attribute8 IN VARCHAR2 := FND_API.G_MISS_CHAR,
121: p_attribute9 IN VARCHAR2 := FND_API.G_MISS_CHAR,
122: p_attribute10 IN VARCHAR2 := FND_API.G_MISS_CHAR,
115: p_attribute3 IN VARCHAR2 := FND_API.G_MISS_CHAR,
116: p_attribute4 IN VARCHAR2 := FND_API.G_MISS_CHAR,
117: p_attribute5 IN VARCHAR2 := FND_API.G_MISS_CHAR,
118: p_attribute6 IN VARCHAR2 := FND_API.G_MISS_CHAR,
119: p_attribute7 IN VARCHAR2 := FND_API.G_MISS_CHAR,
120: p_attribute8 IN VARCHAR2 := FND_API.G_MISS_CHAR,
121: p_attribute9 IN VARCHAR2 := FND_API.G_MISS_CHAR,
122: p_attribute10 IN VARCHAR2 := FND_API.G_MISS_CHAR,
123: p_attribute11 IN VARCHAR2 := FND_API.G_MISS_CHAR,
116: p_attribute4 IN VARCHAR2 := FND_API.G_MISS_CHAR,
117: p_attribute5 IN VARCHAR2 := FND_API.G_MISS_CHAR,
118: p_attribute6 IN VARCHAR2 := FND_API.G_MISS_CHAR,
119: p_attribute7 IN VARCHAR2 := FND_API.G_MISS_CHAR,
120: p_attribute8 IN VARCHAR2 := FND_API.G_MISS_CHAR,
121: p_attribute9 IN VARCHAR2 := FND_API.G_MISS_CHAR,
122: p_attribute10 IN VARCHAR2 := FND_API.G_MISS_CHAR,
123: p_attribute11 IN VARCHAR2 := FND_API.G_MISS_CHAR,
124: p_attribute12 IN VARCHAR2 := FND_API.G_MISS_CHAR,
117: p_attribute5 IN VARCHAR2 := FND_API.G_MISS_CHAR,
118: p_attribute6 IN VARCHAR2 := FND_API.G_MISS_CHAR,
119: p_attribute7 IN VARCHAR2 := FND_API.G_MISS_CHAR,
120: p_attribute8 IN VARCHAR2 := FND_API.G_MISS_CHAR,
121: p_attribute9 IN VARCHAR2 := FND_API.G_MISS_CHAR,
122: p_attribute10 IN VARCHAR2 := FND_API.G_MISS_CHAR,
123: p_attribute11 IN VARCHAR2 := FND_API.G_MISS_CHAR,
124: p_attribute12 IN VARCHAR2 := FND_API.G_MISS_CHAR,
125: p_attribute13 IN VARCHAR2 := FND_API.G_MISS_CHAR,
118: p_attribute6 IN VARCHAR2 := FND_API.G_MISS_CHAR,
119: p_attribute7 IN VARCHAR2 := FND_API.G_MISS_CHAR,
120: p_attribute8 IN VARCHAR2 := FND_API.G_MISS_CHAR,
121: p_attribute9 IN VARCHAR2 := FND_API.G_MISS_CHAR,
122: p_attribute10 IN VARCHAR2 := FND_API.G_MISS_CHAR,
123: p_attribute11 IN VARCHAR2 := FND_API.G_MISS_CHAR,
124: p_attribute12 IN VARCHAR2 := FND_API.G_MISS_CHAR,
125: p_attribute13 IN VARCHAR2 := FND_API.G_MISS_CHAR,
126: p_attribute14 IN VARCHAR2 := FND_API.G_MISS_CHAR,
119: p_attribute7 IN VARCHAR2 := FND_API.G_MISS_CHAR,
120: p_attribute8 IN VARCHAR2 := FND_API.G_MISS_CHAR,
121: p_attribute9 IN VARCHAR2 := FND_API.G_MISS_CHAR,
122: p_attribute10 IN VARCHAR2 := FND_API.G_MISS_CHAR,
123: p_attribute11 IN VARCHAR2 := FND_API.G_MISS_CHAR,
124: p_attribute12 IN VARCHAR2 := FND_API.G_MISS_CHAR,
125: p_attribute13 IN VARCHAR2 := FND_API.G_MISS_CHAR,
126: p_attribute14 IN VARCHAR2 := FND_API.G_MISS_CHAR,
127: p_attribute15 IN VARCHAR2 := FND_API.G_MISS_CHAR,
120: p_attribute8 IN VARCHAR2 := FND_API.G_MISS_CHAR,
121: p_attribute9 IN VARCHAR2 := FND_API.G_MISS_CHAR,
122: p_attribute10 IN VARCHAR2 := FND_API.G_MISS_CHAR,
123: p_attribute11 IN VARCHAR2 := FND_API.G_MISS_CHAR,
124: p_attribute12 IN VARCHAR2 := FND_API.G_MISS_CHAR,
125: p_attribute13 IN VARCHAR2 := FND_API.G_MISS_CHAR,
126: p_attribute14 IN VARCHAR2 := FND_API.G_MISS_CHAR,
127: p_attribute15 IN VARCHAR2 := FND_API.G_MISS_CHAR,
128: p_attribute16 IN VARCHAR2 := FND_API.G_MISS_CHAR,
121: p_attribute9 IN VARCHAR2 := FND_API.G_MISS_CHAR,
122: p_attribute10 IN VARCHAR2 := FND_API.G_MISS_CHAR,
123: p_attribute11 IN VARCHAR2 := FND_API.G_MISS_CHAR,
124: p_attribute12 IN VARCHAR2 := FND_API.G_MISS_CHAR,
125: p_attribute13 IN VARCHAR2 := FND_API.G_MISS_CHAR,
126: p_attribute14 IN VARCHAR2 := FND_API.G_MISS_CHAR,
127: p_attribute15 IN VARCHAR2 := FND_API.G_MISS_CHAR,
128: p_attribute16 IN VARCHAR2 := FND_API.G_MISS_CHAR,
129: p_attribute17 IN VARCHAR2 := FND_API.G_MISS_CHAR,
122: p_attribute10 IN VARCHAR2 := FND_API.G_MISS_CHAR,
123: p_attribute11 IN VARCHAR2 := FND_API.G_MISS_CHAR,
124: p_attribute12 IN VARCHAR2 := FND_API.G_MISS_CHAR,
125: p_attribute13 IN VARCHAR2 := FND_API.G_MISS_CHAR,
126: p_attribute14 IN VARCHAR2 := FND_API.G_MISS_CHAR,
127: p_attribute15 IN VARCHAR2 := FND_API.G_MISS_CHAR,
128: p_attribute16 IN VARCHAR2 := FND_API.G_MISS_CHAR,
129: p_attribute17 IN VARCHAR2 := FND_API.G_MISS_CHAR,
130: p_attribute18 IN VARCHAR2 := FND_API.G_MISS_CHAR,
123: p_attribute11 IN VARCHAR2 := FND_API.G_MISS_CHAR,
124: p_attribute12 IN VARCHAR2 := FND_API.G_MISS_CHAR,
125: p_attribute13 IN VARCHAR2 := FND_API.G_MISS_CHAR,
126: p_attribute14 IN VARCHAR2 := FND_API.G_MISS_CHAR,
127: p_attribute15 IN VARCHAR2 := FND_API.G_MISS_CHAR,
128: p_attribute16 IN VARCHAR2 := FND_API.G_MISS_CHAR,
129: p_attribute17 IN VARCHAR2 := FND_API.G_MISS_CHAR,
130: p_attribute18 IN VARCHAR2 := FND_API.G_MISS_CHAR,
131: p_attribute19 IN VARCHAR2 := FND_API.G_MISS_CHAR,
124: p_attribute12 IN VARCHAR2 := FND_API.G_MISS_CHAR,
125: p_attribute13 IN VARCHAR2 := FND_API.G_MISS_CHAR,
126: p_attribute14 IN VARCHAR2 := FND_API.G_MISS_CHAR,
127: p_attribute15 IN VARCHAR2 := FND_API.G_MISS_CHAR,
128: p_attribute16 IN VARCHAR2 := FND_API.G_MISS_CHAR,
129: p_attribute17 IN VARCHAR2 := FND_API.G_MISS_CHAR,
130: p_attribute18 IN VARCHAR2 := FND_API.G_MISS_CHAR,
131: p_attribute19 IN VARCHAR2 := FND_API.G_MISS_CHAR,
132: p_attribute20 IN VARCHAR2 := FND_API.G_MISS_CHAR,
125: p_attribute13 IN VARCHAR2 := FND_API.G_MISS_CHAR,
126: p_attribute14 IN VARCHAR2 := FND_API.G_MISS_CHAR,
127: p_attribute15 IN VARCHAR2 := FND_API.G_MISS_CHAR,
128: p_attribute16 IN VARCHAR2 := FND_API.G_MISS_CHAR,
129: p_attribute17 IN VARCHAR2 := FND_API.G_MISS_CHAR,
130: p_attribute18 IN VARCHAR2 := FND_API.G_MISS_CHAR,
131: p_attribute19 IN VARCHAR2 := FND_API.G_MISS_CHAR,
132: p_attribute20 IN VARCHAR2 := FND_API.G_MISS_CHAR,
133: p_attribute21 IN VARCHAR2 := FND_API.G_MISS_CHAR,
126: p_attribute14 IN VARCHAR2 := FND_API.G_MISS_CHAR,
127: p_attribute15 IN VARCHAR2 := FND_API.G_MISS_CHAR,
128: p_attribute16 IN VARCHAR2 := FND_API.G_MISS_CHAR,
129: p_attribute17 IN VARCHAR2 := FND_API.G_MISS_CHAR,
130: p_attribute18 IN VARCHAR2 := FND_API.G_MISS_CHAR,
131: p_attribute19 IN VARCHAR2 := FND_API.G_MISS_CHAR,
132: p_attribute20 IN VARCHAR2 := FND_API.G_MISS_CHAR,
133: p_attribute21 IN VARCHAR2 := FND_API.G_MISS_CHAR,
134: p_attribute22 IN VARCHAR2 := FND_API.G_MISS_CHAR,
127: p_attribute15 IN VARCHAR2 := FND_API.G_MISS_CHAR,
128: p_attribute16 IN VARCHAR2 := FND_API.G_MISS_CHAR,
129: p_attribute17 IN VARCHAR2 := FND_API.G_MISS_CHAR,
130: p_attribute18 IN VARCHAR2 := FND_API.G_MISS_CHAR,
131: p_attribute19 IN VARCHAR2 := FND_API.G_MISS_CHAR,
132: p_attribute20 IN VARCHAR2 := FND_API.G_MISS_CHAR,
133: p_attribute21 IN VARCHAR2 := FND_API.G_MISS_CHAR,
134: p_attribute22 IN VARCHAR2 := FND_API.G_MISS_CHAR,
135: p_attribute23 IN VARCHAR2 := FND_API.G_MISS_CHAR,
128: p_attribute16 IN VARCHAR2 := FND_API.G_MISS_CHAR,
129: p_attribute17 IN VARCHAR2 := FND_API.G_MISS_CHAR,
130: p_attribute18 IN VARCHAR2 := FND_API.G_MISS_CHAR,
131: p_attribute19 IN VARCHAR2 := FND_API.G_MISS_CHAR,
132: p_attribute20 IN VARCHAR2 := FND_API.G_MISS_CHAR,
133: p_attribute21 IN VARCHAR2 := FND_API.G_MISS_CHAR,
134: p_attribute22 IN VARCHAR2 := FND_API.G_MISS_CHAR,
135: p_attribute23 IN VARCHAR2 := FND_API.G_MISS_CHAR,
136: p_attribute24 IN VARCHAR2 := FND_API.G_MISS_CHAR,
129: p_attribute17 IN VARCHAR2 := FND_API.G_MISS_CHAR,
130: p_attribute18 IN VARCHAR2 := FND_API.G_MISS_CHAR,
131: p_attribute19 IN VARCHAR2 := FND_API.G_MISS_CHAR,
132: p_attribute20 IN VARCHAR2 := FND_API.G_MISS_CHAR,
133: p_attribute21 IN VARCHAR2 := FND_API.G_MISS_CHAR,
134: p_attribute22 IN VARCHAR2 := FND_API.G_MISS_CHAR,
135: p_attribute23 IN VARCHAR2 := FND_API.G_MISS_CHAR,
136: p_attribute24 IN VARCHAR2 := FND_API.G_MISS_CHAR,
137: p_attribute25 IN VARCHAR2 := FND_API.G_MISS_CHAR,
130: p_attribute18 IN VARCHAR2 := FND_API.G_MISS_CHAR,
131: p_attribute19 IN VARCHAR2 := FND_API.G_MISS_CHAR,
132: p_attribute20 IN VARCHAR2 := FND_API.G_MISS_CHAR,
133: p_attribute21 IN VARCHAR2 := FND_API.G_MISS_CHAR,
134: p_attribute22 IN VARCHAR2 := FND_API.G_MISS_CHAR,
135: p_attribute23 IN VARCHAR2 := FND_API.G_MISS_CHAR,
136: p_attribute24 IN VARCHAR2 := FND_API.G_MISS_CHAR,
137: p_attribute25 IN VARCHAR2 := FND_API.G_MISS_CHAR,
138: p_attribute26 IN VARCHAR2 := FND_API.G_MISS_CHAR,
131: p_attribute19 IN VARCHAR2 := FND_API.G_MISS_CHAR,
132: p_attribute20 IN VARCHAR2 := FND_API.G_MISS_CHAR,
133: p_attribute21 IN VARCHAR2 := FND_API.G_MISS_CHAR,
134: p_attribute22 IN VARCHAR2 := FND_API.G_MISS_CHAR,
135: p_attribute23 IN VARCHAR2 := FND_API.G_MISS_CHAR,
136: p_attribute24 IN VARCHAR2 := FND_API.G_MISS_CHAR,
137: p_attribute25 IN VARCHAR2 := FND_API.G_MISS_CHAR,
138: p_attribute26 IN VARCHAR2 := FND_API.G_MISS_CHAR,
139: p_attribute27 IN VARCHAR2 := FND_API.G_MISS_CHAR,
132: p_attribute20 IN VARCHAR2 := FND_API.G_MISS_CHAR,
133: p_attribute21 IN VARCHAR2 := FND_API.G_MISS_CHAR,
134: p_attribute22 IN VARCHAR2 := FND_API.G_MISS_CHAR,
135: p_attribute23 IN VARCHAR2 := FND_API.G_MISS_CHAR,
136: p_attribute24 IN VARCHAR2 := FND_API.G_MISS_CHAR,
137: p_attribute25 IN VARCHAR2 := FND_API.G_MISS_CHAR,
138: p_attribute26 IN VARCHAR2 := FND_API.G_MISS_CHAR,
139: p_attribute27 IN VARCHAR2 := FND_API.G_MISS_CHAR,
140: p_attribute28 IN VARCHAR2 := FND_API.G_MISS_CHAR,
133: p_attribute21 IN VARCHAR2 := FND_API.G_MISS_CHAR,
134: p_attribute22 IN VARCHAR2 := FND_API.G_MISS_CHAR,
135: p_attribute23 IN VARCHAR2 := FND_API.G_MISS_CHAR,
136: p_attribute24 IN VARCHAR2 := FND_API.G_MISS_CHAR,
137: p_attribute25 IN VARCHAR2 := FND_API.G_MISS_CHAR,
138: p_attribute26 IN VARCHAR2 := FND_API.G_MISS_CHAR,
139: p_attribute27 IN VARCHAR2 := FND_API.G_MISS_CHAR,
140: p_attribute28 IN VARCHAR2 := FND_API.G_MISS_CHAR,
141: p_attribute29 IN VARCHAR2 := FND_API.G_MISS_CHAR,
134: p_attribute22 IN VARCHAR2 := FND_API.G_MISS_CHAR,
135: p_attribute23 IN VARCHAR2 := FND_API.G_MISS_CHAR,
136: p_attribute24 IN VARCHAR2 := FND_API.G_MISS_CHAR,
137: p_attribute25 IN VARCHAR2 := FND_API.G_MISS_CHAR,
138: p_attribute26 IN VARCHAR2 := FND_API.G_MISS_CHAR,
139: p_attribute27 IN VARCHAR2 := FND_API.G_MISS_CHAR,
140: p_attribute28 IN VARCHAR2 := FND_API.G_MISS_CHAR,
141: p_attribute29 IN VARCHAR2 := FND_API.G_MISS_CHAR,
142: p_attribute30 IN VARCHAR2 := FND_API.G_MISS_CHAR,
135: p_attribute23 IN VARCHAR2 := FND_API.G_MISS_CHAR,
136: p_attribute24 IN VARCHAR2 := FND_API.G_MISS_CHAR,
137: p_attribute25 IN VARCHAR2 := FND_API.G_MISS_CHAR,
138: p_attribute26 IN VARCHAR2 := FND_API.G_MISS_CHAR,
139: p_attribute27 IN VARCHAR2 := FND_API.G_MISS_CHAR,
140: p_attribute28 IN VARCHAR2 := FND_API.G_MISS_CHAR,
141: p_attribute29 IN VARCHAR2 := FND_API.G_MISS_CHAR,
142: p_attribute30 IN VARCHAR2 := FND_API.G_MISS_CHAR,
143: p_context IN VARCHAR2 := FND_API.G_MISS_CHAR);
136: p_attribute24 IN VARCHAR2 := FND_API.G_MISS_CHAR,
137: p_attribute25 IN VARCHAR2 := FND_API.G_MISS_CHAR,
138: p_attribute26 IN VARCHAR2 := FND_API.G_MISS_CHAR,
139: p_attribute27 IN VARCHAR2 := FND_API.G_MISS_CHAR,
140: p_attribute28 IN VARCHAR2 := FND_API.G_MISS_CHAR,
141: p_attribute29 IN VARCHAR2 := FND_API.G_MISS_CHAR,
142: p_attribute30 IN VARCHAR2 := FND_API.G_MISS_CHAR,
143: p_context IN VARCHAR2 := FND_API.G_MISS_CHAR);
144:
137: p_attribute25 IN VARCHAR2 := FND_API.G_MISS_CHAR,
138: p_attribute26 IN VARCHAR2 := FND_API.G_MISS_CHAR,
139: p_attribute27 IN VARCHAR2 := FND_API.G_MISS_CHAR,
140: p_attribute28 IN VARCHAR2 := FND_API.G_MISS_CHAR,
141: p_attribute29 IN VARCHAR2 := FND_API.G_MISS_CHAR,
142: p_attribute30 IN VARCHAR2 := FND_API.G_MISS_CHAR,
143: p_context IN VARCHAR2 := FND_API.G_MISS_CHAR);
144:
145: PROCEDURE Cache_Revision_Variables
138: p_attribute26 IN VARCHAR2 := FND_API.G_MISS_CHAR,
139: p_attribute27 IN VARCHAR2 := FND_API.G_MISS_CHAR,
140: p_attribute28 IN VARCHAR2 := FND_API.G_MISS_CHAR,
141: p_attribute29 IN VARCHAR2 := FND_API.G_MISS_CHAR,
142: p_attribute30 IN VARCHAR2 := FND_API.G_MISS_CHAR,
143: p_context IN VARCHAR2 := FND_API.G_MISS_CHAR);
144:
145: PROCEDURE Cache_Revision_Variables
146: (p_return_status OUT NOCOPY VARCHAR2,
139: p_attribute27 IN VARCHAR2 := FND_API.G_MISS_CHAR,
140: p_attribute28 IN VARCHAR2 := FND_API.G_MISS_CHAR,
141: p_attribute29 IN VARCHAR2 := FND_API.G_MISS_CHAR,
142: p_attribute30 IN VARCHAR2 := FND_API.G_MISS_CHAR,
143: p_context IN VARCHAR2 := FND_API.G_MISS_CHAR);
144:
145: PROCEDURE Cache_Revision_Variables
146: (p_return_status OUT NOCOPY VARCHAR2,
147: p_budget_revision_id IN NUMBER);
147: p_budget_revision_id IN NUMBER);
148:
149: PROCEDURE Create_Mass_Revision_Entries
150: ( p_api_version IN NUMBER,
151: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
152: p_commit IN VARCHAR2 := FND_API.G_FALSE,
153: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
154: p_return_status OUT NOCOPY VARCHAR2,
155: p_msg_count OUT NOCOPY NUMBER,
148:
149: PROCEDURE Create_Mass_Revision_Entries
150: ( p_api_version IN NUMBER,
151: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
152: p_commit IN VARCHAR2 := FND_API.G_FALSE,
153: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
154: p_return_status OUT NOCOPY VARCHAR2,
155: p_msg_count OUT NOCOPY NUMBER,
156: p_msg_data OUT NOCOPY VARCHAR2,
149: PROCEDURE Create_Mass_Revision_Entries
150: ( p_api_version IN NUMBER,
151: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
152: p_commit IN VARCHAR2 := FND_API.G_FALSE,
153: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
154: p_return_status OUT NOCOPY VARCHAR2,
155: p_msg_count OUT NOCOPY NUMBER,
156: p_msg_data OUT NOCOPY VARCHAR2,
157: p_data_extract_id IN NUMBER,
155: p_msg_count OUT NOCOPY NUMBER,
156: p_msg_data OUT NOCOPY VARCHAR2,
157: p_data_extract_id IN NUMBER,
158: p_budget_revision_id IN NUMBER,
159: p_parameter_id IN NUMBER := FND_API.G_MISS_NUM);
160:
161: PROCEDURE Create_Revision_Accounts
162: ( p_api_version IN NUMBER,
163: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
159: p_parameter_id IN NUMBER := FND_API.G_MISS_NUM);
160:
161: PROCEDURE Create_Revision_Accounts
162: ( p_api_version IN NUMBER,
163: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
164: p_commit IN VARCHAR2 := FND_API.G_FALSE,
165: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
166: p_return_status OUT NOCOPY VARCHAR2,
167: p_msg_count OUT NOCOPY NUMBER,
160:
161: PROCEDURE Create_Revision_Accounts
162: ( p_api_version IN NUMBER,
163: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
164: p_commit IN VARCHAR2 := FND_API.G_FALSE,
165: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
166: p_return_status OUT NOCOPY VARCHAR2,
167: p_msg_count OUT NOCOPY NUMBER,
168: p_msg_data OUT NOCOPY VARCHAR2,
161: PROCEDURE Create_Revision_Accounts
162: ( p_api_version IN NUMBER,
163: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
164: p_commit IN VARCHAR2 := FND_API.G_FALSE,
165: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
166: p_return_status OUT NOCOPY VARCHAR2,
167: p_msg_count OUT NOCOPY NUMBER,
168: p_msg_data OUT NOCOPY VARCHAR2,
169: p_budget_revision_id IN NUMBER := FND_API.G_MISS_NUM,
165: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
166: p_return_status OUT NOCOPY VARCHAR2,
167: p_msg_count OUT NOCOPY NUMBER,
168: p_msg_data OUT NOCOPY VARCHAR2,
169: p_budget_revision_id IN NUMBER := FND_API.G_MISS_NUM,
170: p_budget_revision_acct_line_id IN OUT NOCOPY NUMBER,
171: p_code_combination_id IN NUMBER,
172: p_budget_group_id IN NUMBER,
173: p_position_id IN NUMBER := FND_API.G_MISS_NUM,
169: p_budget_revision_id IN NUMBER := FND_API.G_MISS_NUM,
170: p_budget_revision_acct_line_id IN OUT NOCOPY NUMBER,
171: p_code_combination_id IN NUMBER,
172: p_budget_group_id IN NUMBER,
173: p_position_id IN NUMBER := FND_API.G_MISS_NUM,
174: p_gl_period_name IN VARCHAR2,
175: p_gl_budget_version_id IN NUMBER := FND_API.G_MISS_NUM,
176: p_currency_code IN VARCHAR2,
177: p_budget_balance IN NUMBER,
171: p_code_combination_id IN NUMBER,
172: p_budget_group_id IN NUMBER,
173: p_position_id IN NUMBER := FND_API.G_MISS_NUM,
174: p_gl_period_name IN VARCHAR2,
175: p_gl_budget_version_id IN NUMBER := FND_API.G_MISS_NUM,
176: p_currency_code IN VARCHAR2,
177: p_budget_balance IN NUMBER,
178: p_revision_type IN VARCHAR2,
179: p_revision_value_type IN VARCHAR2,
187: p_functional_transaction IN VARCHAR2 := NULL);
188:
189: PROCEDURE Create_Revision_Positions
190: ( p_api_version IN NUMBER,
191: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
192: p_commit IN VARCHAR2 := FND_API.G_FALSE,
193: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
194: p_return_status OUT NOCOPY VARCHAR2,
195: p_msg_count OUT NOCOPY NUMBER,
188:
189: PROCEDURE Create_Revision_Positions
190: ( p_api_version IN NUMBER,
191: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
192: p_commit IN VARCHAR2 := FND_API.G_FALSE,
193: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
194: p_return_status OUT NOCOPY VARCHAR2,
195: p_msg_count OUT NOCOPY NUMBER,
196: p_msg_data OUT NOCOPY VARCHAR2,
189: PROCEDURE Create_Revision_Positions
190: ( p_api_version IN NUMBER,
191: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
192: p_commit IN VARCHAR2 := FND_API.G_FALSE,
193: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
194: p_return_status OUT NOCOPY VARCHAR2,
195: p_msg_count OUT NOCOPY NUMBER,
196: p_msg_data OUT NOCOPY VARCHAR2,
197: p_budget_revision_id IN NUMBER ,
208: p_view_line_flag IN VARCHAR2);
209:
210: PROCEDURE Budget_Revision_Funds_Check
211: ( p_api_version IN NUMBER,
212: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
213: p_commit IN VARCHAR2 := FND_API.G_FALSE,
214: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
215: p_return_status OUT NOCOPY VARCHAR2,
216: p_msg_count OUT NOCOPY NUMBER,
209:
210: PROCEDURE Budget_Revision_Funds_Check
211: ( p_api_version IN NUMBER,
212: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
213: p_commit IN VARCHAR2 := FND_API.G_FALSE,
214: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
215: p_return_status OUT NOCOPY VARCHAR2,
216: p_msg_count OUT NOCOPY NUMBER,
217: p_msg_data OUT NOCOPY VARCHAR2,
210: PROCEDURE Budget_Revision_Funds_Check
211: ( p_api_version IN NUMBER,
212: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
213: p_commit IN VARCHAR2 := FND_API.G_FALSE,
214: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
215: p_return_status OUT NOCOPY VARCHAR2,
216: p_msg_count OUT NOCOPY NUMBER,
217: p_msg_data OUT NOCOPY VARCHAR2,
218: p_budget_revision_id IN NUMBER,
215: p_return_status OUT NOCOPY VARCHAR2,
216: p_msg_count OUT NOCOPY NUMBER,
217: p_msg_data OUT NOCOPY VARCHAR2,
218: p_budget_revision_id IN NUMBER,
219: p_funds_reserve_flag IN VARCHAR2 := FND_API.G_MISS_CHAR,
220: p_fund_check_failures OUT NOCOPY NUMBER, -- bug#4341619
221: --Bug#4310411
222: p_called_from IN VARCHAR2 := 'PSBBGRVS');
223:
222: p_called_from IN VARCHAR2 := 'PSBBGRVS');
223:
224: PROCEDURE Apply_Revision_Acct_Parameters
225: ( p_api_version IN NUMBER,
226: p_init_msg_list 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_parameter_id IN NUMBER,
230: p_parameter_name IN VARCHAR2,
223:
224: PROCEDURE Apply_Revision_Acct_Parameters
225: ( p_api_version IN NUMBER,
226: p_init_msg_list 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_parameter_id IN NUMBER,
230: p_parameter_name IN VARCHAR2,
231: p_compound_annually IN VARCHAR2,
242: (p_code_combination_id IN NUMBER,
243: p_budget_group_id IN NUMBER,
244: p_gl_period IN VARCHAR2,
245: p_gl_budget_version_id IN NUMBER,
246: p_set_of_books_id IN NUMBER := FND_API.G_MISS_NUM,
247: p_end_gl_period IN VARCHAR2 := FND_API.G_MISS_CHAR,
248: p_currency_code IN VARCHAR2 DEFAULT NULL) RETURN NUMBER;
249:
250: PROCEDURE Find_FTE
243: p_budget_group_id IN NUMBER,
244: p_gl_period IN VARCHAR2,
245: p_gl_budget_version_id IN NUMBER,
246: p_set_of_books_id IN NUMBER := FND_API.G_MISS_NUM,
247: p_end_gl_period IN VARCHAR2 := FND_API.G_MISS_CHAR,
248: p_currency_code IN VARCHAR2 DEFAULT NULL) RETURN NUMBER;
249:
250: PROCEDURE Find_FTE
251: ( p_api_version IN NUMBER,
248: p_currency_code IN VARCHAR2 DEFAULT NULL) RETURN NUMBER;
249:
250: PROCEDURE Find_FTE
251: ( p_api_version IN NUMBER,
252: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
253: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
254: p_return_status OUT NOCOPY VARCHAR2,
255: p_msg_count OUT NOCOPY NUMBER,
256: p_msg_data OUT NOCOPY VARCHAR2,
249:
250: PROCEDURE Find_FTE
251: ( p_api_version IN NUMBER,
252: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
253: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
254: p_return_status OUT NOCOPY VARCHAR2,
255: p_msg_count OUT NOCOPY NUMBER,
256: p_msg_data OUT NOCOPY VARCHAR2,
257: p_position_id IN NUMBER,
267: p_revised_fte OUT NOCOPY NUMBER);
268:
269: PROCEDURE Calculate_Position_Cost
270: ( p_api_version IN NUMBER,
271: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
272: p_commit IN VARCHAR2 := FND_API.G_FALSE,
273: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
274: p_msg_count OUT NOCOPY NUMBER,
275: p_msg_data OUT NOCOPY VARCHAR2,
268:
269: PROCEDURE Calculate_Position_Cost
270: ( p_api_version IN NUMBER,
271: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
272: p_commit IN VARCHAR2 := FND_API.G_FALSE,
273: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
274: p_msg_count OUT NOCOPY NUMBER,
275: p_msg_data OUT NOCOPY VARCHAR2,
276: p_return_status OUT NOCOPY VARCHAR2,
269: PROCEDURE Calculate_Position_Cost
270: ( p_api_version IN NUMBER,
271: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
272: p_commit IN VARCHAR2 := FND_API.G_FALSE,
273: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
274: p_msg_count OUT NOCOPY NUMBER,
275: p_msg_data OUT NOCOPY VARCHAR2,
276: p_return_status OUT NOCOPY VARCHAR2,
277: p_mass_revision IN BOOLEAN := FALSE,
284:
285: -- Bug 3029168 added p_event_type
286: PROCEDURE CREATE_BASE_BUDGET_REVISION
287: ( p_api_version IN NUMBER,
288: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
289: p_commit IN VARCHAR2 := FND_API.G_FALSE,
290: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
291: p_return_status OUT NOCOPY VARCHAR2,
292: p_msg_count OUT NOCOPY NUMBER,
285: -- Bug 3029168 added p_event_type
286: PROCEDURE CREATE_BASE_BUDGET_REVISION
287: ( p_api_version IN NUMBER,
288: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
289: p_commit IN VARCHAR2 := FND_API.G_FALSE,
290: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
291: p_return_status OUT NOCOPY VARCHAR2,
292: p_msg_count OUT NOCOPY NUMBER,
293: p_msg_data OUT NOCOPY VARCHAR2,
286: PROCEDURE CREATE_BASE_BUDGET_REVISION
287: ( p_api_version IN NUMBER,
288: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
289: p_commit IN VARCHAR2 := FND_API.G_FALSE,
290: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
291: p_return_status OUT NOCOPY VARCHAR2,
292: p_msg_count OUT NOCOPY NUMBER,
293: p_msg_data OUT NOCOPY VARCHAR2,
294: p_worksheet_id IN NUMBER,
295: p_event_type IN VARCHAR2 DEFAULT 'BP');
296:
297: PROCEDURE Apply_Constraints
298: ( p_api_version IN NUMBER,
299: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
300: p_return_status OUT NOCOPY VARCHAR2,
301: p_validation_status OUT NOCOPY VARCHAR2,
302: p_budget_revision_id IN NUMBER,
303: p_constraint_set_id IN NUMBER);
303: p_constraint_set_id IN NUMBER);
304:
305: PROCEDURE Delete_Revision_Accounts
306: ( p_api_version IN NUMBER,
307: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
308: p_commit IN VARCHAR2 := FND_API.G_FALSE,
309: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
310: p_return_status OUT NOCOPY VARCHAR2,
311: p_msg_count OUT NOCOPY NUMBER,
304:
305: PROCEDURE Delete_Revision_Accounts
306: ( p_api_version IN NUMBER,
307: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
308: p_commit IN VARCHAR2 := FND_API.G_FALSE,
309: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
310: p_return_status OUT NOCOPY VARCHAR2,
311: p_msg_count OUT NOCOPY NUMBER,
312: p_msg_data OUT NOCOPY VARCHAR2,
305: PROCEDURE Delete_Revision_Accounts
306: ( p_api_version IN NUMBER,
307: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
308: p_commit IN VARCHAR2 := FND_API.G_FALSE,
309: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
310: p_return_status OUT NOCOPY VARCHAR2,
311: p_msg_count OUT NOCOPY NUMBER,
312: p_msg_data OUT NOCOPY VARCHAR2,
313: p_budget_revision_id IN NUMBER,
314: p_budget_revision_acct_line_id IN NUMBER);
315:
316: PROCEDURE Delete_Revision_Positions
317: ( p_api_version IN NUMBER,
318: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
319: p_commit IN VARCHAR2 := FND_API.G_FALSE,
320: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
321: p_return_status OUT NOCOPY VARCHAR2,
322: p_msg_count OUT NOCOPY NUMBER,
315:
316: PROCEDURE Delete_Revision_Positions
317: ( p_api_version IN NUMBER,
318: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
319: p_commit IN VARCHAR2 := FND_API.G_FALSE,
320: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
321: p_return_status OUT NOCOPY VARCHAR2,
322: p_msg_count OUT NOCOPY NUMBER,
323: p_msg_data OUT NOCOPY VARCHAR2,
316: PROCEDURE Delete_Revision_Positions
317: ( p_api_version IN NUMBER,
318: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
319: p_commit IN VARCHAR2 := FND_API.G_FALSE,
320: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
321: p_return_status OUT NOCOPY VARCHAR2,
322: p_msg_count OUT NOCOPY NUMBER,
323: p_msg_data OUT NOCOPY VARCHAR2,
324: p_budget_revision_id IN NUMBER,
366: /* Budget Revison Rules Enhancement Start */
367:
368: PROCEDURE Apply_Revision_Rules
369: ( p_api_version IN NUMBER,
370: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
371: p_return_status OUT NOCOPY VARCHAR2,
372: p_validation_status OUT NOCOPY VARCHAR2,
373: p_budget_revision_id IN NUMBER
374: );