DBA Data[Home] [Help]

APPS.MSDWF dependencies on EPS

Line 66: from THE (SELECT CAST (EPS.query(express_server,

62: Itemkey => ItemKey,
63: aname => 'ODPPLAN');
64: SELECT C0, C1, C2, C3
65: into ActRetCode, ActRetText, ActRetVal, ActRetErr
66: from THE (SELECT CAST (EPS.query(express_server,
67: 'DB0='|| CodeLoc || '/ODPCODE\'
68: || 'DBCount=1\'
69: || 'MeasureCount=4\'
70: || 'Measure0=ACTIVITY.FORMULA\'

Line 87: AS EPS_express_list_t)

83: ,NULL
84: ,NULL
85: ,NULL
86: ,NULL)
87: AS EPS_express_list_t)
88: from DUAL);
89: if ActRetCode = 'Y' then
90: resultout :='COMPLETE:Y';
91: end if;

Line 309: from THE (SELECT CAST (EPS.query(express_server,

305: Itemkey => ItemKey,
306: aname => 'CODELOC');
307: SELECT C0, C1, C2
308: into ActRetCode, ActRetText, ActRetErr
309: from THE (SELECT CAST (EPS.query(express_server,
310: 'DB0='|| CodeLoc || '/ODPCODE\'
311: || 'DBCount=1\'
312: || 'MeasureCount=3\'
313: || 'Measure0=ACTIVITY.FORMULA\'

Line 329: AS EPS_express_list_t)

325: ,NULL
326: ,NULL
327: ,NULL
328: ,NULL)
329: AS EPS_express_list_t)
330: from DUAL);
331: if ActRetCode = 'Y' then
332: resultout :='COMPLETE:Y';
333: end if;

Line 393: from THE (SELECT CAST (EPS.query(express_server,

389: Itemkey => ItemKey,
390: aname => 'CODELOC');
391: SELECT C0, C1, C2, C3
392: into ActRetCode, ActRetText, ActRetVal, ActRetErr
393: from THE (SELECT CAST (EPS.query(express_server,
394: 'DB0='|| CodeLoc || '/ODPCODE\'
395: || 'DBCount=1\'
396: || 'MeasureCount=4\'
397: || 'Measure0=ACTIVITY.FORMULA\'

Line 414: AS EPS_express_list_t)

410: ,NULL
411: ,NULL
412: ,NULL
413: ,NULL)
414: AS EPS_express_list_t)
415: from DUAL);
416: -- This is the end. We are out.
417: -- I need Y/N/DONE as possible return values.
418: if ActRetCode = 'DONE' then