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.PO_ENCUMBRANCE_PREPROCESSING dependencies on FND_CURRENCIES

Line 1623: FND_CURRENCIES CUR

1619: ( SELECT
1620: CUR.minimum_accountable_unit
1621: , CUR.precision
1622: FROM
1623: FND_CURRENCIES CUR
1624: WHERE CUR.currency_code = ENC.currency_code
1625: )
1626: WHERE ENC.sequence_num IS NULL
1627: AND ENC.prevent_encumbrance_flag = 'N'

Line 4757: l_min_acct_unit_func FND_CURRENCIES.minimum_accountable_unit%TYPE;

4753:
4754: l_ap_reinstated_enc_amt NUMBER;
4755: l_ap_cancelled_qty NUMBER;
4756:
4757: l_min_acct_unit_func FND_CURRENCIES.minimum_accountable_unit%TYPE;
4758: l_cur_precision_func FND_CURRENCIES.precision%TYPE;
4759:
4760: l_is_complex_work_po BOOLEAN := FALSE; --
4761: l_header_id PO_HEADERS_ALL.po_header_id%TYPE; --

Line 4758: l_cur_precision_func FND_CURRENCIES.precision%TYPE;

4754: l_ap_reinstated_enc_amt NUMBER;
4755: l_ap_cancelled_qty NUMBER;
4756:
4757: l_min_acct_unit_func FND_CURRENCIES.minimum_accountable_unit%TYPE;
4758: l_cur_precision_func FND_CURRENCIES.precision%TYPE;
4759:
4760: l_is_complex_work_po BOOLEAN := FALSE; --
4761: l_header_id PO_HEADERS_ALL.po_header_id%TYPE; --
4762:

Line 4803: FROM FND_CURRENCIES FND_CUR

4799: , FND_CUR.precision
4800: INTO
4801: l_min_acct_unit_func
4802: , l_cur_precision_func
4803: FROM FND_CURRENCIES FND_CUR
4804: WHERE FND_CUR.currency_code = p_currency_code_func
4805: ;
4806:
4807: IF g_debug_stmt THEN

Line 4969: -- The minimum accountable unit (defined in FND_CURRENCIES) of the

4965: --p_currency_code_func
4966: -- Identifies the currency that is defined as the functional
4967: -- currency for the current set of books
4968: --p_min_acct_unit_func
4969: -- The minimum accountable unit (defined in FND_CURRENCIES) of the
4970: -- functional currency for the currency Set of Books
4971: --p_cur_precision_func
4972: -- The precision (defined in FND_CURRENCIES) of the functional
4973: -- currency for the current Set of Books

Line 4972: -- The precision (defined in FND_CURRENCIES) of the functional

4968: --p_min_acct_unit_func
4969: -- The minimum accountable unit (defined in FND_CURRENCIES) of the
4970: -- functional currency for the currency Set of Books
4971: --p_cur_precision_func
4972: -- The precision (defined in FND_CURRENCIES) of the functional
4973: -- currency for the current Set of Books
4974: --Testing:
4975: --
4976: --End of Comments

Line 5439: -- The minimum accountable unit (defined in FND_CURRENCIES) of the

5435: --p_currency_code_func
5436: -- Identifies the currency that is defined as the functional
5437: -- currency for the current set of books
5438: --p_min_acct_unit_func
5439: -- The minimum accountable unit (defined in FND_CURRENCIES) of the
5440: -- functional currency for the currency Set of Books
5441: --p_cur_precision_func
5442: -- The precision (defined in FND_CURRENCIES) of the functional
5443: -- currency for the current Set of Books

Line 5442: -- The precision (defined in FND_CURRENCIES) of the functional

5438: --p_min_acct_unit_func
5439: -- The minimum accountable unit (defined in FND_CURRENCIES) of the
5440: -- functional currency for the currency Set of Books
5441: --p_cur_precision_func
5442: -- The precision (defined in FND_CURRENCIES) of the functional
5443: -- currency for the current Set of Books
5444: --p_ap_cancelled_qty
5445: -- For Invoice/Credit Memo cancel only: the quantity of the
5446: -- cancelled invoice

Line 5849: -- The minimum accountable unit (defined in FND_CURRENCIES) of the

5845: --p_currency_code_func
5846: -- Identifies the currency that is defined as the functional
5847: -- currency for the current set of books
5848: --p_min_acct_unit_func
5849: -- The minimum accountable unit (defined in FND_CURRENCIES) of the
5850: -- functional currency for the currency Set of Books
5851: --p_cur_precision_func
5852: -- The precision (defined in FND_CURRENCIES) of the functional
5853: -- currency for the current Set of Books

Line 5852: -- The precision (defined in FND_CURRENCIES) of the functional

5848: --p_min_acct_unit_func
5849: -- The minimum accountable unit (defined in FND_CURRENCIES) of the
5850: -- functional currency for the currency Set of Books
5851: --p_cur_precision_func
5852: -- The precision (defined in FND_CURRENCIES) of the functional
5853: -- currency for the current Set of Books
5854: --p_ap_reinstated_enc_amt
5855: -- For Invoice/Credit Memo cancel only: the amount of encumbrance
5856: -- put back on by AP (w/o any AP variances)

Line 6138: -- The minimum accountable unit (defined in FND_CURRENCIES) of the

6134: --p_currency_code_func
6135: -- Identifies the currency that is defined as the functional
6136: -- currency for the current set of books
6137: --p_min_acct_unit_func
6138: -- The minimum accountable unit (defined in FND_CURRENCIES) of the
6139: -- functional currency for the currency Set of Books
6140: --p_cur_precision_func
6141: -- The precision (defined in FND_CURRENCIES) of the functional
6142: -- currency for the current Set of Books

Line 6141: -- The precision (defined in FND_CURRENCIES) of the functional

6137: --p_min_acct_unit_func
6138: -- The minimum accountable unit (defined in FND_CURRENCIES) of the
6139: -- functional currency for the currency Set of Books
6140: --p_cur_precision_func
6141: -- The precision (defined in FND_CURRENCIES) of the functional
6142: -- currency for the current Set of Books
6143: --p_column_to_use
6144: -- Specifies with column of PO_ENCUMBRANCE_GT to convert and round
6145: -- Valid Values:

Line 7699: l_min_acct_unit_func FND_CURRENCIES.minimum_accountable_unit%TYPE;

7695: l_min_acct_unit_to_tbl PO_TBL_NUMBER;
7696: l_round_only_flag_tbl PO_TBL_VARCHAR1;
7697: l_amount_result_tbl PO_TBL_NUMBER;
7698: l_origin_sequence_num_tbl PO_TBL_NUMBER;
7699: l_min_acct_unit_func FND_CURRENCIES.minimum_accountable_unit%TYPE;
7700: l_cur_precision_func FND_CURRENCIES.precision%TYPE;
7701: l_log_head CONSTANT VARCHAR2(100) := g_log_head || l_api_name;
7702: BEGIN
7703:

Line 7700: l_cur_precision_func FND_CURRENCIES.precision%TYPE;

7696: l_round_only_flag_tbl PO_TBL_VARCHAR1;
7697: l_amount_result_tbl PO_TBL_NUMBER;
7698: l_origin_sequence_num_tbl PO_TBL_NUMBER;
7699: l_min_acct_unit_func FND_CURRENCIES.minimum_accountable_unit%TYPE;
7700: l_cur_precision_func FND_CURRENCIES.precision%TYPE;
7701: l_log_head CONSTANT VARCHAR2(100) := g_log_head || l_api_name;
7702: BEGIN
7703:
7704: l_progress := '000';

Line 7804: FROM FND_CURRENCIES FND_CUR

7800: , FND_CUR.precision
7801: INTO
7802: l_min_acct_unit_func
7803: , l_cur_precision_func
7804: FROM FND_CURRENCIES FND_CUR
7805: WHERE FND_CUR.currency_code = p_currency_code_func
7806: ;
7807: IF g_debug_stmt THEN
7808: PO_DEBUG.debug_stmt(l_log_head,l_progress,'After querying functional currency setup');