DBA Data[Home] [Help]

APPS.IBE_WORKFLOW_PVT dependencies on FND_CURRENCIES

Line 302: FROM FND_CURRENCIES fc

298: rec_order_curr_code c_order_curr_code%rowtype;
299:
300: cursor c_curr_symbol(p_currCode VARCHAR2) IS
301: SELECT fc.symbol
302: FROM FND_CURRENCIES fc
303: WHERE fc.currency_code = p_currCode;
304:
305: Cursor c_get_source_code(p_quote_id NUMBER) is
306: select quote_source_code

Line 310: g_curr_sym FND_CURRENCIES.SYMBOL%TYPE;

306: select quote_source_code
307: from aso_quote_headers_all
308: where quote_header_id = p_quote_id;
309:
310: g_curr_sym FND_CURRENCIES.SYMBOL%TYPE;
311: g_amt_format VARCHAR2(20);
312:
313: NEWLINE VARCHAR2(1) := fnd_global.newline;
314: TAB VARCHAR2(1) := fnd_global.tab;

Line 7162: l_curr_sym FND_CURRENCIES.SYMBOL%TYPE;

7158: l_can_qty VARCHAR2(50);
7159: l_can_amt VARCHAR2(50);
7160:
7161: l_amt_format Varchar2(50);
7162: l_curr_sym FND_CURRENCIES.SYMBOL%TYPE;
7163: l_temp_str VARCHAR2(2000):='';
7164: l_view_net_price_flag VARCHAR2(1);
7165: l_view_line_type_flag VARCHAR2(1) := FND_API.G_FALSE;
7166: Cursor c_ship_flag(p_line_id NUMBER) IS

Line 7604: l_curr_sym FND_CURRENCIES.SYMBOL%TYPE;

7600: lr_string_left VARCHAR2(250);
7601: lr_length NUMBER;
7602: l_order_id NUMBER;
7603: l_amt_format VARCHAR2(50);
7604: l_curr_sym FND_CURRENCIES.SYMBOL%TYPE;
7605: l_temp_str VARCHAR2(2000) :='';
7606: l_view_net_price_flag VARCHAR2(2);
7607: l_tax_flag VARCHAR2(1);
7608: l_parent_line_id NUMBER;

Line 8189: l_curr_sym FND_CURRENCIES.SYMBOL%TYPE;

8185: l_string_left VARCHAR2(250);
8186: l_order_id NUMBER;
8187:
8188: l_amt_format Varchar2(50);
8189: l_curr_sym FND_CURRENCIES.SYMBOL%TYPE;
8190:
8191: l_temp_str VARCHAR2(2000):='';
8192: l_view_net_price_flag VARCHAR2(1);
8193:

Line 8348: l_curr_sym FND_CURRENCIES.SYMBOL%TYPE;

8344: l_view_net_price_flag VARCHAR2(1);
8345:
8346:
8347: l_amt_format Varchar2(50);
8348: l_curr_sym FND_CURRENCIES.SYMBOL%TYPE;
8349:
8350: l_can_amt VARCHAR2(50);
8351: l_paynow varchar2(1);
8352: l_reccharge varchar2(1);

Line 9149: l_curr_sym FND_CURRENCIES.SYMBOL%TYPE;

9145: l_string_left VARCHAR2(250);
9146: l_view_net_price_flag VARCHAR2(1);
9147:
9148: l_amt_format Varchar2(50);
9149: l_curr_sym FND_CURRENCIES.SYMBOL%TYPE;
9150:
9151: Cursor c_ship_flag(p_inv_item_id NUMBER,p_org_id NUMBER) IS
9152: SELECT shippable_item_flag, rtrim(description) Description
9153: FROM mtl_system_items_kfv

Line 9289: l_curr_sym FND_CURRENCIES.SYMBOL%TYPE;

9285: l_sub_total NUMBER;
9286:
9287: l_view_net_price_flag VARCHAR2(1);
9288: l_amt_format Varchar2(50);
9289: l_curr_sym FND_CURRENCIES.SYMBOL%TYPE;
9290:
9291: l_can_amt VARCHAR2(50);
9292: l_paynow VARCHAR2(1);
9293: l_reccharge VARCHAR2(1);

Line 10256: l_curr_sym FND_CURRENCIES.SYMBOL%TYPE;

10252: l_string_out VARCHAR2(495);
10253: l_line_num NUMBER := 1;
10254: l_can_amt NUMBER;
10255: l_amt_format VARCHAR2(20);
10256: l_curr_sym FND_CURRENCIES.SYMBOL%TYPE;
10257: l_space_len NUMBER := 56;
10258: l_temp_str VARCHAR2(100);
10259: BEGIN
10260: