eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.ZPB_EXTERNAL_BP_PUBLISH dependencies on ZPB_AW

Line 10: --ZPB_AW.EXECUTE('aw aliaslist ' ||l_dataaw ||' unalias SHARED');

6: PROCEDURE CLEANUP(l_codeaw VARCHAR2, l_dataaw VARCHAR2) AS
7: BEGIN
8: -- dettach the required AW in approp mode
9: IF (is_attached = 'Y') THEN
10: --ZPB_AW.EXECUTE('aw aliaslist ' ||l_dataaw ||' unalias SHARED');
11: --ZPB_AW.EXECUTE('aw detach ' || l_codeaw );
12: --ZPB_AW.EXECUTE('aw detach ' || l_dataaw );
13:
14: --b4939451

Line 11: --ZPB_AW.EXECUTE('aw detach ' || l_codeaw );

7: BEGIN
8: -- dettach the required AW in approp mode
9: IF (is_attached = 'Y') THEN
10: --ZPB_AW.EXECUTE('aw aliaslist ' ||l_dataaw ||' unalias SHARED');
11: --ZPB_AW.EXECUTE('aw detach ' || l_codeaw );
12: --ZPB_AW.EXECUTE('aw detach ' || l_dataaw );
13:
14: --b4939451
15: ZPB_AW.DETACH_ALL;

Line 12: --ZPB_AW.EXECUTE('aw detach ' || l_dataaw );

8: -- dettach the required AW in approp mode
9: IF (is_attached = 'Y') THEN
10: --ZPB_AW.EXECUTE('aw aliaslist ' ||l_dataaw ||' unalias SHARED');
11: --ZPB_AW.EXECUTE('aw detach ' || l_codeaw );
12: --ZPB_AW.EXECUTE('aw detach ' || l_dataaw );
13:
14: --b4939451
15: ZPB_AW.DETACH_ALL;
16: is_attached := 'N';

Line 15: ZPB_AW.DETACH_ALL;

11: --ZPB_AW.EXECUTE('aw detach ' || l_codeaw );
12: --ZPB_AW.EXECUTE('aw detach ' || l_dataaw );
13:
14: --b4939451
15: ZPB_AW.DETACH_ALL;
16: is_attached := 'N';
17: END IF;
18: EXCEPTION
19: WHEN OTHERS THEN

Line 236: -- l_codeAW := zpb_aw.get_schema||'.'|| zpb_aw.get_code_aw(l_owner) ;

232:
233: -- attach the required AW in approp mode
234:
235: -- b4939451
236: -- l_codeAW := zpb_aw.get_schema||'.'|| zpb_aw.get_code_aw(l_owner) ;
237: -- l_dataaw := zpb_aw.get_schema||'.ZPBDATA'|| l_busArea ;
238:
239: -- ZPB_AW.EXECUTE('aw attach ' || l_codeaw || ' ro');
240: -- ZPB_AW.EXECUTE('aw attach ' || l_dataaw || ' ro');

Line 237: -- l_dataaw := zpb_aw.get_schema||'.ZPBDATA'|| l_busArea ;

233: -- attach the required AW in approp mode
234:
235: -- b4939451
236: -- l_codeAW := zpb_aw.get_schema||'.'|| zpb_aw.get_code_aw(l_owner) ;
237: -- l_dataaw := zpb_aw.get_schema||'.ZPBDATA'|| l_busArea ;
238:
239: -- ZPB_AW.EXECUTE('aw attach ' || l_codeaw || ' ro');
240: -- ZPB_AW.EXECUTE('aw attach ' || l_dataaw || ' ro');
241: -- ZPB_AW.EXECUTE('aw aliaslist ' || l_dataaw || ' alias SHARED');

Line 239: -- ZPB_AW.EXECUTE('aw attach ' || l_codeaw || ' ro');

235: -- b4939451
236: -- l_codeAW := zpb_aw.get_schema||'.'|| zpb_aw.get_code_aw(l_owner) ;
237: -- l_dataaw := zpb_aw.get_schema||'.ZPBDATA'|| l_busArea ;
238:
239: -- ZPB_AW.EXECUTE('aw attach ' || l_codeaw || ' ro');
240: -- ZPB_AW.EXECUTE('aw attach ' || l_dataaw || ' ro');
241: -- ZPB_AW.EXECUTE('aw aliaslist ' || l_dataaw || ' alias SHARED');
242:
243: ZPB_AW.INITIALIZE (P_API_VERSION => 1.0,

Line 240: -- ZPB_AW.EXECUTE('aw attach ' || l_dataaw || ' ro');

236: -- l_codeAW := zpb_aw.get_schema||'.'|| zpb_aw.get_code_aw(l_owner) ;
237: -- l_dataaw := zpb_aw.get_schema||'.ZPBDATA'|| l_busArea ;
238:
239: -- ZPB_AW.EXECUTE('aw attach ' || l_codeaw || ' ro');
240: -- ZPB_AW.EXECUTE('aw attach ' || l_dataaw || ' ro');
241: -- ZPB_AW.EXECUTE('aw aliaslist ' || l_dataaw || ' alias SHARED');
242:
243: ZPB_AW.INITIALIZE (P_API_VERSION => 1.0,
244: P_INIT_MSG_LIST => FND_API.G_TRUE,

Line 241: -- ZPB_AW.EXECUTE('aw aliaslist ' || l_dataaw || ' alias SHARED');

237: -- l_dataaw := zpb_aw.get_schema||'.ZPBDATA'|| l_busArea ;
238:
239: -- ZPB_AW.EXECUTE('aw attach ' || l_codeaw || ' ro');
240: -- ZPB_AW.EXECUTE('aw attach ' || l_dataaw || ' ro');
241: -- ZPB_AW.EXECUTE('aw aliaslist ' || l_dataaw || ' alias SHARED');
242:
243: ZPB_AW.INITIALIZE (P_API_VERSION => 1.0,
244: P_INIT_MSG_LIST => FND_API.G_TRUE,
245: X_RETURN_STATUS => x_return_status,

Line 243: ZPB_AW.INITIALIZE (P_API_VERSION => 1.0,

239: -- ZPB_AW.EXECUTE('aw attach ' || l_codeaw || ' ro');
240: -- ZPB_AW.EXECUTE('aw attach ' || l_dataaw || ' ro');
241: -- ZPB_AW.EXECUTE('aw aliaslist ' || l_dataaw || ' alias SHARED');
242:
243: ZPB_AW.INITIALIZE (P_API_VERSION => 1.0,
244: P_INIT_MSG_LIST => FND_API.G_TRUE,
245: X_RETURN_STATUS => x_return_status,
246: X_MSG_COUNT => x_msg_count,
247: X_MSG_DATA => errbuf,

Line 285: l_timemems := zpb_aw.interp( l_olap_call );

281:
282: -- l_olap_call := l_olap_call || l_exist_start_mem || '''' ||' ' || '''' || l_exist_end_mem || ''')';
283:
284: --dbms_output.put_line(l_olap_call);
285: l_timemems := zpb_aw.interp( l_olap_call );
286: --dbms_output.put_line(l_timemems);
287:
288: -- ex call:
289: -- show cm.gettimemem('1/12/1995' '1/12/2004' )

Line 321: l_isvalid := ZPB_AW.INTERPBOOL (l_olap_call );

317:
318: -- validate if the start mem is prior to end mem
319: l_olap_call := 'show &'|| 'obj(property ''ENDDATEVAR'' ''CAL_PERIODS'')(cal_periods '''||l_end_id||''') ge &'||'obj(property ''ENDDATEVAR'' ''CAL_PERIODS'')(cal_periods '''||l_start_id||''')';
320: --dbms_output.put_line(' l_olap_call=' || l_olap_call);
321: l_isvalid := ZPB_AW.INTERPBOOL (l_olap_call );
322:
323: IF NOT(l_isvalid) THEN
324: FND_MESSAGE.SET_NAME('ZPB', 'ZPB_INVALID_DATES');
325: X_MSG_data := FND_MESSAGE.GET;

Line 399: -- ZPB_AW.EXECUTE('aw aliaslist ' ||l_dataaw ||' unalias SHARED');

395:
396: -- dettach the required AW in approp mode
397:
398: -- b4939451
399: -- ZPB_AW.EXECUTE('aw aliaslist ' ||l_dataaw ||' unalias SHARED');
400: -- ZPB_AW.EXECUTE('aw detach ' || l_codeaw );
401: -- ZPB_AW.EXECUTE('aw detach ' || l_dataaw );
402:
403: ZPB_AW.DETACH_ALL;

Line 400: -- ZPB_AW.EXECUTE('aw detach ' || l_codeaw );

396: -- dettach the required AW in approp mode
397:
398: -- b4939451
399: -- ZPB_AW.EXECUTE('aw aliaslist ' ||l_dataaw ||' unalias SHARED');
400: -- ZPB_AW.EXECUTE('aw detach ' || l_codeaw );
401: -- ZPB_AW.EXECUTE('aw detach ' || l_dataaw );
402:
403: ZPB_AW.DETACH_ALL;
404: is_attached := 'N';

Line 401: -- ZPB_AW.EXECUTE('aw detach ' || l_dataaw );

397:
398: -- b4939451
399: -- ZPB_AW.EXECUTE('aw aliaslist ' ||l_dataaw ||' unalias SHARED');
400: -- ZPB_AW.EXECUTE('aw detach ' || l_codeaw );
401: -- ZPB_AW.EXECUTE('aw detach ' || l_dataaw );
402:
403: ZPB_AW.DETACH_ALL;
404: is_attached := 'N';
405:

Line 403: ZPB_AW.DETACH_ALL;

399: -- ZPB_AW.EXECUTE('aw aliaslist ' ||l_dataaw ||' unalias SHARED');
400: -- ZPB_AW.EXECUTE('aw detach ' || l_codeaw );
401: -- ZPB_AW.EXECUTE('aw detach ' || l_dataaw );
402:
403: ZPB_AW.DETACH_ALL;
404: is_attached := 'N';
405:
406: -- POST VALIDATION SUCCESS
407: -- b4594118 23Sep05 flip fnd_global.user_id back to calling user ID for last update by audits