DBA Data[Home] [Help]

APPS.PO_DOCUMENT_TOTALS_PVT dependencies on GL_CURRENCIES

Line 187: l_precision GL_CURRENCIES.precision%TYPE;

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

Line 188: l_mau GL_CURRENCIES.minimum_accountable_unit%TYPE;

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

Line 509: l_precision GL_CURRENCIES.precision%TYPE;

505: d_mod CONSTANT VARCHAR2(100) :=
506: PO_LOG.get_subprogram_base(D_PACKAGE_BASE,'getAmountApprovedForLine');
507: d_position NUMBER := 0;
508: l_return_val NUMBER := 0;
509: l_precision GL_CURRENCIES.precision%TYPE;
510: l_mau GL_CURRENCIES.minimum_accountable_unit%TYPE;
511: BEGIN
512:
513: IF PO_LOG.d_proc THEN

Line 510: l_mau GL_CURRENCIES.minimum_accountable_unit%TYPE;

506: PO_LOG.get_subprogram_base(D_PACKAGE_BASE,'getAmountApprovedForLine');
507: d_position NUMBER := 0;
508: l_return_val NUMBER := 0;
509: l_precision GL_CURRENCIES.precision%TYPE;
510: l_mau GL_CURRENCIES.minimum_accountable_unit%TYPE;
511: BEGIN
512:
513: IF PO_LOG.d_proc THEN
514: PO_LOG.proc_begin(d_mod,'p_line_id',p_line_id);

Line 662: l_precision GL_CURRENCIES.precision%TYPE;

658: d_mod CONSTANT VARCHAR2(100) :=
659: PO_LOG.get_subprogram_base(D_PACKAGE_BASE,'getAmountApprovedForHeader');
660: d_position NUMBER := 0;
661: l_return_val NUMBER := 0;
662: l_precision GL_CURRENCIES.precision%TYPE;
663: l_mau GL_CURRENCIES.minimum_accountable_unit%TYPE;
664: BEGIN
665:
666: IF PO_LOG.d_proc THEN

Line 663: l_mau GL_CURRENCIES.minimum_accountable_unit%TYPE;

659: PO_LOG.get_subprogram_base(D_PACKAGE_BASE,'getAmountApprovedForHeader');
660: d_position NUMBER := 0;
661: l_return_val NUMBER := 0;
662: l_precision GL_CURRENCIES.precision%TYPE;
663: l_mau GL_CURRENCIES.minimum_accountable_unit%TYPE;
664: BEGIN
665:
666: IF PO_LOG.d_proc THEN
667: PO_LOG.proc_begin(d_mod,'p_header_id',p_header_id);

Line 818: l_precision GL_CURRENCIES.precision%TYPE;

814: d_mod CONSTANT VARCHAR2(100) :=
815: PO_LOG.get_subprogram_base(D_PACKAGE_BASE,'getAmountDeliveredForLine');
816: d_position NUMBER := 0;
817: l_return_val NUMBER := 0;
818: l_precision GL_CURRENCIES.precision%TYPE;
819: l_mau GL_CURRENCIES.minimum_accountable_unit%TYPE;
820: BEGIN
821:
822: IF PO_LOG.d_proc THEN

Line 819: l_mau GL_CURRENCIES.minimum_accountable_unit%TYPE;

815: PO_LOG.get_subprogram_base(D_PACKAGE_BASE,'getAmountDeliveredForLine');
816: d_position NUMBER := 0;
817: l_return_val NUMBER := 0;
818: l_precision GL_CURRENCIES.precision%TYPE;
819: l_mau GL_CURRENCIES.minimum_accountable_unit%TYPE;
820: BEGIN
821:
822: IF PO_LOG.d_proc THEN
823: PO_LOG.proc_begin(d_mod,'p_line_id',p_line_id);

Line 985: l_precision GL_CURRENCIES.precision%TYPE;

981: d_mod CONSTANT VARCHAR2(100) :=
982: PO_LOG.get_subprogram_base(D_PACKAGE_BASE,'getAmountDeliveredForHeader');
983: d_position NUMBER := 0;
984: l_return_val NUMBER := 0;
985: l_precision GL_CURRENCIES.precision%TYPE;
986: l_mau GL_CURRENCIES.minimum_accountable_unit%TYPE;
987: BEGIN
988:
989: IF PO_LOG.d_proc THEN

Line 986: l_mau GL_CURRENCIES.minimum_accountable_unit%TYPE;

982: PO_LOG.get_subprogram_base(D_PACKAGE_BASE,'getAmountDeliveredForHeader');
983: d_position NUMBER := 0;
984: l_return_val NUMBER := 0;
985: l_precision GL_CURRENCIES.precision%TYPE;
986: l_mau GL_CURRENCIES.minimum_accountable_unit%TYPE;
987: BEGIN
988:
989: IF PO_LOG.d_proc THEN
990: PO_LOG.proc_begin(d_mod,'p_header_id',p_header_id);

Line 2371: l_precision GL_CURRENCIES.precision%TYPE;

2367: d_position NUMBER := 0;
2368: l_return_val NUMBER := 0;
2369: l_header_id PO_HEADERS_ALL.po_header_id%TYPE;
2370: l_is_complex_work_po BOOLEAN := FALSE;
2371: l_precision GL_CURRENCIES.precision%TYPE;
2372: l_mau GL_CURRENCIES.minimum_accountable_unit%TYPE;
2373: BEGIN
2374:
2375: IF PO_LOG.d_proc THEN

Line 2372: l_mau GL_CURRENCIES.minimum_accountable_unit%TYPE;

2368: l_return_val NUMBER := 0;
2369: l_header_id PO_HEADERS_ALL.po_header_id%TYPE;
2370: l_is_complex_work_po BOOLEAN := FALSE;
2371: l_precision GL_CURRENCIES.precision%TYPE;
2372: l_mau GL_CURRENCIES.minimum_accountable_unit%TYPE;
2373: BEGIN
2374:
2375: IF PO_LOG.d_proc THEN
2376: PO_LOG.proc_begin(d_mod,'p_line_id',p_line_id);

Line 2611: l_precision GL_CURRENCIES.precision%TYPE;

2607: PO_LOG.get_subprogram_base(D_PACKAGE_BASE,'getEncumberedAmountForDist');
2608: d_position NUMBER := 0;
2609: l_return_val NUMBER := 0;
2610: l_amount_ordered NUMBER := 0;
2611: l_precision GL_CURRENCIES.precision%TYPE;
2612: l_mau GL_CURRENCIES.minimum_accountable_unit%TYPE;
2613: BEGIN
2614:
2615: IF PO_LOG.d_proc THEN

Line 2612: l_mau GL_CURRENCIES.minimum_accountable_unit%TYPE;

2608: d_position NUMBER := 0;
2609: l_return_val NUMBER := 0;
2610: l_amount_ordered NUMBER := 0;
2611: l_precision GL_CURRENCIES.precision%TYPE;
2612: l_mau GL_CURRENCIES.minimum_accountable_unit%TYPE;
2613: BEGIN
2614:
2615: IF PO_LOG.d_proc THEN
2616: PO_LOG.proc_begin(d_mod,'p_distribution_id ',p_distribution_id);

Line 3101: l_doc_currency_code GL_CURRENCIES.currency_code%TYPE;

3097: d_mod CONSTANT VARCHAR2(100) :=
3098: PO_LOG.get_subprogram_base(D_PACKAGE_BASE,'get_order_totals_from_archive');
3099: d_position NUMBER := 0;
3100:
3101: l_doc_currency_code GL_CURRENCIES.currency_code%TYPE;
3102: BEGIN
3103:
3104: IF PO_LOG.d_proc THEN
3105: PO_LOG.proc_begin(d_mod,'p_doc_type',p_doc_type);

Line 3290: l_base_currency_code GL_CURRENCIES.currency_code%TYPE;

3286: l_distribution_id_tbl po_tbl_number;
3287: l_document_id NUMBER;
3288: l_document_id_tbl po_tbl_number;
3289: l_temp_table_key PO_DOCUMENT_TOTALS_GT.key%TYPE;
3290: l_base_currency_code GL_CURRENCIES.currency_code%TYPE;
3291: l_doc_currency_code GL_CURRENCIES.currency_code%TYPE;
3292: l_temp_table_row_count NUMBER;
3293:
3294: BEGIN

Line 3291: l_doc_currency_code GL_CURRENCIES.currency_code%TYPE;

3287: l_document_id NUMBER;
3288: l_document_id_tbl po_tbl_number;
3289: l_temp_table_key PO_DOCUMENT_TOTALS_GT.key%TYPE;
3290: l_base_currency_code GL_CURRENCIES.currency_code%TYPE;
3291: l_doc_currency_code GL_CURRENCIES.currency_code%TYPE;
3292: l_temp_table_row_count NUMBER;
3293:
3294: BEGIN
3295:

Line 3765: l_base_currency_code GL_CURRENCIES.currency_code%TYPE;

3761: d_mod CONSTANT VARCHAR2(100) :=
3762: PO_LOG.get_subprogram_base(D_PACKAGE_BASE,'prepare_temp_table_data');
3763: d_position NUMBER := 0;
3764:
3765: l_base_currency_code GL_CURRENCIES.currency_code%TYPE;
3766: l_doc_currency_code GL_CURRENCIES.currency_code%TYPE;
3767: l_precision GL_CURRENCIES.precision%TYPE;
3768: l_mau GL_CURRENCIES.minimum_accountable_unit%TYPE;
3769: BEGIN

Line 3766: l_doc_currency_code GL_CURRENCIES.currency_code%TYPE;

3762: PO_LOG.get_subprogram_base(D_PACKAGE_BASE,'prepare_temp_table_data');
3763: d_position NUMBER := 0;
3764:
3765: l_base_currency_code GL_CURRENCIES.currency_code%TYPE;
3766: l_doc_currency_code GL_CURRENCIES.currency_code%TYPE;
3767: l_precision GL_CURRENCIES.precision%TYPE;
3768: l_mau GL_CURRENCIES.minimum_accountable_unit%TYPE;
3769: BEGIN
3770:

Line 3767: l_precision GL_CURRENCIES.precision%TYPE;

3763: d_position NUMBER := 0;
3764:
3765: l_base_currency_code GL_CURRENCIES.currency_code%TYPE;
3766: l_doc_currency_code GL_CURRENCIES.currency_code%TYPE;
3767: l_precision GL_CURRENCIES.precision%TYPE;
3768: l_mau GL_CURRENCIES.minimum_accountable_unit%TYPE;
3769: BEGIN
3770:
3771: IF PO_LOG.d_proc THEN

Line 3768: l_mau GL_CURRENCIES.minimum_accountable_unit%TYPE;

3764:
3765: l_base_currency_code GL_CURRENCIES.currency_code%TYPE;
3766: l_doc_currency_code GL_CURRENCIES.currency_code%TYPE;
3767: l_precision GL_CURRENCIES.precision%TYPE;
3768: l_mau GL_CURRENCIES.minimum_accountable_unit%TYPE;
3769: BEGIN
3770:
3771: IF PO_LOG.d_proc THEN
3772: PO_LOG.proc_begin(d_mod,'p_temp_table_key',p_temp_table_key);

Line 4340: l_precision GL_CURRENCIES.precision%TYPE;

4336: d_mod CONSTANT VARCHAR2(100) :=
4337: PO_LOG.get_subprogram_base(D_PACKAGE_BASE,'getAmountOrderedExclOptions');
4338: d_position NUMBER := 0;
4339: l_return_val NUMBER := 0;
4340: l_precision GL_CURRENCIES.precision%TYPE;
4341: l_mau GL_CURRENCIES.minimum_accountable_unit%TYPE;
4342: BEGIN
4343:
4344: IF PO_LOG.d_proc THEN

Line 4341: l_mau GL_CURRENCIES.minimum_accountable_unit%TYPE;

4337: PO_LOG.get_subprogram_base(D_PACKAGE_BASE,'getAmountOrderedExclOptions');
4338: d_position NUMBER := 0;
4339: l_return_val NUMBER := 0;
4340: l_precision GL_CURRENCIES.precision%TYPE;
4341: l_mau GL_CURRENCIES.minimum_accountable_unit%TYPE;
4342: BEGIN
4343:
4344: IF PO_LOG.d_proc THEN
4345: PO_LOG.proc_begin(d_mod,'p_doc_level',p_doc_level);

Line 4526: l_precision GL_CURRENCIES.precision%TYPE;

4522: d_mod CONSTANT VARCHAR2(100) :=
4523: PO_LOG.get_subprogram_base(D_PACKAGE_BASE,'getValueForExhibit');
4524: d_position NUMBER := 0;
4525: l_return_val NUMBER := 0;
4526: l_precision GL_CURRENCIES.precision%TYPE;
4527: l_mau GL_CURRENCIES.minimum_accountable_unit%TYPE;
4528: BEGIN
4529:
4530: IF PO_LOG.d_proc THEN

Line 4527: l_mau GL_CURRENCIES.minimum_accountable_unit%TYPE;

4523: PO_LOG.get_subprogram_base(D_PACKAGE_BASE,'getValueForExhibit');
4524: d_position NUMBER := 0;
4525: l_return_val NUMBER := 0;
4526: l_precision GL_CURRENCIES.precision%TYPE;
4527: l_mau GL_CURRENCIES.minimum_accountable_unit%TYPE;
4528: BEGIN
4529:
4530: IF PO_LOG.d_proc THEN
4531: PO_LOG.proc_begin(d_mod,'p_doc_id',p_doc_id);