APPS.MSC_WS_OTM_BPEL dependencies on FND_GLOBAL

Line 161: userId := fnd_global.User_id();

157:
158:
159: begin
160: srInstanceId := fnd_profile.value('MSC_EBS_INSTANCE_FOR_OTM');
161: userId := fnd_global.User_id();
162:
163:
164: SELECT distinct order_number, purch_line_num, order_type
165: INTO v_order_Number, v_line_Number, v_order_type

Line 510: --userId := fnd_global.USER_ID();

506: AND tu.TRANS_UPDATE_ID = transId;
507:
508: end if;
509:
510: --userId := fnd_global.USER_ID();
511: userId := g_UserId;
512:
513: if v_old_dock_date < newArrivalDate then
514: excType := 119; -- late replenishment

Line 698: --userId := fnd_global.USER_ID();

694: end if;*/
695:
696: --dbms_output.put_line('passed 2');
697:
698: --userId := fnd_global.USER_ID();
699: userId := g_UserId;
700:
701: if v_old_dock_date < newArrivalDate then
702: excType := 119; -- late replenishment

Line 914: --userId := fnd_global.User_id();

910: if ( GetLeadTime(invItemId, orgId, planId, SrInstanceId, newArrivalDate, v_new_firm_Date) = false) then
911: v_new_firm_Date := newArrivalDate;
912: end if;
913:
914: --userId := fnd_global.User_id();
915: userId := g_UserId;
916: --dbms_output.put_line('got leadTime' || v_new_firm_date);
917:
918: UPDATE msc_transportation_updates

Line 1016: --userId := fnd_global.User_id();

1012: AND d.PLAN_ID = planId
1013: AND d.ORIGINATION_TYPE = 30
1014: AND tu.Trans_update_id = transId;
1015:
1016: --userId := fnd_global.User_id();
1017: userId := g_UserId;
1018:
1019:
1020: --Update all ISOs

Line 1193: --userId := fnd_global.User_id();

1189: i := i+1;
1190: END LOOP;
1191: CLOSE GetISOs;
1192:
1193: --userId := fnd_global.User_id();
1194: userId := g_UserId;
1195:
1196:
1197: --Update all ISOs

Line 1343: --userId := fnd_global.User_id();

1339:
1340: -- this procedure adds PO s of type order_type =1 only !
1341: SAVEPOINT sv_addLineId;
1342: AppsInit;
1343: --userId := fnd_global.User_id();
1344: userId := g_UserId;
1345:
1346: indexI := INSTR(poIdString,'SCHED');
1347: poId := to_NUMBER( substr(poIdString, 6, indexI-7) );

Line 1410: --userId := fnd_global.User_id();

1406: srInstanceId NUMBER :=0;
1407: begin
1408:
1409: AppsInit;
1410: --userId := fnd_global.User_id();
1411: userId := g_UserId;
1412:
1413: -- if not internal sales order, then just exit
1414: isOrg := substr(isInternalSO, 1, 3);

Line 1497: userId := fnd_global.USER_ID();

1493: return;
1494: end if;
1495:
1496: AppsInit;
1497: userId := fnd_global.USER_ID();
1498: respId := fnd_global.RESP_ID();
1499:
1500: if ( userId =0 or respId =0) then
1501: status := 'ERROR_USER_RESP_PROFILES_NOT_SET';

Line 1498: respId := fnd_global.RESP_ID();

1494: end if;
1495:
1496: AppsInit;
1497: userId := fnd_global.USER_ID();
1498: respId := fnd_global.RESP_ID();
1499:
1500: if ( userId =0 or respId =0) then
1501: status := 'ERROR_USER_RESP_PROFILES_NOT_SET';
1502: end if;

Line 1601: fnd_global.apps_initialize(userId, respId, appId);

1597: if ( respId = 0) then
1598: respId := fnd_profile.value('MSC: OTM RESPONSIBILITY');
1599: end if;
1600: SELECT application_id INTO appId FROM fnd_responsibility WHERE responsibility_id = respId;
1601: fnd_global.apps_initialize(userId, respId, appId);
1602:
1603: g_UserId := userId;
1604:
1605: --dbms_output.put_line(userId || ' ' || respId || ' ' || appId);