DBA Data[Home] [Help]

APPS.PO_DOCUMENT_TOTALS_PVT dependencies on GL_CURRENCIES

Line 184: l_precision GL_CURRENCIES.precision%TYPE;

180: d_mod CONSTANT VARCHAR2(100) :=
181: PO_LOG.get_subprogram_base(D_PACKAGE_BASE,'getAmountOrdered');
182: d_position NUMBER := 0;
183: l_return_val NUMBER := 0;
184: l_precision GL_CURRENCIES.precision%TYPE;
185: l_mau GL_CURRENCIES.minimum_accountable_unit%TYPE;
186: BEGIN
187:
188: IF PO_LOG.d_proc THEN

Line 185: l_mau GL_CURRENCIES.minimum_accountable_unit%TYPE;

181: PO_LOG.get_subprogram_base(D_PACKAGE_BASE,'getAmountOrdered');
182: d_position NUMBER := 0;
183: l_return_val NUMBER := 0;
184: l_precision GL_CURRENCIES.precision%TYPE;
185: l_mau GL_CURRENCIES.minimum_accountable_unit%TYPE;
186: BEGIN
187:
188: IF PO_LOG.d_proc THEN
189: PO_LOG.proc_begin(d_mod,'p_doc_level',p_doc_level);

Line 500: l_precision GL_CURRENCIES.precision%TYPE;

496: d_mod CONSTANT VARCHAR2(100) :=
497: PO_LOG.get_subprogram_base(D_PACKAGE_BASE,'getAmountApprovedForLine');
498: d_position NUMBER := 0;
499: l_return_val NUMBER := 0;
500: l_precision GL_CURRENCIES.precision%TYPE;
501: l_mau GL_CURRENCIES.minimum_accountable_unit%TYPE;
502: BEGIN
503:
504: IF PO_LOG.d_proc THEN

Line 501: l_mau GL_CURRENCIES.minimum_accountable_unit%TYPE;

497: PO_LOG.get_subprogram_base(D_PACKAGE_BASE,'getAmountApprovedForLine');
498: d_position NUMBER := 0;
499: l_return_val NUMBER := 0;
500: l_precision GL_CURRENCIES.precision%TYPE;
501: l_mau GL_CURRENCIES.minimum_accountable_unit%TYPE;
502: BEGIN
503:
504: IF PO_LOG.d_proc THEN
505: PO_LOG.proc_begin(d_mod,'p_line_id',p_line_id);

Line 653: l_precision GL_CURRENCIES.precision%TYPE;

649: d_mod CONSTANT VARCHAR2(100) :=
650: PO_LOG.get_subprogram_base(D_PACKAGE_BASE,'getAmountApprovedForHeader');
651: d_position NUMBER := 0;
652: l_return_val NUMBER := 0;
653: l_precision GL_CURRENCIES.precision%TYPE;
654: l_mau GL_CURRENCIES.minimum_accountable_unit%TYPE;
655: BEGIN
656:
657: IF PO_LOG.d_proc THEN

Line 654: l_mau GL_CURRENCIES.minimum_accountable_unit%TYPE;

650: PO_LOG.get_subprogram_base(D_PACKAGE_BASE,'getAmountApprovedForHeader');
651: d_position NUMBER := 0;
652: l_return_val NUMBER := 0;
653: l_precision GL_CURRENCIES.precision%TYPE;
654: l_mau GL_CURRENCIES.minimum_accountable_unit%TYPE;
655: BEGIN
656:
657: IF PO_LOG.d_proc THEN
658: PO_LOG.proc_begin(d_mod,'p_header_id',p_header_id);

Line 809: l_precision GL_CURRENCIES.precision%TYPE;

805: d_mod CONSTANT VARCHAR2(100) :=
806: PO_LOG.get_subprogram_base(D_PACKAGE_BASE,'getAmountDeliveredForLine');
807: d_position NUMBER := 0;
808: l_return_val NUMBER := 0;
809: l_precision GL_CURRENCIES.precision%TYPE;
810: l_mau GL_CURRENCIES.minimum_accountable_unit%TYPE;
811: BEGIN
812:
813: IF PO_LOG.d_proc THEN

Line 810: l_mau GL_CURRENCIES.minimum_accountable_unit%TYPE;

806: PO_LOG.get_subprogram_base(D_PACKAGE_BASE,'getAmountDeliveredForLine');
807: d_position NUMBER := 0;
808: l_return_val NUMBER := 0;
809: l_precision GL_CURRENCIES.precision%TYPE;
810: l_mau GL_CURRENCIES.minimum_accountable_unit%TYPE;
811: BEGIN
812:
813: IF PO_LOG.d_proc THEN
814: PO_LOG.proc_begin(d_mod,'p_line_id',p_line_id);

Line 976: l_precision GL_CURRENCIES.precision%TYPE;

972: d_mod CONSTANT VARCHAR2(100) :=
973: PO_LOG.get_subprogram_base(D_PACKAGE_BASE,'getAmountDeliveredForHeader');
974: d_position NUMBER := 0;
975: l_return_val NUMBER := 0;
976: l_precision GL_CURRENCIES.precision%TYPE;
977: l_mau GL_CURRENCIES.minimum_accountable_unit%TYPE;
978: BEGIN
979:
980: IF PO_LOG.d_proc THEN

Line 977: l_mau GL_CURRENCIES.minimum_accountable_unit%TYPE;

973: PO_LOG.get_subprogram_base(D_PACKAGE_BASE,'getAmountDeliveredForHeader');
974: d_position NUMBER := 0;
975: l_return_val NUMBER := 0;
976: l_precision GL_CURRENCIES.precision%TYPE;
977: l_mau GL_CURRENCIES.minimum_accountable_unit%TYPE;
978: BEGIN
979:
980: IF PO_LOG.d_proc THEN
981: PO_LOG.proc_begin(d_mod,'p_header_id',p_header_id);

Line 2359: l_precision GL_CURRENCIES.precision%TYPE;

2355: d_position NUMBER := 0;
2356: l_return_val NUMBER := 0;
2357: l_header_id PO_HEADERS_ALL.po_header_id%TYPE;
2358: l_is_complex_work_po BOOLEAN := FALSE;
2359: l_precision GL_CURRENCIES.precision%TYPE;
2360: l_mau GL_CURRENCIES.minimum_accountable_unit%TYPE;
2361: BEGIN
2362:
2363: IF PO_LOG.d_proc THEN

Line 2360: l_mau GL_CURRENCIES.minimum_accountable_unit%TYPE;

2356: l_return_val NUMBER := 0;
2357: l_header_id PO_HEADERS_ALL.po_header_id%TYPE;
2358: l_is_complex_work_po BOOLEAN := FALSE;
2359: l_precision GL_CURRENCIES.precision%TYPE;
2360: l_mau GL_CURRENCIES.minimum_accountable_unit%TYPE;
2361: BEGIN
2362:
2363: IF PO_LOG.d_proc THEN
2364: PO_LOG.proc_begin(d_mod,'p_line_id',p_line_id);

Line 2982: l_doc_currency_code GL_CURRENCIES.currency_code%TYPE;

2978: d_mod CONSTANT VARCHAR2(100) :=
2979: PO_LOG.get_subprogram_base(D_PACKAGE_BASE,'get_order_totals_from_archive');
2980: d_position NUMBER := 0;
2981:
2982: l_doc_currency_code GL_CURRENCIES.currency_code%TYPE;
2983: BEGIN
2984:
2985: IF PO_LOG.d_proc THEN
2986: PO_LOG.proc_begin(d_mod,'p_doc_type',p_doc_type);

Line 3171: l_base_currency_code GL_CURRENCIES.currency_code%TYPE;

3167: l_distribution_id_tbl po_tbl_number;
3168: l_document_id NUMBER;
3169: l_document_id_tbl po_tbl_number;
3170: l_temp_table_key PO_DOCUMENT_TOTALS_GT.key%TYPE;
3171: l_base_currency_code GL_CURRENCIES.currency_code%TYPE;
3172: l_doc_currency_code GL_CURRENCIES.currency_code%TYPE;
3173: l_temp_table_row_count NUMBER;
3174:
3175: BEGIN

Line 3172: l_doc_currency_code GL_CURRENCIES.currency_code%TYPE;

3168: l_document_id NUMBER;
3169: l_document_id_tbl po_tbl_number;
3170: l_temp_table_key PO_DOCUMENT_TOTALS_GT.key%TYPE;
3171: l_base_currency_code GL_CURRENCIES.currency_code%TYPE;
3172: l_doc_currency_code GL_CURRENCIES.currency_code%TYPE;
3173: l_temp_table_row_count NUMBER;
3174:
3175: BEGIN
3176:

Line 3646: l_base_currency_code GL_CURRENCIES.currency_code%TYPE;

3642: d_mod CONSTANT VARCHAR2(100) :=
3643: PO_LOG.get_subprogram_base(D_PACKAGE_BASE,'prepare_temp_table_data');
3644: d_position NUMBER := 0;
3645:
3646: l_base_currency_code GL_CURRENCIES.currency_code%TYPE;
3647: l_doc_currency_code GL_CURRENCIES.currency_code%TYPE;
3648: l_precision GL_CURRENCIES.precision%TYPE;
3649: l_mau GL_CURRENCIES.minimum_accountable_unit%TYPE;
3650: BEGIN

Line 3647: l_doc_currency_code GL_CURRENCIES.currency_code%TYPE;

3643: PO_LOG.get_subprogram_base(D_PACKAGE_BASE,'prepare_temp_table_data');
3644: d_position NUMBER := 0;
3645:
3646: l_base_currency_code GL_CURRENCIES.currency_code%TYPE;
3647: l_doc_currency_code GL_CURRENCIES.currency_code%TYPE;
3648: l_precision GL_CURRENCIES.precision%TYPE;
3649: l_mau GL_CURRENCIES.minimum_accountable_unit%TYPE;
3650: BEGIN
3651:

Line 3648: l_precision GL_CURRENCIES.precision%TYPE;

3644: d_position NUMBER := 0;
3645:
3646: l_base_currency_code GL_CURRENCIES.currency_code%TYPE;
3647: l_doc_currency_code GL_CURRENCIES.currency_code%TYPE;
3648: l_precision GL_CURRENCIES.precision%TYPE;
3649: l_mau GL_CURRENCIES.minimum_accountable_unit%TYPE;
3650: BEGIN
3651:
3652: IF PO_LOG.d_proc THEN

Line 3649: l_mau GL_CURRENCIES.minimum_accountable_unit%TYPE;

3645:
3646: l_base_currency_code GL_CURRENCIES.currency_code%TYPE;
3647: l_doc_currency_code GL_CURRENCIES.currency_code%TYPE;
3648: l_precision GL_CURRENCIES.precision%TYPE;
3649: l_mau GL_CURRENCIES.minimum_accountable_unit%TYPE;
3650: BEGIN
3651:
3652: IF PO_LOG.d_proc THEN
3653: PO_LOG.proc_begin(d_mod,'p_temp_table_key',p_temp_table_key);