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.

[Home] [Help]

APPS.IBE_WORKFLOW_PVT dependencies on FND_CURRENCIES

Line 292: FROM FND_CURRENCIES fc

288: rec_order_curr_code c_order_curr_code%rowtype;
289:
290: cursor c_curr_symbol(p_currCode VARCHAR2) IS
291: SELECT fc.symbol
292: FROM FND_CURRENCIES fc
293: WHERE fc.currency_code = p_currCode;
294:
295: Cursor c_get_source_code(p_quote_id NUMBER) is
296: select quote_source_code

Line 300: g_curr_sym FND_CURRENCIES.SYMBOL%TYPE;

296: select quote_source_code
297: from aso_quote_headers_all
298: where quote_header_id = p_quote_id;
299:
300: g_curr_sym FND_CURRENCIES.SYMBOL%TYPE;
301: g_amt_format VARCHAR2(20);
302:
303: NEWLINE VARCHAR2(1) := fnd_global.newline;
304: TAB VARCHAR2(1) := fnd_global.tab;

Line 7067: l_curr_sym FND_CURRENCIES.SYMBOL%TYPE;

7063: l_can_qty VARCHAR2(50);
7064: l_can_amt VARCHAR2(50);
7065:
7066: l_amt_format Varchar2(50);
7067: l_curr_sym FND_CURRENCIES.SYMBOL%TYPE;
7068: l_temp_str VARCHAR2(2000):='';
7069: l_view_net_price_flag VARCHAR2(1);
7070: l_view_line_type_flag VARCHAR2(1) := FND_API.G_FALSE;
7071: Cursor c_ship_flag(p_line_id NUMBER) IS

Line 7509: l_curr_sym FND_CURRENCIES.SYMBOL%TYPE;

7505: lr_string_left VARCHAR2(250);
7506: lr_length NUMBER;
7507: l_order_id NUMBER;
7508: l_amt_format VARCHAR2(50);
7509: l_curr_sym FND_CURRENCIES.SYMBOL%TYPE;
7510: l_temp_str VARCHAR2(2000) :='';
7511: l_view_net_price_flag VARCHAR2(2);
7512: l_tax_flag VARCHAR2(1);
7513: l_parent_line_id NUMBER;

Line 8094: l_curr_sym FND_CURRENCIES.SYMBOL%TYPE;

8090: l_string_left VARCHAR2(250);
8091: l_order_id NUMBER;
8092:
8093: l_amt_format Varchar2(50);
8094: l_curr_sym FND_CURRENCIES.SYMBOL%TYPE;
8095:
8096: l_temp_str VARCHAR2(2000):='';
8097: l_view_net_price_flag VARCHAR2(1);
8098:

Line 8253: l_curr_sym FND_CURRENCIES.SYMBOL%TYPE;

8249: l_view_net_price_flag VARCHAR2(1);
8250:
8251:
8252: l_amt_format Varchar2(50);
8253: l_curr_sym FND_CURRENCIES.SYMBOL%TYPE;
8254:
8255: l_can_amt VARCHAR2(50);
8256: l_paynow varchar2(1);
8257: l_reccharge varchar2(1);

Line 9054: l_curr_sym FND_CURRENCIES.SYMBOL%TYPE;

9050: l_string_left VARCHAR2(250);
9051: l_view_net_price_flag VARCHAR2(1);
9052:
9053: l_amt_format Varchar2(50);
9054: l_curr_sym FND_CURRENCIES.SYMBOL%TYPE;
9055:
9056: Cursor c_ship_flag(p_inv_item_id NUMBER,p_org_id NUMBER) IS
9057: SELECT shippable_item_flag, rtrim(description) Description
9058: FROM mtl_system_items_kfv

Line 9194: l_curr_sym FND_CURRENCIES.SYMBOL%TYPE;

9190: l_sub_total NUMBER;
9191:
9192: l_view_net_price_flag VARCHAR2(1);
9193: l_amt_format Varchar2(50);
9194: l_curr_sym FND_CURRENCIES.SYMBOL%TYPE;
9195:
9196: l_can_amt VARCHAR2(50);
9197: l_paynow VARCHAR2(1);
9198: l_reccharge VARCHAR2(1);

Line 10161: l_curr_sym FND_CURRENCIES.SYMBOL%TYPE;

10157: l_string_out VARCHAR2(100);
10158: l_line_num NUMBER := 1;
10159: l_can_amt NUMBER;
10160: l_amt_format VARCHAR2(20);
10161: l_curr_sym FND_CURRENCIES.SYMBOL%TYPE;
10162: l_space_len NUMBER := 56;
10163: l_temp_str VARCHAR2(100);
10164: BEGIN
10165: