DBA Data[Home] [Help]

APPS.MSC_WS_OTM_BPEL dependencies on MSGTOKENVALUEPAIR

Line 1496: tokenValues MsgTokenValuePairList;

1492: status out nocopy varchar2) is
1493: userId NUMBER :=0;
1494: respId NUMBER :=0;
1495: planner varchar2(40);
1496: tokenValues MsgTokenValuePairList;
1497: v_arrival_Date DATE;
1498: v_po_line_id NUMBER :=0;
1499: v_line_location_id NUMBER :=0;
1500: v_tranzId NUMBER :=0;

Line 1529: tokenValues := MsgTokenValuePairList();

1525: if ( userId =0 or respId =0) then
1526: status := 'ERROR_USER_RESP_PROFILES_NOT_SET';
1527: end if;
1528:
1529: tokenValues := MsgTokenValuePairList();
1530:
1531: select order_type , EBS_SR_INSTANCE_ID, OTM_RELEASE_GID, updated_Arrival_Date
1532: into v_order_type, v_srInstanceId, otmReleaseGid, v_arrival_Date
1533: from msc_transportation_updates

Line 1570: tokenValues(1) := MsgTokenValuePair('PO_ORDERNUMBER', v_orderNumber);

1566: GetPlanner_1( v_srInstanceId, v_itemId, v_orgId, planner, status);
1567:
1568: if ( planner <> '0') then
1569: tokenValues.extend;
1570: tokenValues(1) := MsgTokenValuePair('PO_ORDERNUMBER', v_orderNumber);
1571: tokenValues.extend;
1572: tokenValues(2) := MsgTokenValuePair('PO_ARRIVALDATE', v_arrival_Date);
1573: tokenValues.extend;
1574: tokenValues(3) := MsgTokenValuePair('PO_URI', v_Http);

Line 1572: tokenValues(2) := MsgTokenValuePair('PO_ARRIVALDATE', v_arrival_Date);

1568: if ( planner <> '0') then
1569: tokenValues.extend;
1570: tokenValues(1) := MsgTokenValuePair('PO_ORDERNUMBER', v_orderNumber);
1571: tokenValues.extend;
1572: tokenValues(2) := MsgTokenValuePair('PO_ARRIVALDATE', v_arrival_Date);
1573: tokenValues.extend;
1574: tokenValues(3) := MsgTokenValuePair('PO_URI', v_Http);
1575:
1576: status := MSC_WS_NOTIFICATION_BPEL.SendFYINotification ( userId, respID, planner, 'EN', 'W_OTM_UP', 'W_OTM_PROC', tokenValues);

Line 1574: tokenValues(3) := MsgTokenValuePair('PO_URI', v_Http);

1570: tokenValues(1) := MsgTokenValuePair('PO_ORDERNUMBER', v_orderNumber);
1571: tokenValues.extend;
1572: tokenValues(2) := MsgTokenValuePair('PO_ARRIVALDATE', v_arrival_Date);
1573: tokenValues.extend;
1574: tokenValues(3) := MsgTokenValuePair('PO_URI', v_Http);
1575:
1576: status := MSC_WS_NOTIFICATION_BPEL.SendFYINotification ( userId, respID, planner, 'EN', 'W_OTM_UP', 'W_OTM_PROC', tokenValues);
1577:
1578: end if;