APPS.MSD_SRP_PROCESS_STREAM_DATA dependencies on FND_GLOBAL

Line 15: IF fnd_global.conc_request_id > 0 THEN

11:
12: PROCEDURE log_message(p_error_text IN VARCHAR2) IS
13: BEGIN
14:
15: IF fnd_global.conc_request_id > 0 THEN
16: fnd_file.PUT_LINE(fnd_file.LOG, p_error_text);
17: END IF;
18:
19: EXCEPTION

Line 271: VALUES(5555555, -23453, 'SRP DUMMY PLAN', trunc(sysdate), fnd_global.user_id, trunc(sysdate), fnd_global.user_id, -23453, 'N');

267: IF l_demand_plan_id IS NULL THEN
268:
269: INSERT
270: INTO msd_demand_plans(demand_plan_id, organization_id, demand_plan_name, last_update_date, last_updated_by, creation_date, created_by, sr_instance_id, use_org_specific_bom_flag)
271: VALUES(5555555, -23453, 'SRP DUMMY PLAN', trunc(sysdate), fnd_global.user_id, trunc(sysdate), fnd_global.user_id, -23453, 'N');
272:
273: END IF;
274:
275: IF l_scenario_id IS NOT NULL THEN

Line 300: || 'trunc(sysdate),fnd_global.user_id,trunc(sysdate),fnd_global.user_id)';

296: CLOSE get_scn_name;
297: lv_sql_stmt := 'INSERT INTO MSD_DP_SCENARIOS(demand_plan_id,scenario_id,scenario_name, '
298: || 'last_update_date,last_updated_by,creation_date,created_by)'
299: || 'values(5555555,MSD_DP_SCENARIOS_S.nextval,' || bind_var
300: || 'trunc(sysdate),fnd_global.user_id,trunc(sysdate),fnd_global.user_id)';
301: EXECUTE IMMEDIATE lv_sql_stmt USING l_scenario_name;
302:
303: INSERT INTO MSD_DP_SCENARIO_OUTPUT_LEVELS(demand_plan_id,scenario_id,level_id,last_update_date,last_updated_by,creation_date,created_by)
304: values(5555555,MSD_DP_SCENARIOS_S.CURRVAL,1,trunc(sysdate),fnd_global.user_id,trunc(sysdate),fnd_global.user_id);

Line 304: values(5555555,MSD_DP_SCENARIOS_S.CURRVAL,1,trunc(sysdate),fnd_global.user_id,trunc(sysdate),fnd_global.user_id);

300: || 'trunc(sysdate),fnd_global.user_id,trunc(sysdate),fnd_global.user_id)';
301: EXECUTE IMMEDIATE lv_sql_stmt USING l_scenario_name;
302:
303: INSERT INTO MSD_DP_SCENARIO_OUTPUT_LEVELS(demand_plan_id,scenario_id,level_id,last_update_date,last_updated_by,creation_date,created_by)
304: values(5555555,MSD_DP_SCENARIOS_S.CURRVAL,1,trunc(sysdate),fnd_global.user_id,trunc(sysdate),fnd_global.user_id);
305:
306: OPEN get_scn_id;
307: FETCH get_scn_id
308: INTO l_scenario_id;