17: p_To_currency in varchar2 default null,
18: p_effective_date in date default null) is
19:
20: begin
21: g_concurrent_id:=FND_GLOBAL.conc_program_id;
22: g_request_id:=FND_GLOBAL.conc_request_id;
23: g_user_id := fnd_global.user_id;
24: g_login_id := fnd_global.login_id;
25:
18: p_effective_date in date default null) is
19:
20: begin
21: g_concurrent_id:=FND_GLOBAL.conc_program_id;
22: g_request_id:=FND_GLOBAL.conc_request_id;
23: g_user_id := fnd_global.user_id;
24: g_login_id := fnd_global.login_id;
25:
26: insert into bis_refresh_log(
19:
20: begin
21: g_concurrent_id:=FND_GLOBAL.conc_program_id;
22: g_request_id:=FND_GLOBAL.conc_request_id;
23: g_user_id := fnd_global.user_id;
24: g_login_id := fnd_global.login_id;
25:
26: insert into bis_refresh_log(
27: Request_id,
20: begin
21: g_concurrent_id:=FND_GLOBAL.conc_program_id;
22: g_request_id:=FND_GLOBAL.conc_request_id;
23: g_user_id := fnd_global.user_id;
24: g_login_id := fnd_global.login_id;
25:
26: insert into bis_refresh_log(
27: Request_id,
28: Concurrent_id,
85: p_To_UOM in varchar2 default null,
86: p_Inventory_items in varchar2 default null) is
87:
88: begin
89: g_concurrent_id:=FND_GLOBAL.conc_program_id;
90: g_request_id:=FND_GLOBAL.conc_request_id;
91: g_user_id := fnd_global.user_id;
92: g_login_id := fnd_global.login_id;
93:
86: p_Inventory_items in varchar2 default null) is
87:
88: begin
89: g_concurrent_id:=FND_GLOBAL.conc_program_id;
90: g_request_id:=FND_GLOBAL.conc_request_id;
91: g_user_id := fnd_global.user_id;
92: g_login_id := fnd_global.login_id;
93:
94: insert into bis_refresh_log(
87:
88: begin
89: g_concurrent_id:=FND_GLOBAL.conc_program_id;
90: g_request_id:=FND_GLOBAL.conc_request_id;
91: g_user_id := fnd_global.user_id;
92: g_login_id := fnd_global.login_id;
93:
94: insert into bis_refresh_log(
95: Request_id,
88: begin
89: g_concurrent_id:=FND_GLOBAL.conc_program_id;
90: g_request_id:=FND_GLOBAL.conc_request_id;
91: g_user_id := fnd_global.user_id;
92: g_login_id := fnd_global.login_id;
93:
94: insert into bis_refresh_log(
95: Request_id,
96: Concurrent_id,
154: p_period_name in varchar2 default null,
155: p_calendar in varchar2 default null) is
156:
157: begin
158: g_concurrent_id:=FND_GLOBAL.conc_program_id;
159: g_request_id:=FND_GLOBAL.conc_request_id;
160: g_user_id := fnd_global.user_id;
161: g_login_id := fnd_global.login_id;
162:
155: p_calendar in varchar2 default null) is
156:
157: begin
158: g_concurrent_id:=FND_GLOBAL.conc_program_id;
159: g_request_id:=FND_GLOBAL.conc_request_id;
160: g_user_id := fnd_global.user_id;
161: g_login_id := fnd_global.login_id;
162:
163: insert into bis_refresh_log(
156:
157: begin
158: g_concurrent_id:=FND_GLOBAL.conc_program_id;
159: g_request_id:=FND_GLOBAL.conc_request_id;
160: g_user_id := fnd_global.user_id;
161: g_login_id := fnd_global.login_id;
162:
163: insert into bis_refresh_log(
164: Request_id,
157: begin
158: g_concurrent_id:=FND_GLOBAL.conc_program_id;
159: g_request_id:=FND_GLOBAL.conc_request_id;
160: g_user_id := fnd_global.user_id;
161: g_login_id := fnd_global.login_id;
162:
163: insert into bis_refresh_log(
164: Request_id,
165: Concurrent_id,
219: p_EXCEPTION_MESSAGE in VARCHAR2 default null,
220: p_CORRECTIVE_ACTION_FF in varchar2 default null) is
221:
222: begin
223: g_concurrent_id:=FND_GLOBAL.conc_program_id;
224: g_request_id:=FND_GLOBAL.conc_request_id;
225: g_user_id := fnd_global.user_id;
226: g_login_id := fnd_global.login_id;
227:
220: p_CORRECTIVE_ACTION_FF in varchar2 default null) is
221:
222: begin
223: g_concurrent_id:=FND_GLOBAL.conc_program_id;
224: g_request_id:=FND_GLOBAL.conc_request_id;
225: g_user_id := fnd_global.user_id;
226: g_login_id := fnd_global.login_id;
227:
228: insert into bis_refresh_log(
221:
222: begin
223: g_concurrent_id:=FND_GLOBAL.conc_program_id;
224: g_request_id:=FND_GLOBAL.conc_request_id;
225: g_user_id := fnd_global.user_id;
226: g_login_id := fnd_global.login_id;
227:
228: insert into bis_refresh_log(
229: Request_id,
222: begin
223: g_concurrent_id:=FND_GLOBAL.conc_program_id;
224: g_request_id:=FND_GLOBAL.conc_request_id;
225: g_user_id := fnd_global.user_id;
226: g_login_id := fnd_global.login_id;
227:
228: insert into bis_refresh_log(
229: Request_id,
230: Concurrent_id,
291: p_Contract_id in number default null,
292: p_Contract_status in varchar2 default null) is
293:
294: begin
295: g_concurrent_id:=FND_GLOBAL.conc_program_id;
296: g_request_id:=FND_GLOBAL.conc_request_id;
297: g_user_id := fnd_global.user_id;
298: g_login_id := fnd_global.login_id;
299:
292: p_Contract_status in varchar2 default null) is
293:
294: begin
295: g_concurrent_id:=FND_GLOBAL.conc_program_id;
296: g_request_id:=FND_GLOBAL.conc_request_id;
297: g_user_id := fnd_global.user_id;
298: g_login_id := fnd_global.login_id;
299:
300: insert into bis_refresh_log(
293:
294: begin
295: g_concurrent_id:=FND_GLOBAL.conc_program_id;
296: g_request_id:=FND_GLOBAL.conc_request_id;
297: g_user_id := fnd_global.user_id;
298: g_login_id := fnd_global.login_id;
299:
300: insert into bis_refresh_log(
301: Request_id,
294: begin
295: g_concurrent_id:=FND_GLOBAL.conc_program_id;
296: g_request_id:=FND_GLOBAL.conc_request_id;
297: g_user_id := fnd_global.user_id;
298: g_login_id := fnd_global.login_id;
299:
300: insert into bis_refresh_log(
301: Request_id,
302: Concurrent_id,