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
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);
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
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);
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
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);
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
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);
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
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);
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
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);
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
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);
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);
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
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:
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
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:
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
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);
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
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);
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
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);