DBA Data[Home] [Help]

APPS.WMS_WMSSCHS1_XMLP_PKG dependencies on FND_CLIENT_INFO

Line 79: FND_CLIENT_INFO.SET_ORG_CONTEXT(L_MASTER_ORG_ID);

75: INTO L_MASTER_ORG_ID
76: FROM
77: ORG_ORGANIZATION_DEFINITIONS
78: WHERE ORGANIZATION_ID = P_ORG_ID;
79: FND_CLIENT_INFO.SET_ORG_CONTEXT(L_MASTER_ORG_ID);
80: IF P_SCHEDULE_SHIPMENT_FROM_DATE IS NOT NULL AND P_SCHEDULE_SHIPMENT_TO_DATE IS NOT NULL THEN
81: LP_SHIPMENT_SCHEDULE_DATE := ' AND to_char(OE1.SCHEDULE_SHIP_DATE,''YYYY/MM/DD'') BETWEEN ''' || SUBSTR(P_SCHEDULE_SHIPMENT_FROM_DATE
82: ,1
83: ,10) || ''' AND ''' || SUBSTR(P_SCHEDULE_SHIPMENT_TO_DATE