DBA Data[Home] [Help]

APPS.PO_ENCUMBRANCE_PREPROCESSING dependencies on FND_CURRENCIES

Line 1661: FND_CURRENCIES CUR

1657: ( SELECT
1658: CUR.minimum_accountable_unit
1659: , CUR.precision
1660: FROM
1661: FND_CURRENCIES CUR
1662: WHERE CUR.currency_code = ENC.currency_code
1663: )
1664: WHERE ENC.sequence_num IS NULL
1665: AND ENC.prevent_encumbrance_flag = 'N'

Line 4908: l_min_acct_unit_func FND_CURRENCIES.minimum_accountable_unit%TYPE;

4904:
4905: l_ap_reinstated_enc_amt NUMBER;
4906: l_ap_cancelled_qty NUMBER;
4907:
4908: l_min_acct_unit_func FND_CURRENCIES.minimum_accountable_unit%TYPE;
4909: l_cur_precision_func FND_CURRENCIES.precision%TYPE;
4910:
4911: l_is_complex_work_po BOOLEAN := FALSE; --
4912: l_header_id PO_HEADERS_ALL.po_header_id%TYPE; --

Line 4909: l_cur_precision_func FND_CURRENCIES.precision%TYPE;

4905: l_ap_reinstated_enc_amt NUMBER;
4906: l_ap_cancelled_qty NUMBER;
4907:
4908: l_min_acct_unit_func FND_CURRENCIES.minimum_accountable_unit%TYPE;
4909: l_cur_precision_func FND_CURRENCIES.precision%TYPE;
4910:
4911: l_is_complex_work_po BOOLEAN := FALSE; --
4912: l_header_id PO_HEADERS_ALL.po_header_id%TYPE; --
4913:

Line 4954: FROM FND_CURRENCIES FND_CUR

4950: , FND_CUR.precision
4951: INTO
4952: l_min_acct_unit_func
4953: , l_cur_precision_func
4954: FROM FND_CURRENCIES FND_CUR
4955: WHERE FND_CUR.currency_code = p_currency_code_func
4956: ;
4957:
4958: IF g_debug_stmt THEN

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

5119: --p_currency_code_func
5120: -- Identifies the currency that is defined as the functional
5121: -- currency for the current set of books
5122: --p_min_acct_unit_func
5123: -- The minimum accountable unit (defined in FND_CURRENCIES) of the
5124: -- functional currency for the currency Set of Books
5125: --p_cur_precision_func
5126: -- The precision (defined in FND_CURRENCIES) of the functional
5127: -- currency for the current Set of Books

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

5122: --p_min_acct_unit_func
5123: -- The minimum accountable unit (defined in FND_CURRENCIES) of the
5124: -- functional currency for the currency Set of Books
5125: --p_cur_precision_func
5126: -- The precision (defined in FND_CURRENCIES) of the functional
5127: -- currency for the current Set of Books
5128: --Testing:
5129: --
5130: --End of Comments

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

5627: --p_currency_code_func
5628: -- Identifies the currency that is defined as the functional
5629: -- currency for the current set of books
5630: --p_min_acct_unit_func
5631: -- The minimum accountable unit (defined in FND_CURRENCIES) of the
5632: -- functional currency for the currency Set of Books
5633: --p_cur_precision_func
5634: -- The precision (defined in FND_CURRENCIES) of the functional
5635: -- currency for the current Set of Books

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

5630: --p_min_acct_unit_func
5631: -- The minimum accountable unit (defined in FND_CURRENCIES) of the
5632: -- functional currency for the currency Set of Books
5633: --p_cur_precision_func
5634: -- The precision (defined in FND_CURRENCIES) of the functional
5635: -- currency for the current Set of Books
5636: --p_ap_cancelled_qty
5637: -- For Invoice/Credit Memo cancel only: the quantity of the
5638: -- cancelled invoice

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

6109: --p_currency_code_func
6110: -- Identifies the currency that is defined as the functional
6111: -- currency for the current set of books
6112: --p_min_acct_unit_func
6113: -- The minimum accountable unit (defined in FND_CURRENCIES) of the
6114: -- functional currency for the currency Set of Books
6115: --p_cur_precision_func
6116: -- The precision (defined in FND_CURRENCIES) of the functional
6117: -- currency for the current Set of Books

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

6112: --p_min_acct_unit_func
6113: -- The minimum accountable unit (defined in FND_CURRENCIES) of the
6114: -- functional currency for the currency Set of Books
6115: --p_cur_precision_func
6116: -- The precision (defined in FND_CURRENCIES) of the functional
6117: -- currency for the current Set of Books
6118: --p_ap_reinstated_enc_amt
6119: -- For Invoice/Credit Memo cancel only: the amount of encumbrance
6120: -- put back on by AP (w/o any AP variances)

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

6511: --p_currency_code_func
6512: -- Identifies the currency that is defined as the functional
6513: -- currency for the current set of books
6514: --p_min_acct_unit_func
6515: -- The minimum accountable unit (defined in FND_CURRENCIES) of the
6516: -- functional currency for the currency Set of Books
6517: --p_cur_precision_func
6518: -- The precision (defined in FND_CURRENCIES) of the functional
6519: -- currency for the current Set of Books

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

6514: --p_min_acct_unit_func
6515: -- The minimum accountable unit (defined in FND_CURRENCIES) of the
6516: -- functional currency for the currency Set of Books
6517: --p_cur_precision_func
6518: -- The precision (defined in FND_CURRENCIES) of the functional
6519: -- currency for the current Set of Books
6520: --p_column_to_use
6521: -- Specifies with column of PO_ENCUMBRANCE_GT to convert and round
6522: -- Valid Values:

Line 8099: l_min_acct_unit_func FND_CURRENCIES.minimum_accountable_unit%TYPE;

8095: l_min_acct_unit_to_tbl PO_TBL_NUMBER;
8096: l_round_only_flag_tbl PO_TBL_VARCHAR1;
8097: l_amount_result_tbl PO_TBL_NUMBER;
8098: l_origin_sequence_num_tbl PO_TBL_NUMBER;
8099: l_min_acct_unit_func FND_CURRENCIES.minimum_accountable_unit%TYPE;
8100: l_cur_precision_func FND_CURRENCIES.precision%TYPE;
8101: l_log_head CONSTANT VARCHAR2(100) := g_log_head || l_api_name;
8102: BEGIN
8103:

Line 8100: l_cur_precision_func FND_CURRENCIES.precision%TYPE;

8096: l_round_only_flag_tbl PO_TBL_VARCHAR1;
8097: l_amount_result_tbl PO_TBL_NUMBER;
8098: l_origin_sequence_num_tbl PO_TBL_NUMBER;
8099: l_min_acct_unit_func FND_CURRENCIES.minimum_accountable_unit%TYPE;
8100: l_cur_precision_func FND_CURRENCIES.precision%TYPE;
8101: l_log_head CONSTANT VARCHAR2(100) := g_log_head || l_api_name;
8102: BEGIN
8103:
8104: l_progress := '000';

Line 8225: FROM FND_CURRENCIES FND_CUR

8221: , FND_CUR.precision
8222: INTO
8223: l_min_acct_unit_func
8224: , l_cur_precision_func
8225: FROM FND_CURRENCIES FND_CUR
8226: WHERE FND_CUR.currency_code = p_currency_code_func
8227: ;
8228: IF g_debug_stmt THEN
8229: PO_DEBUG.debug_stmt(l_log_head,l_progress,'After querying functional currency setup');