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_EXCH_RATES dependencies on ZPB_AW

Line 19: ZPB_AW.EXECUTE('aw attach ' || p_code_aw || ' ro');

15: retcode := '0';
16: is_attached := 'N';
17:
18: -- attach the required AW in approp mode
19: ZPB_AW.EXECUTE('aw attach ' || p_code_aw || ' ro');
20: ZPB_AW.EXECUTE('aw attach ' || p_data_aw || ' rw');
21: is_attached := 'Y';
22:
23: -- call the OLAP prog for loading the rates

Line 20: ZPB_AW.EXECUTE('aw attach ' || p_data_aw || ' rw');

16: is_attached := 'N';
17:
18: -- attach the required AW in approp mode
19: ZPB_AW.EXECUTE('aw attach ' || p_code_aw || ' ro');
20: ZPB_AW.EXECUTE('aw attach ' || p_data_aw || ' rw');
21: is_attached := 'Y';
22:
23: -- call the OLAP prog for loading the rates
24: ZPB_AW.EXECUTE('call CM.LOADEXRATES(''' || p_gen_cross_rates ||''''||','||''''||p_bus_area_id||''')');

Line 24: ZPB_AW.EXECUTE('call CM.LOADEXRATES(''' || p_gen_cross_rates ||''''||','||''''||p_bus_area_id||''')');

20: ZPB_AW.EXECUTE('aw attach ' || p_data_aw || ' rw');
21: is_attached := 'Y';
22:
23: -- call the OLAP prog for loading the rates
24: ZPB_AW.EXECUTE('call CM.LOADEXRATES(''' || p_gen_cross_rates ||''''||','||''''||p_bus_area_id||''')');
25:
26: -- dettach the required AW in approp mode
27: ZPB_AW.EXECUTE('aw detach ' || p_code_aw );
28: ZPB_AW.EXECUTE('aw detach ' || p_data_aw );

Line 27: ZPB_AW.EXECUTE('aw detach ' || p_code_aw );

23: -- call the OLAP prog for loading the rates
24: ZPB_AW.EXECUTE('call CM.LOADEXRATES(''' || p_gen_cross_rates ||''''||','||''''||p_bus_area_id||''')');
25:
26: -- dettach the required AW in approp mode
27: ZPB_AW.EXECUTE('aw detach ' || p_code_aw );
28: ZPB_AW.EXECUTE('aw detach ' || p_data_aw );
29: is_attached := 'N';
30:
31: EXCEPTION

Line 28: ZPB_AW.EXECUTE('aw detach ' || p_data_aw );

24: ZPB_AW.EXECUTE('call CM.LOADEXRATES(''' || p_gen_cross_rates ||''''||','||''''||p_bus_area_id||''')');
25:
26: -- dettach the required AW in approp mode
27: ZPB_AW.EXECUTE('aw detach ' || p_code_aw );
28: ZPB_AW.EXECUTE('aw detach ' || p_data_aw );
29: is_attached := 'N';
30:
31: EXCEPTION
32: WHEN OTHERS THEN

Line 35: ZPB_AW.EXECUTE('aw detach ' || p_code_aw );

31: EXCEPTION
32: WHEN OTHERS THEN
33: retcode :='2';
34: IF (is_attached = 'Y') THEN
35: ZPB_AW.EXECUTE('aw detach ' || p_code_aw );
36: ZPB_AW.EXECUTE('aw detach ' || p_data_aw );
37: END IF;
38:
39: errbuf:= SUBSTR(sqlerrm, 1, 255);

Line 36: ZPB_AW.EXECUTE('aw detach ' || p_data_aw );

32: WHEN OTHERS THEN
33: retcode :='2';
34: IF (is_attached = 'Y') THEN
35: ZPB_AW.EXECUTE('aw detach ' || p_code_aw );
36: ZPB_AW.EXECUTE('aw detach ' || p_data_aw );
37: END IF;
38:
39: errbuf:= SUBSTR(sqlerrm, 1, 255);
40: raise;

Line 51: l_codeAW := zpb_aw.get_schema||'.'|| zpb_aw.get_code_aw(l_id) ;

47: l_codeAW VARCHAR2(30);
48: l_DataAW VARCHAR2(30);
49: BEGIN
50: l_id := fnd_global.user_id;
51: l_codeAW := zpb_aw.get_schema||'.'|| zpb_aw.get_code_aw(l_id) ;
52: l_dataAW := zpb_aw.get_schema||'.'|| zpb_aw.get_shared_aw;
53:
54: -- submit the concurrent request for loading the rates
55: l_id := FND_REQUEST.SUBMIT_REQUEST ('ZPB', 'ZPB_LOAD_EXCH_RATES', NULL, NULL, FALSE, p_gen_cross_rates, l_dataAW, l_codeAW, p_bus_area_id );

Line 52: l_dataAW := zpb_aw.get_schema||'.'|| zpb_aw.get_shared_aw;

48: l_DataAW VARCHAR2(30);
49: BEGIN
50: l_id := fnd_global.user_id;
51: l_codeAW := zpb_aw.get_schema||'.'|| zpb_aw.get_code_aw(l_id) ;
52: l_dataAW := zpb_aw.get_schema||'.'|| zpb_aw.get_shared_aw;
53:
54: -- submit the concurrent request for loading the rates
55: l_id := FND_REQUEST.SUBMIT_REQUEST ('ZPB', 'ZPB_LOAD_EXCH_RATES', NULL, NULL, FALSE, p_gen_cross_rates, l_dataAW, l_codeAW, p_bus_area_id );
56: return l_id;