APPS.PSB_WS_ACCT_PVT dependencies on FND_API

Line 18: -- Pre-reqs : FND_API, FND_MESSAGE, PSB_WS_ACCT1

14: /* ----------------------------------------------------------------------- */
15:
16: -- API name : Check_CCID_Type
17: -- Type : Private
18: -- Pre-reqs : FND_API, FND_MESSAGE, PSB_WS_ACCT1
19: -- Parameters :
20: -- IN : p_api_version IN NUMBER Required
21: -- p_init_msg_list IN VARCHAR2 Optional
22: -- Default = FND_API.G_FALSE

Line 22: -- Default = FND_API.G_FALSE

18: -- Pre-reqs : FND_API, FND_MESSAGE, PSB_WS_ACCT1
19: -- Parameters :
20: -- IN : p_api_version IN NUMBER Required
21: -- p_init_msg_list IN VARCHAR2 Optional
22: -- Default = FND_API.G_FALSE
23: -- p_validation_level IN NUMBER Optional
24: -- Default = FND_API.G_VALID_LEVEL_NONE
25: -- p_flex_code IN NUMBER Required
26: -- p_ccid IN NUMBER Required

Line 24: -- Default = FND_API.G_VALID_LEVEL_NONE

20: -- IN : p_api_version IN NUMBER Required
21: -- p_init_msg_list IN VARCHAR2 Optional
22: -- Default = FND_API.G_FALSE
23: -- p_validation_level IN NUMBER Optional
24: -- Default = FND_API.G_VALID_LEVEL_NONE
25: -- p_flex_code IN NUMBER Required
26: -- p_ccid IN NUMBER Required
27: -- p_budget_group_id IN NUMBER Required
28: -- .

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

44:
45:
46: PROCEDURE Check_CCID_Type
47: ( p_api_version IN NUMBER,
48: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
49: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_NONE,
50: p_return_status OUT NOCOPY VARCHAR2,
51: p_msg_count OUT NOCOPY NUMBER,
52: p_msg_data OUT NOCOPY VARCHAR2,

Line 49: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_NONE,

45:
46: PROCEDURE Check_CCID_Type
47: ( p_api_version IN NUMBER,
48: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
49: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_NONE,
50: p_return_status OUT NOCOPY VARCHAR2,
51: p_msg_count OUT NOCOPY NUMBER,
52: p_msg_data OUT NOCOPY VARCHAR2,
53: p_ccid_type OUT NOCOPY VARCHAR2,

Line 63: -- Pre-reqs : FND_API, FND_MESSAGE, PSB_WS_ACCT1

59: /* ----------------------------------------------------------------------- */
60:
61: -- API name : Create_Account_Dist
62: -- Type : Private
63: -- Pre-reqs : FND_API, FND_MESSAGE, PSB_WS_ACCT1
64: -- Parameters :
65: -- IN : p_api_version IN NUMBER Required
66: -- p_init_msg_list IN VARCHAR2 Optional
67: -- Default = FND_API.G_FALSE

Line 67: -- Default = FND_API.G_FALSE

63: -- Pre-reqs : FND_API, FND_MESSAGE, PSB_WS_ACCT1
64: -- Parameters :
65: -- IN : p_api_version IN NUMBER Required
66: -- p_init_msg_list IN VARCHAR2 Optional
67: -- Default = FND_API.G_FALSE
68: -- p_commit IN VARCHAR2 Optional
69: -- Default = FND_API.G_FALSE
70: -- p_validation_level IN NUMBER Optional
71: -- Default = FND_API.G_VALID_LEVEL_NONE

Line 69: -- Default = FND_API.G_FALSE

65: -- IN : p_api_version IN NUMBER Required
66: -- p_init_msg_list IN VARCHAR2 Optional
67: -- Default = FND_API.G_FALSE
68: -- p_commit IN VARCHAR2 Optional
69: -- Default = FND_API.G_FALSE
70: -- p_validation_level IN NUMBER Optional
71: -- Default = FND_API.G_VALID_LEVEL_NONE
72: -- p_worksheet_id IN NUMBER Required
73: -- p_check_spal_exists IN VARCHAR2 Optional

Line 71: -- Default = FND_API.G_VALID_LEVEL_NONE

67: -- Default = FND_API.G_FALSE
68: -- p_commit IN VARCHAR2 Optional
69: -- Default = FND_API.G_FALSE
70: -- p_validation_level IN NUMBER Optional
71: -- Default = FND_API.G_VALID_LEVEL_NONE
72: -- p_worksheet_id IN NUMBER Required
73: -- p_check_spal_exists IN VARCHAR2 Optional
74: -- Default = FND_API.G_TRUE
75: -- p_gl_cutoff_period IN DATE Optional

Line 74: -- Default = FND_API.G_TRUE

70: -- p_validation_level IN NUMBER Optional
71: -- Default = FND_API.G_VALID_LEVEL_NONE
72: -- p_worksheet_id IN NUMBER Required
73: -- p_check_spal_exists IN VARCHAR2 Optional
74: -- Default = FND_API.G_TRUE
75: -- p_gl_cutoff_period IN DATE Optional
76: -- Default = FND_API.G_MISS_DATE
77: -- p_allocrule_set_id IN NUMBER Optional
78: -- Default = FND_API.G_MISS_NUM

Line 76: -- Default = FND_API.G_MISS_DATE

72: -- p_worksheet_id IN NUMBER Required
73: -- p_check_spal_exists IN VARCHAR2 Optional
74: -- Default = FND_API.G_TRUE
75: -- p_gl_cutoff_period IN DATE Optional
76: -- Default = FND_API.G_MISS_DATE
77: -- p_allocrule_set_id IN NUMBER Optional
78: -- Default = FND_API.G_MISS_NUM
79: -- p_budget_calendar_id IN NUMBER Optional
80: -- Default = FND_API.G_MISS_NUM

Line 78: -- Default = FND_API.G_MISS_NUM

74: -- Default = FND_API.G_TRUE
75: -- p_gl_cutoff_period IN DATE Optional
76: -- Default = FND_API.G_MISS_DATE
77: -- p_allocrule_set_id IN NUMBER Optional
78: -- Default = FND_API.G_MISS_NUM
79: -- p_budget_calendar_id IN NUMBER Optional
80: -- Default = FND_API.G_MISS_NUM
81: -- p_rounding_factor IN NUMBER Optional
82: -- Default = FND_API.G_MISS_NUM

Line 80: -- Default = FND_API.G_MISS_NUM

76: -- Default = FND_API.G_MISS_DATE
77: -- p_allocrule_set_id IN NUMBER Optional
78: -- Default = FND_API.G_MISS_NUM
79: -- p_budget_calendar_id IN NUMBER Optional
80: -- Default = FND_API.G_MISS_NUM
81: -- p_rounding_factor IN NUMBER Optional
82: -- Default = FND_API.G_MISS_NUM
83: -- p_stage_set_id IN NUMBER Optional
84: -- Default = FND_API.G_MISS_NUM

Line 82: -- Default = FND_API.G_MISS_NUM

78: -- Default = FND_API.G_MISS_NUM
79: -- p_budget_calendar_id IN NUMBER Optional
80: -- Default = FND_API.G_MISS_NUM
81: -- p_rounding_factor IN NUMBER Optional
82: -- Default = FND_API.G_MISS_NUM
83: -- p_stage_set_id IN NUMBER Optional
84: -- Default = FND_API.G_MISS_NUM
85: -- p_budget_year_id IN NUMBER Required
86: -- p_budget_group_id IN NUMBER Required

Line 84: -- Default = FND_API.G_MISS_NUM

80: -- Default = FND_API.G_MISS_NUM
81: -- p_rounding_factor IN NUMBER Optional
82: -- Default = FND_API.G_MISS_NUM
83: -- p_stage_set_id IN NUMBER Optional
84: -- Default = FND_API.G_MISS_NUM
85: -- p_budget_year_id IN NUMBER Required
86: -- p_budget_group_id IN NUMBER Required
87: -- p_ccid IN NUMBER Optional
88: -- Default = FND_API.G_MISS_NUM

Line 88: -- Default = FND_API.G_MISS_NUM

84: -- Default = FND_API.G_MISS_NUM
85: -- p_budget_year_id IN NUMBER Required
86: -- p_budget_group_id IN NUMBER Required
87: -- p_ccid IN NUMBER Optional
88: -- Default = FND_API.G_MISS_NUM
89: -- p_flex_mapping_set_id IN NUMBER Optional
90: -- Default = FND_API.G_MISS_NUM
91: -- p_map_accounts IN BOOLEAN Optional
92: -- Default = FALSE

Line 90: -- Default = FND_API.G_MISS_NUM

86: -- p_budget_group_id IN NUMBER Required
87: -- p_ccid IN NUMBER Optional
88: -- Default = FND_API.G_MISS_NUM
89: -- p_flex_mapping_set_id IN NUMBER Optional
90: -- Default = FND_API.G_MISS_NUM
91: -- p_map_accounts IN BOOLEAN Optional
92: -- Default = FALSE
93: -- p_flex_code IN NUMBER Optional
94: -- Default = FND_API.G_MISS_NUM

Line 94: -- Default = FND_API.G_MISS_NUM

90: -- Default = FND_API.G_MISS_NUM
91: -- p_map_accounts IN BOOLEAN Optional
92: -- Default = FALSE
93: -- p_flex_code IN NUMBER Optional
94: -- Default = FND_API.G_MISS_NUM
95: -- p_concatenated_segments IN VARCHAR2 Optional
96: -- Default = FND_API.G_MISS_CHAR
97: -- p_startdate_pp IN DATE Optional
98: -- Default = FND_API.G_MISS_DATE

Line 96: -- Default = FND_API.G_MISS_CHAR

92: -- Default = FALSE
93: -- p_flex_code IN NUMBER Optional
94: -- Default = FND_API.G_MISS_NUM
95: -- p_concatenated_segments IN VARCHAR2 Optional
96: -- Default = FND_API.G_MISS_CHAR
97: -- p_startdate_pp IN DATE Optional
98: -- Default = FND_API.G_MISS_DATE
99: -- p_template_id IN NUMBER Optional
100: -- Default = FND_API.G_MISS_NUM

Line 98: -- Default = FND_API.G_MISS_DATE

94: -- Default = FND_API.G_MISS_NUM
95: -- p_concatenated_segments IN VARCHAR2 Optional
96: -- Default = FND_API.G_MISS_CHAR
97: -- p_startdate_pp IN DATE Optional
98: -- Default = FND_API.G_MISS_DATE
99: -- p_template_id IN NUMBER Optional
100: -- Default = FND_API.G_MISS_NUM
101: -- p_currency_code IN VARCHAR2 Required
102: -- p_balance_type IN VARCHAR2 Required

Line 100: -- Default = FND_API.G_MISS_NUM

96: -- Default = FND_API.G_MISS_CHAR
97: -- p_startdate_pp IN DATE Optional
98: -- Default = FND_API.G_MISS_DATE
99: -- p_template_id IN NUMBER Optional
100: -- Default = FND_API.G_MISS_NUM
101: -- p_currency_code IN VARCHAR2 Required
102: -- p_balance_type IN VARCHAR2 Required
103: -- p_ytd_amount IN NUMBER Required
104: -- p_distribute_flag IN VARCHAR2 Optional

Line 105: -- Default = FND_API.G_MISS_CHAR

101: -- p_currency_code IN VARCHAR2 Required
102: -- p_balance_type IN VARCHAR2 Required
103: -- p_ytd_amount IN NUMBER Required
104: -- p_distribute_flag IN VARCHAR2 Optional
105: -- Default = FND_API.G_MISS_CHAR
106: -- p_annual_fte IN NUMBER Optional
107: -- Default = FND_API.G_MISS_NUM
108: -- p_period_amount IN TABLE Required
109: -- p_position_line_id IN NUMBER Optional

Line 107: -- Default = FND_API.G_MISS_NUM

103: -- p_ytd_amount IN NUMBER Required
104: -- p_distribute_flag IN VARCHAR2 Optional
105: -- Default = FND_API.G_MISS_CHAR
106: -- p_annual_fte IN NUMBER Optional
107: -- Default = FND_API.G_MISS_NUM
108: -- p_period_amount IN TABLE Required
109: -- p_position_line_id IN NUMBER Optional
110: -- Default = FND_API.G_MISS_NUM
111: -- p_element_set_id IN NUMBER Optional

Line 110: -- Default = FND_API.G_MISS_NUM

106: -- p_annual_fte IN NUMBER Optional
107: -- Default = FND_API.G_MISS_NUM
108: -- p_period_amount IN TABLE Required
109: -- p_position_line_id IN NUMBER Optional
110: -- Default = FND_API.G_MISS_NUM
111: -- p_element_set_id IN NUMBER Optional
112: -- Default = FND_API.G_MISS_NUM
113: -- p_salary_account_line IN VARCHAR2 Optional
114: -- Default = FND_API.G_FALSE

Line 112: -- Default = FND_API.G_MISS_NUM

108: -- p_period_amount IN TABLE Required
109: -- p_position_line_id IN NUMBER Optional
110: -- Default = FND_API.G_MISS_NUM
111: -- p_element_set_id IN NUMBER Optional
112: -- Default = FND_API.G_MISS_NUM
113: -- p_salary_account_line IN VARCHAR2 Optional
114: -- Default = FND_API.G_FALSE
115: -- p_service_package_id IN NUMBER Optional
116: -- Default = FND_API.G_MISS_NUM

Line 114: -- Default = FND_API.G_FALSE

110: -- Default = FND_API.G_MISS_NUM
111: -- p_element_set_id IN NUMBER Optional
112: -- Default = FND_API.G_MISS_NUM
113: -- p_salary_account_line IN VARCHAR2 Optional
114: -- Default = FND_API.G_FALSE
115: -- p_service_package_id IN NUMBER Optional
116: -- Default = FND_API.G_MISS_NUM
117: -- p_start_stage_seq IN NUMBER Optional
118: -- Default = FND_API.G_MISS_NUM

Line 116: -- Default = FND_API.G_MISS_NUM

112: -- Default = FND_API.G_MISS_NUM
113: -- p_salary_account_line IN VARCHAR2 Optional
114: -- Default = FND_API.G_FALSE
115: -- p_service_package_id IN NUMBER Optional
116: -- Default = FND_API.G_MISS_NUM
117: -- p_start_stage_seq IN NUMBER Optional
118: -- Default = FND_API.G_MISS_NUM
119: -- p_current_stage_seq IN NUMBER Optional
120: -- Default = FND_API.G_MISS_NUM

Line 118: -- Default = FND_API.G_MISS_NUM

114: -- Default = FND_API.G_FALSE
115: -- p_service_package_id IN NUMBER Optional
116: -- Default = FND_API.G_MISS_NUM
117: -- p_start_stage_seq IN NUMBER Optional
118: -- Default = FND_API.G_MISS_NUM
119: -- p_current_stage_seq IN NUMBER Optional
120: -- Default = FND_API.G_MISS_NUM
121: -- p_end_stage_seq IN NUMBER Optional
122: -- Default = FND_API.G_MISS_NUM

Line 120: -- Default = FND_API.G_MISS_NUM

116: -- Default = FND_API.G_MISS_NUM
117: -- p_start_stage_seq IN NUMBER Optional
118: -- Default = FND_API.G_MISS_NUM
119: -- p_current_stage_seq IN NUMBER Optional
120: -- Default = FND_API.G_MISS_NUM
121: -- p_end_stage_seq IN NUMBER Optional
122: -- Default = FND_API.G_MISS_NUM
123: -- p_copy_of_account_line_id IN NUMBER Optional
124: -- Default = FND_API.G_MISS_NUM

Line 122: -- Default = FND_API.G_MISS_NUM

118: -- Default = FND_API.G_MISS_NUM
119: -- p_current_stage_seq IN NUMBER Optional
120: -- Default = FND_API.G_MISS_NUM
121: -- p_end_stage_seq IN NUMBER Optional
122: -- Default = FND_API.G_MISS_NUM
123: -- p_copy_of_account_line_id IN NUMBER Optional
124: -- Default = FND_API.G_MISS_NUM
125: -- .
126: -- OUT NOCOPY : p_return_status OUT NOCOPY VARCHAR2(1)

Line 124: -- Default = FND_API.G_MISS_NUM

120: -- Default = FND_API.G_MISS_NUM
121: -- p_end_stage_seq IN NUMBER Optional
122: -- Default = FND_API.G_MISS_NUM
123: -- p_copy_of_account_line_id IN NUMBER Optional
124: -- Default = FND_API.G_MISS_NUM
125: -- .
126: -- OUT NOCOPY : p_return_status OUT NOCOPY VARCHAR2(1)
127: -- p_account_line_id OUT NOCOPY NUMBER
128: -- p_msg_count OUT NOCOPY NUMBER

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

140: --
141:
142: PROCEDURE Create_Account_Dist
143: ( p_api_version IN NUMBER,
144: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
145: p_commit IN VARCHAR2 := FND_API.G_FALSE,
146: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_NONE,
147: p_return_status OUT NOCOPY VARCHAR2,
148: p_account_line_id OUT NOCOPY NUMBER,

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

141:
142: PROCEDURE Create_Account_Dist
143: ( p_api_version IN NUMBER,
144: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
145: p_commit IN VARCHAR2 := FND_API.G_FALSE,
146: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_NONE,
147: p_return_status OUT NOCOPY VARCHAR2,
148: p_account_line_id OUT NOCOPY NUMBER,
149: p_msg_count OUT NOCOPY NUMBER,

Line 146: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_NONE,

142: PROCEDURE Create_Account_Dist
143: ( p_api_version IN NUMBER,
144: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
145: p_commit IN VARCHAR2 := FND_API.G_FALSE,
146: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_NONE,
147: p_return_status OUT NOCOPY VARCHAR2,
148: p_account_line_id OUT NOCOPY NUMBER,
149: p_msg_count OUT NOCOPY NUMBER,
150: p_msg_data OUT NOCOPY VARCHAR2,

Line 152: p_check_spal_exists IN VARCHAR2 := FND_API.G_TRUE,

148: p_account_line_id OUT NOCOPY NUMBER,
149: p_msg_count OUT NOCOPY NUMBER,
150: p_msg_data OUT NOCOPY VARCHAR2,
151: p_worksheet_id IN NUMBER,
152: p_check_spal_exists IN VARCHAR2 := FND_API.G_TRUE,
153: p_gl_cutoff_period IN DATE := FND_API.G_MISS_DATE,
154: p_allocrule_set_id IN NUMBER := FND_API.G_MISS_NUM,
155: p_budget_calendar_id IN NUMBER := FND_API.G_MISS_NUM,
156: p_rounding_factor IN NUMBER := FND_API.G_MISS_NUM,

Line 153: p_gl_cutoff_period IN DATE := FND_API.G_MISS_DATE,

149: p_msg_count OUT NOCOPY NUMBER,
150: p_msg_data OUT NOCOPY VARCHAR2,
151: p_worksheet_id IN NUMBER,
152: p_check_spal_exists IN VARCHAR2 := FND_API.G_TRUE,
153: p_gl_cutoff_period IN DATE := FND_API.G_MISS_DATE,
154: p_allocrule_set_id IN NUMBER := FND_API.G_MISS_NUM,
155: p_budget_calendar_id IN NUMBER := FND_API.G_MISS_NUM,
156: p_rounding_factor IN NUMBER := FND_API.G_MISS_NUM,
157: p_stage_set_id IN NUMBER := FND_API.G_MISS_NUM,

Line 154: p_allocrule_set_id IN NUMBER := FND_API.G_MISS_NUM,

150: p_msg_data OUT NOCOPY VARCHAR2,
151: p_worksheet_id IN NUMBER,
152: p_check_spal_exists IN VARCHAR2 := FND_API.G_TRUE,
153: p_gl_cutoff_period IN DATE := FND_API.G_MISS_DATE,
154: p_allocrule_set_id IN NUMBER := FND_API.G_MISS_NUM,
155: p_budget_calendar_id IN NUMBER := FND_API.G_MISS_NUM,
156: p_rounding_factor IN NUMBER := FND_API.G_MISS_NUM,
157: p_stage_set_id IN NUMBER := FND_API.G_MISS_NUM,
158: p_budget_year_id IN NUMBER,

Line 155: p_budget_calendar_id IN NUMBER := FND_API.G_MISS_NUM,

151: p_worksheet_id IN NUMBER,
152: p_check_spal_exists IN VARCHAR2 := FND_API.G_TRUE,
153: p_gl_cutoff_period IN DATE := FND_API.G_MISS_DATE,
154: p_allocrule_set_id IN NUMBER := FND_API.G_MISS_NUM,
155: p_budget_calendar_id IN NUMBER := FND_API.G_MISS_NUM,
156: p_rounding_factor IN NUMBER := FND_API.G_MISS_NUM,
157: p_stage_set_id IN NUMBER := FND_API.G_MISS_NUM,
158: p_budget_year_id IN NUMBER,
159: p_budget_group_id IN NUMBER,

Line 156: p_rounding_factor IN NUMBER := FND_API.G_MISS_NUM,

152: p_check_spal_exists IN VARCHAR2 := FND_API.G_TRUE,
153: p_gl_cutoff_period IN DATE := FND_API.G_MISS_DATE,
154: p_allocrule_set_id IN NUMBER := FND_API.G_MISS_NUM,
155: p_budget_calendar_id IN NUMBER := FND_API.G_MISS_NUM,
156: p_rounding_factor IN NUMBER := FND_API.G_MISS_NUM,
157: p_stage_set_id IN NUMBER := FND_API.G_MISS_NUM,
158: p_budget_year_id IN NUMBER,
159: p_budget_group_id IN NUMBER,
160: p_ccid IN NUMBER := FND_API.G_MISS_NUM,

Line 157: p_stage_set_id IN NUMBER := FND_API.G_MISS_NUM,

153: p_gl_cutoff_period IN DATE := FND_API.G_MISS_DATE,
154: p_allocrule_set_id IN NUMBER := FND_API.G_MISS_NUM,
155: p_budget_calendar_id IN NUMBER := FND_API.G_MISS_NUM,
156: p_rounding_factor IN NUMBER := FND_API.G_MISS_NUM,
157: p_stage_set_id IN NUMBER := FND_API.G_MISS_NUM,
158: p_budget_year_id IN NUMBER,
159: p_budget_group_id IN NUMBER,
160: p_ccid IN NUMBER := FND_API.G_MISS_NUM,
161: p_flex_mapping_set_id IN NUMBER := FND_API.G_MISS_NUM,

Line 160: p_ccid IN NUMBER := FND_API.G_MISS_NUM,

156: p_rounding_factor IN NUMBER := FND_API.G_MISS_NUM,
157: p_stage_set_id IN NUMBER := FND_API.G_MISS_NUM,
158: p_budget_year_id IN NUMBER,
159: p_budget_group_id IN NUMBER,
160: p_ccid IN NUMBER := FND_API.G_MISS_NUM,
161: p_flex_mapping_set_id IN NUMBER := FND_API.G_MISS_NUM,
162: p_map_accounts IN BOOLEAN := FALSE,
163: p_flex_code IN NUMBER := FND_API.G_MISS_NUM,
164: p_concatenated_segments IN VARCHAR2 := FND_API.G_MISS_CHAR,

Line 161: p_flex_mapping_set_id IN NUMBER := FND_API.G_MISS_NUM,

157: p_stage_set_id IN NUMBER := FND_API.G_MISS_NUM,
158: p_budget_year_id IN NUMBER,
159: p_budget_group_id IN NUMBER,
160: p_ccid IN NUMBER := FND_API.G_MISS_NUM,
161: p_flex_mapping_set_id IN NUMBER := FND_API.G_MISS_NUM,
162: p_map_accounts IN BOOLEAN := FALSE,
163: p_flex_code IN NUMBER := FND_API.G_MISS_NUM,
164: p_concatenated_segments IN VARCHAR2 := FND_API.G_MISS_CHAR,
165: p_startdate_pp IN DATE := FND_API.G_MISS_DATE,

Line 163: p_flex_code IN NUMBER := FND_API.G_MISS_NUM,

159: p_budget_group_id IN NUMBER,
160: p_ccid IN NUMBER := FND_API.G_MISS_NUM,
161: p_flex_mapping_set_id IN NUMBER := FND_API.G_MISS_NUM,
162: p_map_accounts IN BOOLEAN := FALSE,
163: p_flex_code IN NUMBER := FND_API.G_MISS_NUM,
164: p_concatenated_segments IN VARCHAR2 := FND_API.G_MISS_CHAR,
165: p_startdate_pp IN DATE := FND_API.G_MISS_DATE,
166: p_template_id IN NUMBER := FND_API.G_MISS_NUM,
167: p_currency_code IN VARCHAR2,

Line 164: p_concatenated_segments IN VARCHAR2 := FND_API.G_MISS_CHAR,

160: p_ccid IN NUMBER := FND_API.G_MISS_NUM,
161: p_flex_mapping_set_id IN NUMBER := FND_API.G_MISS_NUM,
162: p_map_accounts IN BOOLEAN := FALSE,
163: p_flex_code IN NUMBER := FND_API.G_MISS_NUM,
164: p_concatenated_segments IN VARCHAR2 := FND_API.G_MISS_CHAR,
165: p_startdate_pp IN DATE := FND_API.G_MISS_DATE,
166: p_template_id IN NUMBER := FND_API.G_MISS_NUM,
167: p_currency_code IN VARCHAR2,
168: p_balance_type IN VARCHAR2,

Line 165: p_startdate_pp IN DATE := FND_API.G_MISS_DATE,

161: p_flex_mapping_set_id IN NUMBER := FND_API.G_MISS_NUM,
162: p_map_accounts IN BOOLEAN := FALSE,
163: p_flex_code IN NUMBER := FND_API.G_MISS_NUM,
164: p_concatenated_segments IN VARCHAR2 := FND_API.G_MISS_CHAR,
165: p_startdate_pp IN DATE := FND_API.G_MISS_DATE,
166: p_template_id IN NUMBER := FND_API.G_MISS_NUM,
167: p_currency_code IN VARCHAR2,
168: p_balance_type IN VARCHAR2,
169: p_ytd_amount IN NUMBER,

Line 166: p_template_id IN NUMBER := FND_API.G_MISS_NUM,

162: p_map_accounts IN BOOLEAN := FALSE,
163: p_flex_code IN NUMBER := FND_API.G_MISS_NUM,
164: p_concatenated_segments IN VARCHAR2 := FND_API.G_MISS_CHAR,
165: p_startdate_pp IN DATE := FND_API.G_MISS_DATE,
166: p_template_id IN NUMBER := FND_API.G_MISS_NUM,
167: p_currency_code IN VARCHAR2,
168: p_balance_type IN VARCHAR2,
169: p_ytd_amount IN NUMBER,
170: p_distribute_flag IN VARCHAR2 := FND_API.G_FALSE,

Line 170: p_distribute_flag IN VARCHAR2 := FND_API.G_FALSE,

166: p_template_id IN NUMBER := FND_API.G_MISS_NUM,
167: p_currency_code IN VARCHAR2,
168: p_balance_type IN VARCHAR2,
169: p_ytd_amount IN NUMBER,
170: p_distribute_flag IN VARCHAR2 := FND_API.G_FALSE,
171: p_annual_fte IN NUMBER := FND_API.G_MISS_NUM,
172: p_period_amount IN PSB_WS_ACCT1.g_prdamt_tbl_type,
173: p_position_line_id IN NUMBER := FND_API.G_MISS_NUM,
174: p_element_set_id IN NUMBER := FND_API.G_MISS_NUM,

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

167: p_currency_code IN VARCHAR2,
168: p_balance_type IN VARCHAR2,
169: p_ytd_amount IN NUMBER,
170: p_distribute_flag IN VARCHAR2 := FND_API.G_FALSE,
171: p_annual_fte IN NUMBER := FND_API.G_MISS_NUM,
172: p_period_amount IN PSB_WS_ACCT1.g_prdamt_tbl_type,
173: p_position_line_id IN NUMBER := FND_API.G_MISS_NUM,
174: p_element_set_id IN NUMBER := FND_API.G_MISS_NUM,
175: p_salary_account_line IN VARCHAR2 := FND_API.G_FALSE,

Line 173: p_position_line_id IN NUMBER := FND_API.G_MISS_NUM,

169: p_ytd_amount IN NUMBER,
170: p_distribute_flag IN VARCHAR2 := FND_API.G_FALSE,
171: p_annual_fte IN NUMBER := FND_API.G_MISS_NUM,
172: p_period_amount IN PSB_WS_ACCT1.g_prdamt_tbl_type,
173: p_position_line_id IN NUMBER := FND_API.G_MISS_NUM,
174: p_element_set_id IN NUMBER := FND_API.G_MISS_NUM,
175: p_salary_account_line IN VARCHAR2 := FND_API.G_FALSE,
176: p_service_package_id IN NUMBER := FND_API.G_MISS_NUM,
177: p_start_stage_seq IN NUMBER := FND_API.G_MISS_NUM,

Line 174: p_element_set_id IN NUMBER := FND_API.G_MISS_NUM,

170: p_distribute_flag IN VARCHAR2 := FND_API.G_FALSE,
171: p_annual_fte IN NUMBER := FND_API.G_MISS_NUM,
172: p_period_amount IN PSB_WS_ACCT1.g_prdamt_tbl_type,
173: p_position_line_id IN NUMBER := FND_API.G_MISS_NUM,
174: p_element_set_id IN NUMBER := FND_API.G_MISS_NUM,
175: p_salary_account_line IN VARCHAR2 := FND_API.G_FALSE,
176: p_service_package_id IN NUMBER := FND_API.G_MISS_NUM,
177: p_start_stage_seq IN NUMBER := FND_API.G_MISS_NUM,
178: p_current_stage_seq IN NUMBER := FND_API.G_MISS_NUM,

Line 175: p_salary_account_line IN VARCHAR2 := FND_API.G_FALSE,

171: p_annual_fte IN NUMBER := FND_API.G_MISS_NUM,
172: p_period_amount IN PSB_WS_ACCT1.g_prdamt_tbl_type,
173: p_position_line_id IN NUMBER := FND_API.G_MISS_NUM,
174: p_element_set_id IN NUMBER := FND_API.G_MISS_NUM,
175: p_salary_account_line IN VARCHAR2 := FND_API.G_FALSE,
176: p_service_package_id IN NUMBER := FND_API.G_MISS_NUM,
177: p_start_stage_seq IN NUMBER := FND_API.G_MISS_NUM,
178: p_current_stage_seq IN NUMBER := FND_API.G_MISS_NUM,
179: p_end_stage_seq IN NUMBER := FND_API.G_MISS_NUM,

Line 176: p_service_package_id IN NUMBER := FND_API.G_MISS_NUM,

172: p_period_amount IN PSB_WS_ACCT1.g_prdamt_tbl_type,
173: p_position_line_id IN NUMBER := FND_API.G_MISS_NUM,
174: p_element_set_id IN NUMBER := FND_API.G_MISS_NUM,
175: p_salary_account_line IN VARCHAR2 := FND_API.G_FALSE,
176: p_service_package_id IN NUMBER := FND_API.G_MISS_NUM,
177: p_start_stage_seq IN NUMBER := FND_API.G_MISS_NUM,
178: p_current_stage_seq IN NUMBER := FND_API.G_MISS_NUM,
179: p_end_stage_seq IN NUMBER := FND_API.G_MISS_NUM,
180: p_copy_of_account_line_id IN NUMBER := FND_API.G_MISS_NUM

Line 177: p_start_stage_seq IN NUMBER := FND_API.G_MISS_NUM,

173: p_position_line_id IN NUMBER := FND_API.G_MISS_NUM,
174: p_element_set_id IN NUMBER := FND_API.G_MISS_NUM,
175: p_salary_account_line IN VARCHAR2 := FND_API.G_FALSE,
176: p_service_package_id IN NUMBER := FND_API.G_MISS_NUM,
177: p_start_stage_seq IN NUMBER := FND_API.G_MISS_NUM,
178: p_current_stage_seq IN NUMBER := FND_API.G_MISS_NUM,
179: p_end_stage_seq IN NUMBER := FND_API.G_MISS_NUM,
180: p_copy_of_account_line_id IN NUMBER := FND_API.G_MISS_NUM
181: /*For Bug No : 2440100 Start*/

Line 178: p_current_stage_seq IN NUMBER := FND_API.G_MISS_NUM,

174: p_element_set_id IN NUMBER := FND_API.G_MISS_NUM,
175: p_salary_account_line IN VARCHAR2 := FND_API.G_FALSE,
176: p_service_package_id IN NUMBER := FND_API.G_MISS_NUM,
177: p_start_stage_seq IN NUMBER := FND_API.G_MISS_NUM,
178: p_current_stage_seq IN NUMBER := FND_API.G_MISS_NUM,
179: p_end_stage_seq IN NUMBER := FND_API.G_MISS_NUM,
180: p_copy_of_account_line_id IN NUMBER := FND_API.G_MISS_NUM
181: /*For Bug No : 2440100 Start*/
182: -- Bug#4502045

Line 179: p_end_stage_seq IN NUMBER := FND_API.G_MISS_NUM,

175: p_salary_account_line IN VARCHAR2 := FND_API.G_FALSE,
176: p_service_package_id IN NUMBER := FND_API.G_MISS_NUM,
177: p_start_stage_seq IN NUMBER := FND_API.G_MISS_NUM,
178: p_current_stage_seq IN NUMBER := FND_API.G_MISS_NUM,
179: p_end_stage_seq IN NUMBER := FND_API.G_MISS_NUM,
180: p_copy_of_account_line_id IN NUMBER := FND_API.G_MISS_NUM
181: /*For Bug No : 2440100 Start*/
182: -- Bug#4502045
183: --p_create_mrc_transaction IN BOOLEAN := TRUE

Line 180: p_copy_of_account_line_id IN NUMBER := FND_API.G_MISS_NUM

176: p_service_package_id IN NUMBER := FND_API.G_MISS_NUM,
177: p_start_stage_seq IN NUMBER := FND_API.G_MISS_NUM,
178: p_current_stage_seq IN NUMBER := FND_API.G_MISS_NUM,
179: p_end_stage_seq IN NUMBER := FND_API.G_MISS_NUM,
180: p_copy_of_account_line_id IN NUMBER := FND_API.G_MISS_NUM
181: /*For Bug No : 2440100 Start*/
182: -- Bug#4502045
183: --p_create_mrc_transaction IN BOOLEAN := TRUE
184: /*For Bug No : 2440100 End*/

Line 191: -- Pre-reqs : FND_API, FND_MESSAGE, PSB_WS_ACCT1

187: /* ----------------------------------------------------------------------- */
188:
189: -- API name : Create_Account_Dist
190: -- Type : Private
191: -- Pre-reqs : FND_API, FND_MESSAGE, PSB_WS_ACCT1
192: -- Parameters :
193: -- IN : p_api_version IN NUMBER Required
194: -- p_init_msg_list IN VARCHAR2 Optional
195: -- Default = FND_API.G_FALSE

Line 195: -- Default = FND_API.G_FALSE

191: -- Pre-reqs : FND_API, FND_MESSAGE, PSB_WS_ACCT1
192: -- Parameters :
193: -- IN : p_api_version IN NUMBER Required
194: -- p_init_msg_list IN VARCHAR2 Optional
195: -- Default = FND_API.G_FALSE
196: -- p_commit IN VARCHAR2 Optional
197: -- Default = FND_API.G_FALSE
198: -- p_validation_level IN NUMBER Optional
199: -- Default = FND_API.G_VALID_LEVEL_NONE

Line 197: -- Default = FND_API.G_FALSE

193: -- IN : p_api_version IN NUMBER Required
194: -- p_init_msg_list IN VARCHAR2 Optional
195: -- Default = FND_API.G_FALSE
196: -- p_commit IN VARCHAR2 Optional
197: -- Default = FND_API.G_FALSE
198: -- p_validation_level IN NUMBER Optional
199: -- Default = FND_API.G_VALID_LEVEL_NONE
200: -- p_worksheet_id IN NUMBER Required
201: -- p_distribute_flag IN VARCHAR2 Optional

Line 199: -- Default = FND_API.G_VALID_LEVEL_NONE

195: -- Default = FND_API.G_FALSE
196: -- p_commit IN VARCHAR2 Optional
197: -- Default = FND_API.G_FALSE
198: -- p_validation_level IN NUMBER Optional
199: -- Default = FND_API.G_VALID_LEVEL_NONE
200: -- p_worksheet_id IN NUMBER Required
201: -- p_distribute_flag IN VARCHAR2 Optional
202: -- Default = FND_API.G_FALSE
203: -- p_account_line_id IN NUMBER Required

Line 202: -- Default = FND_API.G_FALSE

198: -- p_validation_level IN NUMBER Optional
199: -- Default = FND_API.G_VALID_LEVEL_NONE
200: -- p_worksheet_id IN NUMBER Required
201: -- p_distribute_flag IN VARCHAR2 Optional
202: -- Default = FND_API.G_FALSE
203: -- p_account_line_id IN NUMBER Required
204: -- p_check_stages IN VARCHAR2 Optional
205: -- Default = FND_API.G_TRUE
206: -- p_ytd_amount IN NUMBER Required

Line 205: -- Default = FND_API.G_TRUE

201: -- p_distribute_flag IN VARCHAR2 Optional
202: -- Default = FND_API.G_FALSE
203: -- p_account_line_id IN NUMBER Required
204: -- p_check_stages IN VARCHAR2 Optional
205: -- Default = FND_API.G_TRUE
206: -- p_ytd_amount IN NUMBER Required
207: -- p_annual_fte IN NUMBER Optional
208: -- Default = FND_API.G_MISS_NUM
209: -- p_period_amount IN TABLE Required

Line 208: -- Default = FND_API.G_MISS_NUM

204: -- p_check_stages IN VARCHAR2 Optional
205: -- Default = FND_API.G_TRUE
206: -- p_ytd_amount IN NUMBER Required
207: -- p_annual_fte IN NUMBER Optional
208: -- Default = FND_API.G_MISS_NUM
209: -- p_period_amount IN TABLE Required
210: -- p_budget_group_id IN NUMBER Optional
211: -- Default = FND_API.G_MISS_NUM
212: -- p_service_package_id IN NUMBER Optional

Line 211: -- Default = FND_API.G_MISS_NUM

207: -- p_annual_fte IN NUMBER Optional
208: -- Default = FND_API.G_MISS_NUM
209: -- p_period_amount IN TABLE Required
210: -- p_budget_group_id IN NUMBER Optional
211: -- Default = FND_API.G_MISS_NUM
212: -- p_service_package_id IN NUMBER Optional
213: -- Default = FND_API.G_MISS_NUM
214: -- p_current_stage_seq IN NUMBER Optional
215: -- Default = FND_API.G_MISS_NUM

Line 213: -- Default = FND_API.G_MISS_NUM

209: -- p_period_amount IN TABLE Required
210: -- p_budget_group_id IN NUMBER Optional
211: -- Default = FND_API.G_MISS_NUM
212: -- p_service_package_id IN NUMBER Optional
213: -- Default = FND_API.G_MISS_NUM
214: -- p_current_stage_seq IN NUMBER Optional
215: -- Default = FND_API.G_MISS_NUM
216: -- p_copy_of_account_line_id IN NUMBER Optional
217: -- Default = FND_API.G_MISS_NUM

Line 215: -- Default = FND_API.G_MISS_NUM

211: -- Default = FND_API.G_MISS_NUM
212: -- p_service_package_id IN NUMBER Optional
213: -- Default = FND_API.G_MISS_NUM
214: -- p_current_stage_seq IN NUMBER Optional
215: -- Default = FND_API.G_MISS_NUM
216: -- p_copy_of_account_line_id IN NUMBER Optional
217: -- Default = FND_API.G_MISS_NUM
218: -- .
219: -- OUT NOCOPY : p_return_status OUT NOCOPY VARCHAR2(1)

Line 217: -- Default = FND_API.G_MISS_NUM

213: -- Default = FND_API.G_MISS_NUM
214: -- p_current_stage_seq IN NUMBER Optional
215: -- Default = FND_API.G_MISS_NUM
216: -- p_copy_of_account_line_id IN NUMBER Optional
217: -- Default = FND_API.G_MISS_NUM
218: -- .
219: -- OUT NOCOPY : p_return_status OUT NOCOPY VARCHAR2(1)
220: -- p_msg_count OUT NOCOPY NUMBER
221: -- p_msg_data OUT NOCOPY VARCHAR2(2000)

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

229: --
230:
231: PROCEDURE Create_Account_Dist
232: ( p_api_version IN NUMBER,
233: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
234: p_commit IN VARCHAR2 := FND_API.G_FALSE,
235: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_NONE,
236: p_return_status OUT NOCOPY VARCHAR2,
237: p_msg_count OUT NOCOPY NUMBER,

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

230:
231: PROCEDURE Create_Account_Dist
232: ( p_api_version IN NUMBER,
233: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
234: p_commit IN VARCHAR2 := FND_API.G_FALSE,
235: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_NONE,
236: p_return_status OUT NOCOPY VARCHAR2,
237: p_msg_count OUT NOCOPY NUMBER,
238: p_msg_data OUT NOCOPY VARCHAR2,

Line 235: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_NONE,

231: PROCEDURE Create_Account_Dist
232: ( p_api_version IN NUMBER,
233: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
234: p_commit IN VARCHAR2 := FND_API.G_FALSE,
235: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_NONE,
236: p_return_status OUT NOCOPY VARCHAR2,
237: p_msg_count OUT NOCOPY NUMBER,
238: p_msg_data OUT NOCOPY VARCHAR2,
239: p_worksheet_id IN NUMBER,

Line 240: p_distribute_flag IN VARCHAR2 := FND_API.G_FALSE,

236: p_return_status OUT NOCOPY VARCHAR2,
237: p_msg_count OUT NOCOPY NUMBER,
238: p_msg_data OUT NOCOPY VARCHAR2,
239: p_worksheet_id IN NUMBER,
240: p_distribute_flag IN VARCHAR2 := FND_API.G_FALSE,
241: p_account_line_id IN NUMBER,
242: p_check_stages IN VARCHAR2 := FND_API.G_TRUE,
243: p_ytd_amount IN NUMBER,
244: p_annual_fte IN NUMBER := FND_API.G_MISS_NUM,

Line 242: p_check_stages IN VARCHAR2 := FND_API.G_TRUE,

238: p_msg_data OUT NOCOPY VARCHAR2,
239: p_worksheet_id IN NUMBER,
240: p_distribute_flag IN VARCHAR2 := FND_API.G_FALSE,
241: p_account_line_id IN NUMBER,
242: p_check_stages IN VARCHAR2 := FND_API.G_TRUE,
243: p_ytd_amount IN NUMBER,
244: p_annual_fte IN NUMBER := FND_API.G_MISS_NUM,
245: p_period_amount IN PSB_WS_ACCT1.g_prdamt_tbl_type,
246: p_budget_group_id IN NUMBER := FND_API.G_MISS_NUM,

Line 244: p_annual_fte IN NUMBER := FND_API.G_MISS_NUM,

240: p_distribute_flag IN VARCHAR2 := FND_API.G_FALSE,
241: p_account_line_id IN NUMBER,
242: p_check_stages IN VARCHAR2 := FND_API.G_TRUE,
243: p_ytd_amount IN NUMBER,
244: p_annual_fte IN NUMBER := FND_API.G_MISS_NUM,
245: p_period_amount IN PSB_WS_ACCT1.g_prdamt_tbl_type,
246: p_budget_group_id IN NUMBER := FND_API.G_MISS_NUM,
247: p_service_package_id IN NUMBER := FND_API.G_MISS_NUM,
248: p_current_stage_seq IN NUMBER := FND_API.G_MISS_NUM,

Line 246: p_budget_group_id IN NUMBER := FND_API.G_MISS_NUM,

242: p_check_stages IN VARCHAR2 := FND_API.G_TRUE,
243: p_ytd_amount IN NUMBER,
244: p_annual_fte IN NUMBER := FND_API.G_MISS_NUM,
245: p_period_amount IN PSB_WS_ACCT1.g_prdamt_tbl_type,
246: p_budget_group_id IN NUMBER := FND_API.G_MISS_NUM,
247: p_service_package_id IN NUMBER := FND_API.G_MISS_NUM,
248: p_current_stage_seq IN NUMBER := FND_API.G_MISS_NUM,
249: p_copy_of_account_line_id IN NUMBER := FND_API.G_MISS_NUM
250: );

Line 247: p_service_package_id IN NUMBER := FND_API.G_MISS_NUM,

243: p_ytd_amount IN NUMBER,
244: p_annual_fte IN NUMBER := FND_API.G_MISS_NUM,
245: p_period_amount IN PSB_WS_ACCT1.g_prdamt_tbl_type,
246: p_budget_group_id IN NUMBER := FND_API.G_MISS_NUM,
247: p_service_package_id IN NUMBER := FND_API.G_MISS_NUM,
248: p_current_stage_seq IN NUMBER := FND_API.G_MISS_NUM,
249: p_copy_of_account_line_id IN NUMBER := FND_API.G_MISS_NUM
250: );
251:

Line 248: p_current_stage_seq IN NUMBER := FND_API.G_MISS_NUM,

244: p_annual_fte IN NUMBER := FND_API.G_MISS_NUM,
245: p_period_amount IN PSB_WS_ACCT1.g_prdamt_tbl_type,
246: p_budget_group_id IN NUMBER := FND_API.G_MISS_NUM,
247: p_service_package_id IN NUMBER := FND_API.G_MISS_NUM,
248: p_current_stage_seq IN NUMBER := FND_API.G_MISS_NUM,
249: p_copy_of_account_line_id IN NUMBER := FND_API.G_MISS_NUM
250: );
251:
252: /* ----------------------------------------------------------------------- */

Line 249: p_copy_of_account_line_id IN NUMBER := FND_API.G_MISS_NUM

245: p_period_amount IN PSB_WS_ACCT1.g_prdamt_tbl_type,
246: p_budget_group_id IN NUMBER := FND_API.G_MISS_NUM,
247: p_service_package_id IN NUMBER := FND_API.G_MISS_NUM,
248: p_current_stage_seq IN NUMBER := FND_API.G_MISS_NUM,
249: p_copy_of_account_line_id IN NUMBER := FND_API.G_MISS_NUM
250: );
251:
252: /* ----------------------------------------------------------------------- */
253:

Line 256: -- Pre-reqs : FND_API, FND_MESSAGE, PSB_WS_ACCT2

252: /* ----------------------------------------------------------------------- */
253:
254: -- API name : Revise_Account_Projections
255: -- Type : Private
256: -- Pre-reqs : FND_API, FND_MESSAGE, PSB_WS_ACCT2
257: -- Parameters :
258: -- IN : p_api_version IN NUMBER Required
259: -- p_init_msg_list IN VARCHAR2 Optional
260: -- Default = FND_API.G_FALSE

Line 260: -- Default = FND_API.G_FALSE

256: -- Pre-reqs : FND_API, FND_MESSAGE, PSB_WS_ACCT2
257: -- Parameters :
258: -- IN : p_api_version IN NUMBER Required
259: -- p_init_msg_list IN VARCHAR2 Optional
260: -- Default = FND_API.G_FALSE
261: -- p_commit IN VARCHAR2 Optional
262: -- Default = FND_API.G_FALSE
263: -- p_validation_level IN NUMBER Optional
264: -- Default = FND_API.G_VALID_LEVEL_NONE

Line 262: -- Default = FND_API.G_FALSE

258: -- IN : p_api_version IN NUMBER Required
259: -- p_init_msg_list IN VARCHAR2 Optional
260: -- Default = FND_API.G_FALSE
261: -- p_commit IN VARCHAR2 Optional
262: -- Default = FND_API.G_FALSE
263: -- p_validation_level IN NUMBER Optional
264: -- Default = FND_API.G_VALID_LEVEL_NONE
265: -- p_worksheet_id IN NUMBER Required
266: -- p_parameter_id IN NUMBER Required

Line 264: -- Default = FND_API.G_VALID_LEVEL_NONE

260: -- Default = FND_API.G_FALSE
261: -- p_commit IN VARCHAR2 Optional
262: -- Default = FND_API.G_FALSE
263: -- p_validation_level IN NUMBER Optional
264: -- Default = FND_API.G_VALID_LEVEL_NONE
265: -- p_worksheet_id IN NUMBER Required
266: -- p_parameter_id IN NUMBER Required
267: -- .
268: -- OUT NOCOPY : p_return_status OUT NOCOPY VARCHAR2(1)

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

275: --
276:
277: PROCEDURE Revise_Account_Projections
278: ( p_api_version IN NUMBER,
279: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
280: p_commit IN VARCHAR2 := FND_API.G_FALSE,
281: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_NONE,
282: p_return_status OUT NOCOPY VARCHAR2,
283: p_msg_count OUT NOCOPY NUMBER,

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

276:
277: PROCEDURE Revise_Account_Projections
278: ( p_api_version IN NUMBER,
279: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
280: p_commit IN VARCHAR2 := FND_API.G_FALSE,
281: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_NONE,
282: p_return_status OUT NOCOPY VARCHAR2,
283: p_msg_count OUT NOCOPY NUMBER,
284: p_msg_data OUT NOCOPY VARCHAR2,

Line 281: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_NONE,

277: PROCEDURE Revise_Account_Projections
278: ( p_api_version IN NUMBER,
279: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
280: p_commit IN VARCHAR2 := FND_API.G_FALSE,
281: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_NONE,
282: p_return_status OUT NOCOPY VARCHAR2,
283: p_msg_count OUT NOCOPY NUMBER,
284: p_msg_data OUT NOCOPY VARCHAR2,
285: p_worksheet_id IN NUMBER,

Line 293: -- Pre-reqs : FND_API, FND_MESSAGE, PSB_WS_ACCT2

289: /* ----------------------------------------------------------------------- */
290:
291: -- API name : Update_GL_Balances
292: -- Type : Private
293: -- Pre-reqs : FND_API, FND_MESSAGE, PSB_WS_ACCT2
294: -- Parameters :
295: -- IN : p_api_version IN NUMBER Required
296: -- p_init_msg_list IN VARCHAR2 Optional
297: -- Default = FND_API.G_FALSE

Line 297: -- Default = FND_API.G_FALSE

293: -- Pre-reqs : FND_API, FND_MESSAGE, PSB_WS_ACCT2
294: -- Parameters :
295: -- IN : p_api_version IN NUMBER Required
296: -- p_init_msg_list IN VARCHAR2 Optional
297: -- Default = FND_API.G_FALSE
298: -- p_commit IN VARCHAR2 Optional
299: -- Default = FND_API.G_FALSE
300: -- p_validation_level IN NUMBER Optional
301: -- Default = FND_API.G_VALID_LEVEL_NONE

Line 299: -- Default = FND_API.G_FALSE

295: -- IN : p_api_version IN NUMBER Required
296: -- p_init_msg_list IN VARCHAR2 Optional
297: -- Default = FND_API.G_FALSE
298: -- p_commit IN VARCHAR2 Optional
299: -- Default = FND_API.G_FALSE
300: -- p_validation_level IN NUMBER Optional
301: -- Default = FND_API.G_VALID_LEVEL_NONE
302: -- p_worksheet_id IN NUMBER Required
303: -- .

Line 301: -- Default = FND_API.G_VALID_LEVEL_NONE

297: -- Default = FND_API.G_FALSE
298: -- p_commit IN VARCHAR2 Optional
299: -- Default = FND_API.G_FALSE
300: -- p_validation_level IN NUMBER Optional
301: -- Default = FND_API.G_VALID_LEVEL_NONE
302: -- p_worksheet_id IN NUMBER Required
303: -- .
304: -- OUT NOCOPY : p_return_status OUT NOCOPY VARCHAR2(1)
305: -- p_msg_count OUT NOCOPY NUMBER

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

313: --
314:
315: PROCEDURE Update_GL_Balances
316: ( p_api_version IN NUMBER,
317: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
318: p_commit IN VARCHAR2 := FND_API.G_FALSE,
319: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_NONE,
320: p_return_status OUT NOCOPY VARCHAR2,
321: p_msg_count OUT NOCOPY NUMBER,

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

314:
315: PROCEDURE Update_GL_Balances
316: ( p_api_version IN NUMBER,
317: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
318: p_commit IN VARCHAR2 := FND_API.G_FALSE,
319: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_NONE,
320: p_return_status OUT NOCOPY VARCHAR2,
321: p_msg_count OUT NOCOPY NUMBER,
322: p_msg_data OUT NOCOPY VARCHAR2,

Line 319: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_NONE,

315: PROCEDURE Update_GL_Balances
316: ( p_api_version IN NUMBER,
317: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
318: p_commit IN VARCHAR2 := FND_API.G_FALSE,
319: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_NONE,
320: p_return_status OUT NOCOPY VARCHAR2,
321: p_msg_count OUT NOCOPY NUMBER,
322: p_msg_data OUT NOCOPY VARCHAR2,
323: p_worksheet_id IN NUMBER

Line 330: -- Pre-reqs : FND_API, FND_MESSAGE, PSB_WS_ACCT2

326: /* ----------------------------------------------------------------------- */
327:
328: -- API name : Create_Rollup_Totals
329: -- Type : Private
330: -- Pre-reqs : FND_API, FND_MESSAGE, PSB_WS_ACCT2
331: -- Parameters :
332: -- IN : p_api_version IN NUMBER Required
333: -- p_init_msg_list IN VARCHAR2 Optional
334: -- Default = FND_API.G_FALSE

Line 334: -- Default = FND_API.G_FALSE

330: -- Pre-reqs : FND_API, FND_MESSAGE, PSB_WS_ACCT2
331: -- Parameters :
332: -- IN : p_api_version IN NUMBER Required
333: -- p_init_msg_list IN VARCHAR2 Optional
334: -- Default = FND_API.G_FALSE
335: -- p_commit IN VARCHAR2 Optional
336: -- Default = FND_API.G_FALSE
337: -- p_validation_level IN NUMBER Optional
338: -- Default = FND_API.G_VALID_LEVEL_NONE

Line 336: -- Default = FND_API.G_FALSE

332: -- IN : p_api_version IN NUMBER Required
333: -- p_init_msg_list IN VARCHAR2 Optional
334: -- Default = FND_API.G_FALSE
335: -- p_commit IN VARCHAR2 Optional
336: -- Default = FND_API.G_FALSE
337: -- p_validation_level IN NUMBER Optional
338: -- Default = FND_API.G_VALID_LEVEL_NONE
339: -- p_worksheet_id IN NUMBER Required
340: -- p_rounding_factor IN NUMBER Optional

Line 338: -- Default = FND_API.G_VALID_LEVEL_NONE

334: -- Default = FND_API.G_FALSE
335: -- p_commit IN VARCHAR2 Optional
336: -- Default = FND_API.G_FALSE
337: -- p_validation_level IN NUMBER Optional
338: -- Default = FND_API.G_VALID_LEVEL_NONE
339: -- p_worksheet_id IN NUMBER Required
340: -- p_rounding_factor IN NUMBER Optional
341: -- Default = FND_API.G_MISS_NUM
342: -- p_stage_set_id IN NUMBER Optional

Line 341: -- Default = FND_API.G_MISS_NUM

337: -- p_validation_level IN NUMBER Optional
338: -- Default = FND_API.G_VALID_LEVEL_NONE
339: -- p_worksheet_id IN NUMBER Required
340: -- p_rounding_factor IN NUMBER Optional
341: -- Default = FND_API.G_MISS_NUM
342: -- p_stage_set_id IN NUMBER Optional
343: -- Default = FND_API.G_MISS_NUM
344: -- p_current_stage_seq IN NUMBER Optional
345: -- Default = FND_API.G_MISS_NUM

Line 343: -- Default = FND_API.G_MISS_NUM

339: -- p_worksheet_id IN NUMBER Required
340: -- p_rounding_factor IN NUMBER Optional
341: -- Default = FND_API.G_MISS_NUM
342: -- p_stage_set_id IN NUMBER Optional
343: -- Default = FND_API.G_MISS_NUM
344: -- p_current_stage_seq IN NUMBER Optional
345: -- Default = FND_API.G_MISS_NUM
346: -- p_set_of_books_id IN NUMBER Optional
347: -- Default = FND_API.G_MISS_NUM

Line 345: -- Default = FND_API.G_MISS_NUM

341: -- Default = FND_API.G_MISS_NUM
342: -- p_stage_set_id IN NUMBER Optional
343: -- Default = FND_API.G_MISS_NUM
344: -- p_current_stage_seq IN NUMBER Optional
345: -- Default = FND_API.G_MISS_NUM
346: -- p_set_of_books_id IN NUMBER Optional
347: -- Default = FND_API.G_MISS_NUM
348: -- p_flex_code IN NUMBER Optional
349: -- Default = FND_API.G_MISS_NUM

Line 347: -- Default = FND_API.G_MISS_NUM

343: -- Default = FND_API.G_MISS_NUM
344: -- p_current_stage_seq IN NUMBER Optional
345: -- Default = FND_API.G_MISS_NUM
346: -- p_set_of_books_id IN NUMBER Optional
347: -- Default = FND_API.G_MISS_NUM
348: -- p_flex_code IN NUMBER Optional
349: -- Default = FND_API.G_MISS_NUM
350: -- p_budget_group_id IN NUMBER Optional
351: -- Default = FND_API.G_MISS_NUM

Line 349: -- Default = FND_API.G_MISS_NUM

345: -- Default = FND_API.G_MISS_NUM
346: -- p_set_of_books_id IN NUMBER Optional
347: -- Default = FND_API.G_MISS_NUM
348: -- p_flex_code IN NUMBER Optional
349: -- Default = FND_API.G_MISS_NUM
350: -- p_budget_group_id IN NUMBER Optional
351: -- Default = FND_API.G_MISS_NUM
352: -- p_budget_calendar_id IN NUMBER Optional
353: -- Default = FND_API.G_MISS_NUM

Line 351: -- Default = FND_API.G_MISS_NUM

347: -- Default = FND_API.G_MISS_NUM
348: -- p_flex_code IN NUMBER Optional
349: -- Default = FND_API.G_MISS_NUM
350: -- p_budget_group_id IN NUMBER Optional
351: -- Default = FND_API.G_MISS_NUM
352: -- p_budget_calendar_id IN NUMBER Optional
353: -- Default = FND_API.G_MISS_NUM
354: -- .
355: -- OUT NOCOPY : p_return_status OUT NOCOPY VARCHAR2(1)

Line 353: -- Default = FND_API.G_MISS_NUM

349: -- Default = FND_API.G_MISS_NUM
350: -- p_budget_group_id IN NUMBER Optional
351: -- Default = FND_API.G_MISS_NUM
352: -- p_budget_calendar_id IN NUMBER Optional
353: -- Default = FND_API.G_MISS_NUM
354: -- .
355: -- OUT NOCOPY : p_return_status OUT NOCOPY VARCHAR2(1)
356: -- p_msg_count OUT NOCOPY NUMBER
357: -- p_msg_data OUT NOCOPY VARCHAR2(2000)

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

364: --
365:
366: PROCEDURE Create_Rollup_Totals
367: ( p_api_version IN NUMBER,
368: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
369: p_commit IN VARCHAR2 := FND_API.G_FALSE,
370: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_NONE,
371: p_return_status OUT NOCOPY VARCHAR2,
372: p_msg_count OUT NOCOPY NUMBER,

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

365:
366: PROCEDURE Create_Rollup_Totals
367: ( p_api_version IN NUMBER,
368: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
369: p_commit IN VARCHAR2 := FND_API.G_FALSE,
370: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_NONE,
371: p_return_status OUT NOCOPY VARCHAR2,
372: p_msg_count OUT NOCOPY NUMBER,
373: p_msg_data OUT NOCOPY VARCHAR2,

Line 370: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_NONE,

366: PROCEDURE Create_Rollup_Totals
367: ( p_api_version IN NUMBER,
368: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
369: p_commit IN VARCHAR2 := FND_API.G_FALSE,
370: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_NONE,
371: p_return_status OUT NOCOPY VARCHAR2,
372: p_msg_count OUT NOCOPY NUMBER,
373: p_msg_data OUT NOCOPY VARCHAR2,
374: p_worksheet_id IN NUMBER,

Line 375: p_rounding_factor IN NUMBER := FND_API.G_MISS_NUM,

371: p_return_status OUT NOCOPY VARCHAR2,
372: p_msg_count OUT NOCOPY NUMBER,
373: p_msg_data OUT NOCOPY VARCHAR2,
374: p_worksheet_id IN NUMBER,
375: p_rounding_factor IN NUMBER := FND_API.G_MISS_NUM,
376: p_stage_set_id IN NUMBER := FND_API.G_MISS_NUM,
377: p_current_stage_seq IN NUMBER := FND_API.G_MISS_NUM,
378: p_set_of_books_id IN NUMBER := FND_API.G_MISS_NUM,
379: p_flex_code IN NUMBER := FND_API.G_MISS_NUM,

Line 376: p_stage_set_id IN NUMBER := FND_API.G_MISS_NUM,

372: p_msg_count OUT NOCOPY NUMBER,
373: p_msg_data OUT NOCOPY VARCHAR2,
374: p_worksheet_id IN NUMBER,
375: p_rounding_factor IN NUMBER := FND_API.G_MISS_NUM,
376: p_stage_set_id IN NUMBER := FND_API.G_MISS_NUM,
377: p_current_stage_seq IN NUMBER := FND_API.G_MISS_NUM,
378: p_set_of_books_id IN NUMBER := FND_API.G_MISS_NUM,
379: p_flex_code IN NUMBER := FND_API.G_MISS_NUM,
380: p_budget_group_id IN NUMBER := FND_API.G_MISS_NUM,

Line 377: p_current_stage_seq IN NUMBER := FND_API.G_MISS_NUM,

373: p_msg_data OUT NOCOPY VARCHAR2,
374: p_worksheet_id IN NUMBER,
375: p_rounding_factor IN NUMBER := FND_API.G_MISS_NUM,
376: p_stage_set_id IN NUMBER := FND_API.G_MISS_NUM,
377: p_current_stage_seq IN NUMBER := FND_API.G_MISS_NUM,
378: p_set_of_books_id IN NUMBER := FND_API.G_MISS_NUM,
379: p_flex_code IN NUMBER := FND_API.G_MISS_NUM,
380: p_budget_group_id IN NUMBER := FND_API.G_MISS_NUM,
381: p_budget_calendar_id IN NUMBER := FND_API.G_MISS_NUM

Line 378: p_set_of_books_id IN NUMBER := FND_API.G_MISS_NUM,

374: p_worksheet_id IN NUMBER,
375: p_rounding_factor IN NUMBER := FND_API.G_MISS_NUM,
376: p_stage_set_id IN NUMBER := FND_API.G_MISS_NUM,
377: p_current_stage_seq IN NUMBER := FND_API.G_MISS_NUM,
378: p_set_of_books_id IN NUMBER := FND_API.G_MISS_NUM,
379: p_flex_code IN NUMBER := FND_API.G_MISS_NUM,
380: p_budget_group_id IN NUMBER := FND_API.G_MISS_NUM,
381: p_budget_calendar_id IN NUMBER := FND_API.G_MISS_NUM
382: );

Line 379: p_flex_code IN NUMBER := FND_API.G_MISS_NUM,

375: p_rounding_factor IN NUMBER := FND_API.G_MISS_NUM,
376: p_stage_set_id IN NUMBER := FND_API.G_MISS_NUM,
377: p_current_stage_seq IN NUMBER := FND_API.G_MISS_NUM,
378: p_set_of_books_id IN NUMBER := FND_API.G_MISS_NUM,
379: p_flex_code IN NUMBER := FND_API.G_MISS_NUM,
380: p_budget_group_id IN NUMBER := FND_API.G_MISS_NUM,
381: p_budget_calendar_id IN NUMBER := FND_API.G_MISS_NUM
382: );
383:

Line 380: p_budget_group_id IN NUMBER := FND_API.G_MISS_NUM,

376: p_stage_set_id IN NUMBER := FND_API.G_MISS_NUM,
377: p_current_stage_seq IN NUMBER := FND_API.G_MISS_NUM,
378: p_set_of_books_id IN NUMBER := FND_API.G_MISS_NUM,
379: p_flex_code IN NUMBER := FND_API.G_MISS_NUM,
380: p_budget_group_id IN NUMBER := FND_API.G_MISS_NUM,
381: p_budget_calendar_id IN NUMBER := FND_API.G_MISS_NUM
382: );
383:
384: /* ----------------------------------------------------------------------- */

Line 381: p_budget_calendar_id IN NUMBER := FND_API.G_MISS_NUM

377: p_current_stage_seq IN NUMBER := FND_API.G_MISS_NUM,
378: p_set_of_books_id IN NUMBER := FND_API.G_MISS_NUM,
379: p_flex_code IN NUMBER := FND_API.G_MISS_NUM,
380: p_budget_group_id IN NUMBER := FND_API.G_MISS_NUM,
381: p_budget_calendar_id IN NUMBER := FND_API.G_MISS_NUM
382: );
383:
384: /* ----------------------------------------------------------------------- */
385:

Line 390: p_worksheet_id IN NUMBER := FND_API.G_MISS_NUM

386: PROCEDURE Update_GL_Balances_CP
387: (
388: errbuf OUT NOCOPY VARCHAR2,
389: retcode OUT NOCOPY VARCHAR2,
390: p_worksheet_id IN NUMBER := FND_API.G_MISS_NUM
391: );
392:
393: PROCEDURE Create_Rollup_Totals_CP
394: (

Line 398: p_worksheet_id IN NUMBER := FND_API.G_MISS_NUM

394: (
395: errbuf OUT NOCOPY VARCHAR2,
396: retcode OUT NOCOPY VARCHAR2,
397: p_create_summary_totals IN VARCHAR2,
398: p_worksheet_id IN NUMBER := FND_API.G_MISS_NUM
399: );
400:
401: PROCEDURE Revise_Account_Projections_CP
402: (