DBA Data[Home] [Help]

APPS.MSC_WS_OTM_BPEL dependencies on FND_GLOBAL

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

166:
167:
168: begin
169: srInstanceId := fnd_profile.value('MSC_EBS_INSTANCE_FOR_OTM');
170: userId := fnd_global.User_id();
171:
172:
173: OPEN lookUpSupplies(lineLocationId, srInstanceId);
174: LOOP

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

531: AND tu.TRANS_UPDATE_ID = transId;
532:
533: end if;
534:
535: --userId := fnd_global.USER_ID();
536: userId := g_UserId;
537:
538: if v_old_dock_date < newArrivalDate then
539: excType := 119; -- late replenishment

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

719: end if;*/
720:
721: --dbms_output.put_line('passed 2');
722:
723: --userId := fnd_global.USER_ID();
724: userId := g_UserId;
725:
726: if v_old_dock_date < newArrivalDate then
727: excType := 119; -- late replenishment

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

935: if ( GetLeadTime(invItemId, orgId, planId, SrInstanceId, newArrivalDate, v_new_firm_Date) = false) then
936: v_new_firm_Date := newArrivalDate;
937: end if;
938:
939: --userId := fnd_global.User_id();
940: userId := g_UserId;
941: --dbms_output.put_line('got leadTime' || v_new_firm_date);
942:
943: UPDATE msc_transportation_updates

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

1037: AND d.PLAN_ID = planId
1038: AND d.ORIGINATION_TYPE = 30
1039: AND tu.Trans_update_id = transId;
1040:
1041: --userId := fnd_global.User_id();
1042: userId := g_UserId;
1043:
1044:
1045: --Update all ISOs

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

1214: i := i+1;
1215: END LOOP;
1216: CLOSE GetISOs;
1217:
1218: --userId := fnd_global.User_id();
1219: userId := g_UserId;
1220:
1221:
1222: --Update all ISOs

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

1364:
1365: -- this procedure adds PO s of type order_type =1 only !
1366: SAVEPOINT sv_addLineId;
1367: AppsInit;
1368: --userId := fnd_global.User_id();
1369: userId := g_UserId;
1370:
1371: indexI := INSTR(poIdString,'SCHED');
1372: poId := to_NUMBER( substr(poIdString, 6, indexI-7) );

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

1431: srInstanceId NUMBER :=0;
1432: begin
1433:
1434: AppsInit;
1435: --userId := fnd_global.User_id();
1436: userId := g_UserId;
1437:
1438: -- if not internal sales order, then just exit
1439: isOrg := substr(isInternalSO, 1, 3);

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

1518: return;
1519: end if;
1520:
1521: AppsInit;
1522: userId := fnd_global.USER_ID();
1523: respId := fnd_global.RESP_ID();
1524:
1525: if ( userId =0 or respId =0) then
1526: status := 'ERROR_USER_RESP_PROFILES_NOT_SET';

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

1519: end if;
1520:
1521: AppsInit;
1522: userId := fnd_global.USER_ID();
1523: respId := fnd_global.RESP_ID();
1524:
1525: if ( userId =0 or respId =0) then
1526: status := 'ERROR_USER_RESP_PROFILES_NOT_SET';
1527: end if;

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

1622: if ( respId = 0) then
1623: respId := fnd_profile.value('MSC: OTM RESPONSIBILITY');
1624: end if;
1625: SELECT application_id INTO appId FROM fnd_responsibility WHERE responsibility_id = respId;
1626: fnd_global.apps_initialize(userId, respId, appId);
1627:
1628: g_UserId := userId;
1629:
1630: --dbms_output.put_line(userId || ' ' || respId || ' ' || appId);