348: END LOOP;
349:
350: d_position := 130;
351:
352: x_processed_lines_count := PO_PDOI_PARAMS.g_out.processed_lines_count;
353: x_rejected_lines_count := PO_PDOI_PARAMS.g_out.rejected_lines_count;
354: x_err_tolerance_exceeded := PO_PDOI_PARAMS.g_out.err_tolerance_exceeded;
355:
356: d_position := 140;
349:
350: d_position := 130;
351:
352: x_processed_lines_count := PO_PDOI_PARAMS.g_out.processed_lines_count;
353: x_rejected_lines_count := PO_PDOI_PARAMS.g_out.rejected_lines_count;
354: x_err_tolerance_exceeded := PO_PDOI_PARAMS.g_out.err_tolerance_exceeded;
355:
356: d_position := 140;
357:
350: d_position := 130;
351:
352: x_processed_lines_count := PO_PDOI_PARAMS.g_out.processed_lines_count;
353: x_rejected_lines_count := PO_PDOI_PARAMS.g_out.rejected_lines_count;
354: x_err_tolerance_exceeded := PO_PDOI_PARAMS.g_out.err_tolerance_exceeded;
355:
356: d_position := 140;
357:
358: PO_PDOI_UTL.commit_work;
486: PO_LOG.proc_begin (d_module);
487: END IF;
488:
489: -- Setup g_request
490: PO_PDOI_PARAMS.g_request.calling_module := NVL(p_calling_module, PO_PDOI_CONSTANTS.g_call_mod_UNKNOWN);
491: PO_PDOI_PARAMS.g_request.validation_level := p_validation_level;
492: PO_PDOI_PARAMS.g_request.commit_work := p_commit;
493: PO_PDOI_PARAMS.g_request.batch_id := p_selected_batch_id;
494: PO_PDOI_PARAMS.g_request.batch_size := p_batch_size;
487: END IF;
488:
489: -- Setup g_request
490: PO_PDOI_PARAMS.g_request.calling_module := NVL(p_calling_module, PO_PDOI_CONSTANTS.g_call_mod_UNKNOWN);
491: PO_PDOI_PARAMS.g_request.validation_level := p_validation_level;
492: PO_PDOI_PARAMS.g_request.commit_work := p_commit;
493: PO_PDOI_PARAMS.g_request.batch_id := p_selected_batch_id;
494: PO_PDOI_PARAMS.g_request.batch_size := p_batch_size;
495: PO_PDOI_PARAMS.g_request.buyer_id := p_buyer_id;
488:
489: -- Setup g_request
490: PO_PDOI_PARAMS.g_request.calling_module := NVL(p_calling_module, PO_PDOI_CONSTANTS.g_call_mod_UNKNOWN);
491: PO_PDOI_PARAMS.g_request.validation_level := p_validation_level;
492: PO_PDOI_PARAMS.g_request.commit_work := p_commit;
493: PO_PDOI_PARAMS.g_request.batch_id := p_selected_batch_id;
494: PO_PDOI_PARAMS.g_request.batch_size := p_batch_size;
495: PO_PDOI_PARAMS.g_request.buyer_id := p_buyer_id;
496: PO_PDOI_PARAMS.g_request.document_type := p_document_type;
489: -- Setup g_request
490: PO_PDOI_PARAMS.g_request.calling_module := NVL(p_calling_module, PO_PDOI_CONSTANTS.g_call_mod_UNKNOWN);
491: PO_PDOI_PARAMS.g_request.validation_level := p_validation_level;
492: PO_PDOI_PARAMS.g_request.commit_work := p_commit;
493: PO_PDOI_PARAMS.g_request.batch_id := p_selected_batch_id;
494: PO_PDOI_PARAMS.g_request.batch_size := p_batch_size;
495: PO_PDOI_PARAMS.g_request.buyer_id := p_buyer_id;
496: PO_PDOI_PARAMS.g_request.document_type := p_document_type;
497: PO_PDOI_PARAMS.g_request.document_subtype := p_document_subtype;
490: PO_PDOI_PARAMS.g_request.calling_module := NVL(p_calling_module, PO_PDOI_CONSTANTS.g_call_mod_UNKNOWN);
491: PO_PDOI_PARAMS.g_request.validation_level := p_validation_level;
492: PO_PDOI_PARAMS.g_request.commit_work := p_commit;
493: PO_PDOI_PARAMS.g_request.batch_id := p_selected_batch_id;
494: PO_PDOI_PARAMS.g_request.batch_size := p_batch_size;
495: PO_PDOI_PARAMS.g_request.buyer_id := p_buyer_id;
496: PO_PDOI_PARAMS.g_request.document_type := p_document_type;
497: PO_PDOI_PARAMS.g_request.document_subtype := p_document_subtype;
498: PO_PDOI_PARAMS.g_request.create_items := p_create_items;
491: PO_PDOI_PARAMS.g_request.validation_level := p_validation_level;
492: PO_PDOI_PARAMS.g_request.commit_work := p_commit;
493: PO_PDOI_PARAMS.g_request.batch_id := p_selected_batch_id;
494: PO_PDOI_PARAMS.g_request.batch_size := p_batch_size;
495: PO_PDOI_PARAMS.g_request.buyer_id := p_buyer_id;
496: PO_PDOI_PARAMS.g_request.document_type := p_document_type;
497: PO_PDOI_PARAMS.g_request.document_subtype := p_document_subtype;
498: PO_PDOI_PARAMS.g_request.create_items := p_create_items;
499: PO_PDOI_PARAMS.g_request.create_sourcing_rules_flag := p_create_sourcing_rules_flag;
492: PO_PDOI_PARAMS.g_request.commit_work := p_commit;
493: PO_PDOI_PARAMS.g_request.batch_id := p_selected_batch_id;
494: PO_PDOI_PARAMS.g_request.batch_size := p_batch_size;
495: PO_PDOI_PARAMS.g_request.buyer_id := p_buyer_id;
496: PO_PDOI_PARAMS.g_request.document_type := p_document_type;
497: PO_PDOI_PARAMS.g_request.document_subtype := p_document_subtype;
498: PO_PDOI_PARAMS.g_request.create_items := p_create_items;
499: PO_PDOI_PARAMS.g_request.create_sourcing_rules_flag := p_create_sourcing_rules_flag;
500: PO_PDOI_PARAMS.g_request.rel_gen_method := p_rel_gen_method;
493: PO_PDOI_PARAMS.g_request.batch_id := p_selected_batch_id;
494: PO_PDOI_PARAMS.g_request.batch_size := p_batch_size;
495: PO_PDOI_PARAMS.g_request.buyer_id := p_buyer_id;
496: PO_PDOI_PARAMS.g_request.document_type := p_document_type;
497: PO_PDOI_PARAMS.g_request.document_subtype := p_document_subtype;
498: PO_PDOI_PARAMS.g_request.create_items := p_create_items;
499: PO_PDOI_PARAMS.g_request.create_sourcing_rules_flag := p_create_sourcing_rules_flag;
500: PO_PDOI_PARAMS.g_request.rel_gen_method := p_rel_gen_method;
501: PO_PDOI_PARAMS.g_request.sourcing_level := p_sourcing_level;
494: PO_PDOI_PARAMS.g_request.batch_size := p_batch_size;
495: PO_PDOI_PARAMS.g_request.buyer_id := p_buyer_id;
496: PO_PDOI_PARAMS.g_request.document_type := p_document_type;
497: PO_PDOI_PARAMS.g_request.document_subtype := p_document_subtype;
498: PO_PDOI_PARAMS.g_request.create_items := p_create_items;
499: PO_PDOI_PARAMS.g_request.create_sourcing_rules_flag := p_create_sourcing_rules_flag;
500: PO_PDOI_PARAMS.g_request.rel_gen_method := p_rel_gen_method;
501: PO_PDOI_PARAMS.g_request.sourcing_level := p_sourcing_level;
502: PO_PDOI_PARAMS.g_request.sourcing_inv_org_id := p_sourcing_inv_org_id;
495: PO_PDOI_PARAMS.g_request.buyer_id := p_buyer_id;
496: PO_PDOI_PARAMS.g_request.document_type := p_document_type;
497: PO_PDOI_PARAMS.g_request.document_subtype := p_document_subtype;
498: PO_PDOI_PARAMS.g_request.create_items := p_create_items;
499: PO_PDOI_PARAMS.g_request.create_sourcing_rules_flag := p_create_sourcing_rules_flag;
500: PO_PDOI_PARAMS.g_request.rel_gen_method := p_rel_gen_method;
501: PO_PDOI_PARAMS.g_request.sourcing_level := p_sourcing_level;
502: PO_PDOI_PARAMS.g_request.sourcing_inv_org_id := p_sourcing_inv_org_id;
503: PO_PDOI_PARAMS.g_request.approved_status := p_approved_status;
496: PO_PDOI_PARAMS.g_request.document_type := p_document_type;
497: PO_PDOI_PARAMS.g_request.document_subtype := p_document_subtype;
498: PO_PDOI_PARAMS.g_request.create_items := p_create_items;
499: PO_PDOI_PARAMS.g_request.create_sourcing_rules_flag := p_create_sourcing_rules_flag;
500: PO_PDOI_PARAMS.g_request.rel_gen_method := p_rel_gen_method;
501: PO_PDOI_PARAMS.g_request.sourcing_level := p_sourcing_level;
502: PO_PDOI_PARAMS.g_request.sourcing_inv_org_id := p_sourcing_inv_org_id;
503: PO_PDOI_PARAMS.g_request.approved_status := p_approved_status;
504: PO_PDOI_PARAMS.g_request.process_code := p_process_code;
497: PO_PDOI_PARAMS.g_request.document_subtype := p_document_subtype;
498: PO_PDOI_PARAMS.g_request.create_items := p_create_items;
499: PO_PDOI_PARAMS.g_request.create_sourcing_rules_flag := p_create_sourcing_rules_flag;
500: PO_PDOI_PARAMS.g_request.rel_gen_method := p_rel_gen_method;
501: PO_PDOI_PARAMS.g_request.sourcing_level := p_sourcing_level;
502: PO_PDOI_PARAMS.g_request.sourcing_inv_org_id := p_sourcing_inv_org_id;
503: PO_PDOI_PARAMS.g_request.approved_status := p_approved_status;
504: PO_PDOI_PARAMS.g_request.process_code := p_process_code;
505: PO_PDOI_PARAMS.g_request.interface_header_id := p_interface_header_id;
498: PO_PDOI_PARAMS.g_request.create_items := p_create_items;
499: PO_PDOI_PARAMS.g_request.create_sourcing_rules_flag := p_create_sourcing_rules_flag;
500: PO_PDOI_PARAMS.g_request.rel_gen_method := p_rel_gen_method;
501: PO_PDOI_PARAMS.g_request.sourcing_level := p_sourcing_level;
502: PO_PDOI_PARAMS.g_request.sourcing_inv_org_id := p_sourcing_inv_org_id;
503: PO_PDOI_PARAMS.g_request.approved_status := p_approved_status;
504: PO_PDOI_PARAMS.g_request.process_code := p_process_code;
505: PO_PDOI_PARAMS.g_request.interface_header_id := p_interface_header_id;
506: PO_PDOI_PARAMS.g_request.org_id := p_org_id;
499: PO_PDOI_PARAMS.g_request.create_sourcing_rules_flag := p_create_sourcing_rules_flag;
500: PO_PDOI_PARAMS.g_request.rel_gen_method := p_rel_gen_method;
501: PO_PDOI_PARAMS.g_request.sourcing_level := p_sourcing_level;
502: PO_PDOI_PARAMS.g_request.sourcing_inv_org_id := p_sourcing_inv_org_id;
503: PO_PDOI_PARAMS.g_request.approved_status := p_approved_status;
504: PO_PDOI_PARAMS.g_request.process_code := p_process_code;
505: PO_PDOI_PARAMS.g_request.interface_header_id := p_interface_header_id;
506: PO_PDOI_PARAMS.g_request.org_id := p_org_id;
507: PO_PDOI_PARAMS.g_request.ga_flag := p_ga_flag;
500: PO_PDOI_PARAMS.g_request.rel_gen_method := p_rel_gen_method;
501: PO_PDOI_PARAMS.g_request.sourcing_level := p_sourcing_level;
502: PO_PDOI_PARAMS.g_request.sourcing_inv_org_id := p_sourcing_inv_org_id;
503: PO_PDOI_PARAMS.g_request.approved_status := p_approved_status;
504: PO_PDOI_PARAMS.g_request.process_code := p_process_code;
505: PO_PDOI_PARAMS.g_request.interface_header_id := p_interface_header_id;
506: PO_PDOI_PARAMS.g_request.org_id := p_org_id;
507: PO_PDOI_PARAMS.g_request.ga_flag := p_ga_flag;
508: PO_PDOI_PARAMS.g_request.submit_dft_flag := p_submit_dft_flag;
501: PO_PDOI_PARAMS.g_request.sourcing_level := p_sourcing_level;
502: PO_PDOI_PARAMS.g_request.sourcing_inv_org_id := p_sourcing_inv_org_id;
503: PO_PDOI_PARAMS.g_request.approved_status := p_approved_status;
504: PO_PDOI_PARAMS.g_request.process_code := p_process_code;
505: PO_PDOI_PARAMS.g_request.interface_header_id := p_interface_header_id;
506: PO_PDOI_PARAMS.g_request.org_id := p_org_id;
507: PO_PDOI_PARAMS.g_request.ga_flag := p_ga_flag;
508: PO_PDOI_PARAMS.g_request.submit_dft_flag := p_submit_dft_flag;
509: PO_PDOI_PARAMS.g_request.role := p_role;
502: PO_PDOI_PARAMS.g_request.sourcing_inv_org_id := p_sourcing_inv_org_id;
503: PO_PDOI_PARAMS.g_request.approved_status := p_approved_status;
504: PO_PDOI_PARAMS.g_request.process_code := p_process_code;
505: PO_PDOI_PARAMS.g_request.interface_header_id := p_interface_header_id;
506: PO_PDOI_PARAMS.g_request.org_id := p_org_id;
507: PO_PDOI_PARAMS.g_request.ga_flag := p_ga_flag;
508: PO_PDOI_PARAMS.g_request.submit_dft_flag := p_submit_dft_flag;
509: PO_PDOI_PARAMS.g_request.role := p_role;
510: PO_PDOI_PARAMS.g_request.catalog_to_expire := p_catalog_to_expire;
503: PO_PDOI_PARAMS.g_request.approved_status := p_approved_status;
504: PO_PDOI_PARAMS.g_request.process_code := p_process_code;
505: PO_PDOI_PARAMS.g_request.interface_header_id := p_interface_header_id;
506: PO_PDOI_PARAMS.g_request.org_id := p_org_id;
507: PO_PDOI_PARAMS.g_request.ga_flag := p_ga_flag;
508: PO_PDOI_PARAMS.g_request.submit_dft_flag := p_submit_dft_flag;
509: PO_PDOI_PARAMS.g_request.role := p_role;
510: PO_PDOI_PARAMS.g_request.catalog_to_expire := p_catalog_to_expire;
511: PO_PDOI_PARAMS.g_request.err_lines_tolerance := p_err_lines_tolerance;
504: PO_PDOI_PARAMS.g_request.process_code := p_process_code;
505: PO_PDOI_PARAMS.g_request.interface_header_id := p_interface_header_id;
506: PO_PDOI_PARAMS.g_request.org_id := p_org_id;
507: PO_PDOI_PARAMS.g_request.ga_flag := p_ga_flag;
508: PO_PDOI_PARAMS.g_request.submit_dft_flag := p_submit_dft_flag;
509: PO_PDOI_PARAMS.g_request.role := p_role;
510: PO_PDOI_PARAMS.g_request.catalog_to_expire := p_catalog_to_expire;
511: PO_PDOI_PARAMS.g_request.err_lines_tolerance := p_err_lines_tolerance;
512:
505: PO_PDOI_PARAMS.g_request.interface_header_id := p_interface_header_id;
506: PO_PDOI_PARAMS.g_request.org_id := p_org_id;
507: PO_PDOI_PARAMS.g_request.ga_flag := p_ga_flag;
508: PO_PDOI_PARAMS.g_request.submit_dft_flag := p_submit_dft_flag;
509: PO_PDOI_PARAMS.g_request.role := p_role;
510: PO_PDOI_PARAMS.g_request.catalog_to_expire := p_catalog_to_expire;
511: PO_PDOI_PARAMS.g_request.err_lines_tolerance := p_err_lines_tolerance;
512:
513: d_position := 10;
506: PO_PDOI_PARAMS.g_request.org_id := p_org_id;
507: PO_PDOI_PARAMS.g_request.ga_flag := p_ga_flag;
508: PO_PDOI_PARAMS.g_request.submit_dft_flag := p_submit_dft_flag;
509: PO_PDOI_PARAMS.g_request.role := p_role;
510: PO_PDOI_PARAMS.g_request.catalog_to_expire := p_catalog_to_expire;
511: PO_PDOI_PARAMS.g_request.err_lines_tolerance := p_err_lines_tolerance;
512:
513: d_position := 10;
514:
507: PO_PDOI_PARAMS.g_request.ga_flag := p_ga_flag;
508: PO_PDOI_PARAMS.g_request.submit_dft_flag := p_submit_dft_flag;
509: PO_PDOI_PARAMS.g_request.role := p_role;
510: PO_PDOI_PARAMS.g_request.catalog_to_expire := p_catalog_to_expire;
511: PO_PDOI_PARAMS.g_request.err_lines_tolerance := p_err_lines_tolerance;
512:
513: d_position := 10;
514:
515: -- Setup g_sys
525:
526: d_position := 40;
527: -- default processing_id
528: SELECT PO_PDOI_PROCESSING_ID_S.nextval
529: INTO PO_PDOI_PARAMS.g_processing_id
530: FROM DUAL;
531:
532: IF (PO_LOG.d_stmt) THEN
533: PO_LOG.stmt (d_module, d_position, 'g_processsing_id',
530: FROM DUAL;
531:
532: IF (PO_LOG.d_stmt) THEN
533: PO_LOG.stmt (d_module, d_position, 'g_processsing_id',
534: PO_PDOI_PARAMS.g_processing_id);
535: END IF;
536:
537: d_position := 50;
538: -- initializing tracking variables for PDOI
535: END IF;
536:
537: d_position := 50;
538: -- initializing tracking variables for PDOI
539: PO_PDOI_PARAMS.g_original_doc_processed := FND_API.G_FALSE;
540: PO_PDOI_PARAMS.g_current_round_num := 0;
541:
542: -- setup g_out
543: PO_PDOI_PARAMS.g_out.processed_lines_count := 0;
536:
537: d_position := 50;
538: -- initializing tracking variables for PDOI
539: PO_PDOI_PARAMS.g_original_doc_processed := FND_API.G_FALSE;
540: PO_PDOI_PARAMS.g_current_round_num := 0;
541:
542: -- setup g_out
543: PO_PDOI_PARAMS.g_out.processed_lines_count := 0;
544: PO_PDOI_PARAMS.g_out.rejected_lines_count := 0;
539: PO_PDOI_PARAMS.g_original_doc_processed := FND_API.G_FALSE;
540: PO_PDOI_PARAMS.g_current_round_num := 0;
541:
542: -- setup g_out
543: PO_PDOI_PARAMS.g_out.processed_lines_count := 0;
544: PO_PDOI_PARAMS.g_out.rejected_lines_count := 0;
545: PO_PDOI_PARAMS.g_out.err_tolerance_exceeded := FND_API.G_FALSE;
546:
547: IF (PO_LOG.d_proc) THEN
540: PO_PDOI_PARAMS.g_current_round_num := 0;
541:
542: -- setup g_out
543: PO_PDOI_PARAMS.g_out.processed_lines_count := 0;
544: PO_PDOI_PARAMS.g_out.rejected_lines_count := 0;
545: PO_PDOI_PARAMS.g_out.err_tolerance_exceeded := FND_API.G_FALSE;
546:
547: IF (PO_LOG.d_proc) THEN
548: PO_LOG.proc_end (d_module);
541:
542: -- setup g_out
543: PO_PDOI_PARAMS.g_out.processed_lines_count := 0;
544: PO_PDOI_PARAMS.g_out.rejected_lines_count := 0;
545: PO_PDOI_PARAMS.g_out.err_tolerance_exceeded := FND_API.G_FALSE;
546:
547: IF (PO_LOG.d_proc) THEN
548: PO_LOG.proc_end (d_module);
549: END IF;
561: --Start of Comments
562: --Name: init_sys_parameters
563: --Function:
564: -- Derive system paramters and populate the same to
565: -- PO_PDOI_PARAMS.g_sys record
566: --Parameters:
567: --IN:
568: --IN OUT:
569: --OUT:
620: END IF;
621:
622: -- po and financials system parameters
623: PO_CORE_S.get_po_parameters
624: ( x_currency_code => PO_PDOI_PARAMS.g_sys.currency_code,
625: x_coa_id => PO_PDOI_PARAMS.g_sys.coa_id,
626: x_po_encumberance_flag => PO_PDOI_PARAMS.g_sys.po_encumbrance_flag,
627: x_req_encumberance_flag => PO_PDOI_PARAMS.g_sys.req_encumbrance_flag,
628: x_sob_id => PO_PDOI_PARAMS.g_sys.sob_id,
621:
622: -- po and financials system parameters
623: PO_CORE_S.get_po_parameters
624: ( x_currency_code => PO_PDOI_PARAMS.g_sys.currency_code,
625: x_coa_id => PO_PDOI_PARAMS.g_sys.coa_id,
626: x_po_encumberance_flag => PO_PDOI_PARAMS.g_sys.po_encumbrance_flag,
627: x_req_encumberance_flag => PO_PDOI_PARAMS.g_sys.req_encumbrance_flag,
628: x_sob_id => PO_PDOI_PARAMS.g_sys.sob_id,
629: x_ship_to_location_id => PO_PDOI_PARAMS.g_sys.ship_to_location_id,
622: -- po and financials system parameters
623: PO_CORE_S.get_po_parameters
624: ( x_currency_code => PO_PDOI_PARAMS.g_sys.currency_code,
625: x_coa_id => PO_PDOI_PARAMS.g_sys.coa_id,
626: x_po_encumberance_flag => PO_PDOI_PARAMS.g_sys.po_encumbrance_flag,
627: x_req_encumberance_flag => PO_PDOI_PARAMS.g_sys.req_encumbrance_flag,
628: x_sob_id => PO_PDOI_PARAMS.g_sys.sob_id,
629: x_ship_to_location_id => PO_PDOI_PARAMS.g_sys.ship_to_location_id,
630: x_bill_to_location_id => PO_PDOI_PARAMS.g_sys.bill_to_location_id,
623: PO_CORE_S.get_po_parameters
624: ( x_currency_code => PO_PDOI_PARAMS.g_sys.currency_code,
625: x_coa_id => PO_PDOI_PARAMS.g_sys.coa_id,
626: x_po_encumberance_flag => PO_PDOI_PARAMS.g_sys.po_encumbrance_flag,
627: x_req_encumberance_flag => PO_PDOI_PARAMS.g_sys.req_encumbrance_flag,
628: x_sob_id => PO_PDOI_PARAMS.g_sys.sob_id,
629: x_ship_to_location_id => PO_PDOI_PARAMS.g_sys.ship_to_location_id,
630: x_bill_to_location_id => PO_PDOI_PARAMS.g_sys.bill_to_location_id,
631: x_fob_lookup_code => PO_PDOI_PARAMS.g_sys.fob_lookup_code,
624: ( x_currency_code => PO_PDOI_PARAMS.g_sys.currency_code,
625: x_coa_id => PO_PDOI_PARAMS.g_sys.coa_id,
626: x_po_encumberance_flag => PO_PDOI_PARAMS.g_sys.po_encumbrance_flag,
627: x_req_encumberance_flag => PO_PDOI_PARAMS.g_sys.req_encumbrance_flag,
628: x_sob_id => PO_PDOI_PARAMS.g_sys.sob_id,
629: x_ship_to_location_id => PO_PDOI_PARAMS.g_sys.ship_to_location_id,
630: x_bill_to_location_id => PO_PDOI_PARAMS.g_sys.bill_to_location_id,
631: x_fob_lookup_code => PO_PDOI_PARAMS.g_sys.fob_lookup_code,
632: x_freight_terms_lookup_code => PO_PDOI_PARAMS.g_sys.freight_terms_lookup_code,
625: x_coa_id => PO_PDOI_PARAMS.g_sys.coa_id,
626: x_po_encumberance_flag => PO_PDOI_PARAMS.g_sys.po_encumbrance_flag,
627: x_req_encumberance_flag => PO_PDOI_PARAMS.g_sys.req_encumbrance_flag,
628: x_sob_id => PO_PDOI_PARAMS.g_sys.sob_id,
629: x_ship_to_location_id => PO_PDOI_PARAMS.g_sys.ship_to_location_id,
630: x_bill_to_location_id => PO_PDOI_PARAMS.g_sys.bill_to_location_id,
631: x_fob_lookup_code => PO_PDOI_PARAMS.g_sys.fob_lookup_code,
632: x_freight_terms_lookup_code => PO_PDOI_PARAMS.g_sys.freight_terms_lookup_code,
633: x_terms_id => PO_PDOI_PARAMS.g_sys.terms_id,
626: x_po_encumberance_flag => PO_PDOI_PARAMS.g_sys.po_encumbrance_flag,
627: x_req_encumberance_flag => PO_PDOI_PARAMS.g_sys.req_encumbrance_flag,
628: x_sob_id => PO_PDOI_PARAMS.g_sys.sob_id,
629: x_ship_to_location_id => PO_PDOI_PARAMS.g_sys.ship_to_location_id,
630: x_bill_to_location_id => PO_PDOI_PARAMS.g_sys.bill_to_location_id,
631: x_fob_lookup_code => PO_PDOI_PARAMS.g_sys.fob_lookup_code,
632: x_freight_terms_lookup_code => PO_PDOI_PARAMS.g_sys.freight_terms_lookup_code,
633: x_terms_id => PO_PDOI_PARAMS.g_sys.terms_id,
634: x_default_rate_type => PO_PDOI_PARAMS.g_sys.default_rate_type,
627: x_req_encumberance_flag => PO_PDOI_PARAMS.g_sys.req_encumbrance_flag,
628: x_sob_id => PO_PDOI_PARAMS.g_sys.sob_id,
629: x_ship_to_location_id => PO_PDOI_PARAMS.g_sys.ship_to_location_id,
630: x_bill_to_location_id => PO_PDOI_PARAMS.g_sys.bill_to_location_id,
631: x_fob_lookup_code => PO_PDOI_PARAMS.g_sys.fob_lookup_code,
632: x_freight_terms_lookup_code => PO_PDOI_PARAMS.g_sys.freight_terms_lookup_code,
633: x_terms_id => PO_PDOI_PARAMS.g_sys.terms_id,
634: x_default_rate_type => PO_PDOI_PARAMS.g_sys.default_rate_type,
635: x_taxable_flag => PO_PDOI_PARAMS.g_sys.taxable_flag,
628: x_sob_id => PO_PDOI_PARAMS.g_sys.sob_id,
629: x_ship_to_location_id => PO_PDOI_PARAMS.g_sys.ship_to_location_id,
630: x_bill_to_location_id => PO_PDOI_PARAMS.g_sys.bill_to_location_id,
631: x_fob_lookup_code => PO_PDOI_PARAMS.g_sys.fob_lookup_code,
632: x_freight_terms_lookup_code => PO_PDOI_PARAMS.g_sys.freight_terms_lookup_code,
633: x_terms_id => PO_PDOI_PARAMS.g_sys.terms_id,
634: x_default_rate_type => PO_PDOI_PARAMS.g_sys.default_rate_type,
635: x_taxable_flag => PO_PDOI_PARAMS.g_sys.taxable_flag,
636: x_receiving_flag => PO_PDOI_PARAMS.g_sys.receiving_flag,
629: x_ship_to_location_id => PO_PDOI_PARAMS.g_sys.ship_to_location_id,
630: x_bill_to_location_id => PO_PDOI_PARAMS.g_sys.bill_to_location_id,
631: x_fob_lookup_code => PO_PDOI_PARAMS.g_sys.fob_lookup_code,
632: x_freight_terms_lookup_code => PO_PDOI_PARAMS.g_sys.freight_terms_lookup_code,
633: x_terms_id => PO_PDOI_PARAMS.g_sys.terms_id,
634: x_default_rate_type => PO_PDOI_PARAMS.g_sys.default_rate_type,
635: x_taxable_flag => PO_PDOI_PARAMS.g_sys.taxable_flag,
636: x_receiving_flag => PO_PDOI_PARAMS.g_sys.receiving_flag,
637: x_enforce_buyer_name_flag => l_enforce_buyer_name,
630: x_bill_to_location_id => PO_PDOI_PARAMS.g_sys.bill_to_location_id,
631: x_fob_lookup_code => PO_PDOI_PARAMS.g_sys.fob_lookup_code,
632: x_freight_terms_lookup_code => PO_PDOI_PARAMS.g_sys.freight_terms_lookup_code,
633: x_terms_id => PO_PDOI_PARAMS.g_sys.terms_id,
634: x_default_rate_type => PO_PDOI_PARAMS.g_sys.default_rate_type,
635: x_taxable_flag => PO_PDOI_PARAMS.g_sys.taxable_flag,
636: x_receiving_flag => PO_PDOI_PARAMS.g_sys.receiving_flag,
637: x_enforce_buyer_name_flag => l_enforce_buyer_name,
638: x_enforce_buyer_auth_flag => l_enforce_buyer_auth_flag,
631: x_fob_lookup_code => PO_PDOI_PARAMS.g_sys.fob_lookup_code,
632: x_freight_terms_lookup_code => PO_PDOI_PARAMS.g_sys.freight_terms_lookup_code,
633: x_terms_id => PO_PDOI_PARAMS.g_sys.terms_id,
634: x_default_rate_type => PO_PDOI_PARAMS.g_sys.default_rate_type,
635: x_taxable_flag => PO_PDOI_PARAMS.g_sys.taxable_flag,
636: x_receiving_flag => PO_PDOI_PARAMS.g_sys.receiving_flag,
637: x_enforce_buyer_name_flag => l_enforce_buyer_name,
638: x_enforce_buyer_auth_flag => l_enforce_buyer_auth_flag,
639: x_line_type_id => PO_PDOI_PARAMS.g_sys.line_type_id,
632: x_freight_terms_lookup_code => PO_PDOI_PARAMS.g_sys.freight_terms_lookup_code,
633: x_terms_id => PO_PDOI_PARAMS.g_sys.terms_id,
634: x_default_rate_type => PO_PDOI_PARAMS.g_sys.default_rate_type,
635: x_taxable_flag => PO_PDOI_PARAMS.g_sys.taxable_flag,
636: x_receiving_flag => PO_PDOI_PARAMS.g_sys.receiving_flag,
637: x_enforce_buyer_name_flag => l_enforce_buyer_name,
638: x_enforce_buyer_auth_flag => l_enforce_buyer_auth_flag,
639: x_line_type_id => PO_PDOI_PARAMS.g_sys.line_type_id,
640: x_manual_po_num_type => PO_PDOI_PARAMS.g_sys.manual_po_num_type,
635: x_taxable_flag => PO_PDOI_PARAMS.g_sys.taxable_flag,
636: x_receiving_flag => PO_PDOI_PARAMS.g_sys.receiving_flag,
637: x_enforce_buyer_name_flag => l_enforce_buyer_name,
638: x_enforce_buyer_auth_flag => l_enforce_buyer_auth_flag,
639: x_line_type_id => PO_PDOI_PARAMS.g_sys.line_type_id,
640: x_manual_po_num_type => PO_PDOI_PARAMS.g_sys.manual_po_num_type,
641: x_po_num_code => PO_PDOI_PARAMS.g_sys.user_defined_po_num_code,
642: x_price_lookup_code => PO_PDOI_PARAMS.g_sys.price_type_lookup_code,
643: x_invoice_close_tolerance => PO_PDOI_PARAMS.g_sys.invoice_close_tolerance,
636: x_receiving_flag => PO_PDOI_PARAMS.g_sys.receiving_flag,
637: x_enforce_buyer_name_flag => l_enforce_buyer_name,
638: x_enforce_buyer_auth_flag => l_enforce_buyer_auth_flag,
639: x_line_type_id => PO_PDOI_PARAMS.g_sys.line_type_id,
640: x_manual_po_num_type => PO_PDOI_PARAMS.g_sys.manual_po_num_type,
641: x_po_num_code => PO_PDOI_PARAMS.g_sys.user_defined_po_num_code,
642: x_price_lookup_code => PO_PDOI_PARAMS.g_sys.price_type_lookup_code,
643: x_invoice_close_tolerance => PO_PDOI_PARAMS.g_sys.invoice_close_tolerance,
644: x_receive_close_tolerance => PO_PDOI_PARAMS.g_sys.receive_close_tolerance,
637: x_enforce_buyer_name_flag => l_enforce_buyer_name,
638: x_enforce_buyer_auth_flag => l_enforce_buyer_auth_flag,
639: x_line_type_id => PO_PDOI_PARAMS.g_sys.line_type_id,
640: x_manual_po_num_type => PO_PDOI_PARAMS.g_sys.manual_po_num_type,
641: x_po_num_code => PO_PDOI_PARAMS.g_sys.user_defined_po_num_code,
642: x_price_lookup_code => PO_PDOI_PARAMS.g_sys.price_type_lookup_code,
643: x_invoice_close_tolerance => PO_PDOI_PARAMS.g_sys.invoice_close_tolerance,
644: x_receive_close_tolerance => PO_PDOI_PARAMS.g_sys.receive_close_tolerance,
645: x_security_structure_id => l_security_structure_id,
638: x_enforce_buyer_auth_flag => l_enforce_buyer_auth_flag,
639: x_line_type_id => PO_PDOI_PARAMS.g_sys.line_type_id,
640: x_manual_po_num_type => PO_PDOI_PARAMS.g_sys.manual_po_num_type,
641: x_po_num_code => PO_PDOI_PARAMS.g_sys.user_defined_po_num_code,
642: x_price_lookup_code => PO_PDOI_PARAMS.g_sys.price_type_lookup_code,
643: x_invoice_close_tolerance => PO_PDOI_PARAMS.g_sys.invoice_close_tolerance,
644: x_receive_close_tolerance => PO_PDOI_PARAMS.g_sys.receive_close_tolerance,
645: x_security_structure_id => l_security_structure_id,
646: x_expense_accrual_code => PO_PDOI_PARAMS.g_sys.expense_accrual_code,
639: x_line_type_id => PO_PDOI_PARAMS.g_sys.line_type_id,
640: x_manual_po_num_type => PO_PDOI_PARAMS.g_sys.manual_po_num_type,
641: x_po_num_code => PO_PDOI_PARAMS.g_sys.user_defined_po_num_code,
642: x_price_lookup_code => PO_PDOI_PARAMS.g_sys.price_type_lookup_code,
643: x_invoice_close_tolerance => PO_PDOI_PARAMS.g_sys.invoice_close_tolerance,
644: x_receive_close_tolerance => PO_PDOI_PARAMS.g_sys.receive_close_tolerance,
645: x_security_structure_id => l_security_structure_id,
646: x_expense_accrual_code => PO_PDOI_PARAMS.g_sys.expense_accrual_code,
647: x_inv_org_id => PO_PDOI_PARAMS.g_sys.def_inv_org_id,
640: x_manual_po_num_type => PO_PDOI_PARAMS.g_sys.manual_po_num_type,
641: x_po_num_code => PO_PDOI_PARAMS.g_sys.user_defined_po_num_code,
642: x_price_lookup_code => PO_PDOI_PARAMS.g_sys.price_type_lookup_code,
643: x_invoice_close_tolerance => PO_PDOI_PARAMS.g_sys.invoice_close_tolerance,
644: x_receive_close_tolerance => PO_PDOI_PARAMS.g_sys.receive_close_tolerance,
645: x_security_structure_id => l_security_structure_id,
646: x_expense_accrual_code => PO_PDOI_PARAMS.g_sys.expense_accrual_code,
647: x_inv_org_id => PO_PDOI_PARAMS.g_sys.def_inv_org_id,
648: x_rev_sort_ordering => l_rev_sort_ordering,
642: x_price_lookup_code => PO_PDOI_PARAMS.g_sys.price_type_lookup_code,
643: x_invoice_close_tolerance => PO_PDOI_PARAMS.g_sys.invoice_close_tolerance,
644: x_receive_close_tolerance => PO_PDOI_PARAMS.g_sys.receive_close_tolerance,
645: x_security_structure_id => l_security_structure_id,
646: x_expense_accrual_code => PO_PDOI_PARAMS.g_sys.expense_accrual_code,
647: x_inv_org_id => PO_PDOI_PARAMS.g_sys.def_inv_org_id,
648: x_rev_sort_ordering => l_rev_sort_ordering,
649: x_min_rel_amount => PO_PDOI_PARAMS.g_sys.min_rel_amount,
650: x_notify_blanket_flag => l_notify_blanket_flag,
643: x_invoice_close_tolerance => PO_PDOI_PARAMS.g_sys.invoice_close_tolerance,
644: x_receive_close_tolerance => PO_PDOI_PARAMS.g_sys.receive_close_tolerance,
645: x_security_structure_id => l_security_structure_id,
646: x_expense_accrual_code => PO_PDOI_PARAMS.g_sys.expense_accrual_code,
647: x_inv_org_id => PO_PDOI_PARAMS.g_sys.def_inv_org_id,
648: x_rev_sort_ordering => l_rev_sort_ordering,
649: x_min_rel_amount => PO_PDOI_PARAMS.g_sys.min_rel_amount,
650: x_notify_blanket_flag => l_notify_blanket_flag,
651: x_budgetary_control_flag => l_budgetary_control_flag,
645: x_security_structure_id => l_security_structure_id,
646: x_expense_accrual_code => PO_PDOI_PARAMS.g_sys.expense_accrual_code,
647: x_inv_org_id => PO_PDOI_PARAMS.g_sys.def_inv_org_id,
648: x_rev_sort_ordering => l_rev_sort_ordering,
649: x_min_rel_amount => PO_PDOI_PARAMS.g_sys.min_rel_amount,
650: x_notify_blanket_flag => l_notify_blanket_flag,
651: x_budgetary_control_flag => l_budgetary_control_flag,
652: x_user_defined_req_num_code => l_user_defined_req_num_code,
653: x_rfq_required_flag => l_rfq_required_flag,
657: x_reserve_at_completion_flag => l_reserve_at_completion_flag,
658: x_user_defined_rcpt_num_code => l_user_defined_rcpt_num_code,
659: x_manual_rcpt_num_type => l_manual_rcpt_num_type,
660: x_use_positions_flag => l_use_positions_flag,
661: x_default_quote_warning_delay => PO_PDOI_PARAMS.g_sys.def_quote_warning_delay,
662: x_inspection_required_flag => PO_PDOI_PARAMS.g_sys.inspection_required_flag,
663: x_user_defined_quote_num_code => PO_PDOI_PARAMS.g_sys.user_defined_quote_num_code,
664: x_manual_quote_num_type => PO_PDOI_PARAMS.g_sys.manual_quote_num_type,
665: x_user_defined_rfq_num_code => l_user_defined_rfq_num_code,
658: x_user_defined_rcpt_num_code => l_user_defined_rcpt_num_code,
659: x_manual_rcpt_num_type => l_manual_rcpt_num_type,
660: x_use_positions_flag => l_use_positions_flag,
661: x_default_quote_warning_delay => PO_PDOI_PARAMS.g_sys.def_quote_warning_delay,
662: x_inspection_required_flag => PO_PDOI_PARAMS.g_sys.inspection_required_flag,
663: x_user_defined_quote_num_code => PO_PDOI_PARAMS.g_sys.user_defined_quote_num_code,
664: x_manual_quote_num_type => PO_PDOI_PARAMS.g_sys.manual_quote_num_type,
665: x_user_defined_rfq_num_code => l_user_defined_rfq_num_code,
666: x_manual_rfq_num_type => l_manual_rfq_num_type,
659: x_manual_rcpt_num_type => l_manual_rcpt_num_type,
660: x_use_positions_flag => l_use_positions_flag,
661: x_default_quote_warning_delay => PO_PDOI_PARAMS.g_sys.def_quote_warning_delay,
662: x_inspection_required_flag => PO_PDOI_PARAMS.g_sys.inspection_required_flag,
663: x_user_defined_quote_num_code => PO_PDOI_PARAMS.g_sys.user_defined_quote_num_code,
664: x_manual_quote_num_type => PO_PDOI_PARAMS.g_sys.manual_quote_num_type,
665: x_user_defined_rfq_num_code => l_user_defined_rfq_num_code,
666: x_manual_rfq_num_type => l_manual_rfq_num_type,
667: x_ship_via_lookup_code => PO_PDOI_PARAMS.g_sys.ship_via_lookup_code,
660: x_use_positions_flag => l_use_positions_flag,
661: x_default_quote_warning_delay => PO_PDOI_PARAMS.g_sys.def_quote_warning_delay,
662: x_inspection_required_flag => PO_PDOI_PARAMS.g_sys.inspection_required_flag,
663: x_user_defined_quote_num_code => PO_PDOI_PARAMS.g_sys.user_defined_quote_num_code,
664: x_manual_quote_num_type => PO_PDOI_PARAMS.g_sys.manual_quote_num_type,
665: x_user_defined_rfq_num_code => l_user_defined_rfq_num_code,
666: x_manual_rfq_num_type => l_manual_rfq_num_type,
667: x_ship_via_lookup_code => PO_PDOI_PARAMS.g_sys.ship_via_lookup_code,
668: x_qty_rcv_tolerance => PO_PDOI_PARAMS.g_sys.qty_rcv_tolerance,
663: x_user_defined_quote_num_code => PO_PDOI_PARAMS.g_sys.user_defined_quote_num_code,
664: x_manual_quote_num_type => PO_PDOI_PARAMS.g_sys.manual_quote_num_type,
665: x_user_defined_rfq_num_code => l_user_defined_rfq_num_code,
666: x_manual_rfq_num_type => l_manual_rfq_num_type,
667: x_ship_via_lookup_code => PO_PDOI_PARAMS.g_sys.ship_via_lookup_code,
668: x_qty_rcv_tolerance => PO_PDOI_PARAMS.g_sys.qty_rcv_tolerance,
669: x_acceptance_required_flag => PO_PDOI_PARAMS.g_sys.acceptance_required_flag /* Bug 7518967 : Default Acceptance Required Check ER */
670: );
671:
664: x_manual_quote_num_type => PO_PDOI_PARAMS.g_sys.manual_quote_num_type,
665: x_user_defined_rfq_num_code => l_user_defined_rfq_num_code,
666: x_manual_rfq_num_type => l_manual_rfq_num_type,
667: x_ship_via_lookup_code => PO_PDOI_PARAMS.g_sys.ship_via_lookup_code,
668: x_qty_rcv_tolerance => PO_PDOI_PARAMS.g_sys.qty_rcv_tolerance,
669: x_acceptance_required_flag => PO_PDOI_PARAMS.g_sys.acceptance_required_flag /* Bug 7518967 : Default Acceptance Required Check ER */
670: );
671:
672: d_position := 10;
665: x_user_defined_rfq_num_code => l_user_defined_rfq_num_code,
666: x_manual_rfq_num_type => l_manual_rfq_num_type,
667: x_ship_via_lookup_code => PO_PDOI_PARAMS.g_sys.ship_via_lookup_code,
668: x_qty_rcv_tolerance => PO_PDOI_PARAMS.g_sys.qty_rcv_tolerance,
669: x_acceptance_required_flag => PO_PDOI_PARAMS.g_sys.acceptance_required_flag /* Bug 7518967 : Default Acceptance Required Check ER */
670: );
671:
672: d_position := 10;
673: SELECT price_break_lookup_code,
672: d_position := 10;
673: SELECT price_break_lookup_code,
674: supplier_authoring_acceptance,
675: cat_admin_authoring_acceptance
676: INTO PO_PDOI_PARAMS.g_sys.price_break_lookup_code,
677: PO_PDOI_PARAMS.g_sys.supplier_auth_acc,
678: PO_PDOI_PARAMS.g_sys.cat_admin_auth_acc
679: FROM po_system_parameters;
680:
673: SELECT price_break_lookup_code,
674: supplier_authoring_acceptance,
675: cat_admin_authoring_acceptance
676: INTO PO_PDOI_PARAMS.g_sys.price_break_lookup_code,
677: PO_PDOI_PARAMS.g_sys.supplier_auth_acc,
678: PO_PDOI_PARAMS.g_sys.cat_admin_auth_acc
679: FROM po_system_parameters;
680:
681: d_position := 20;
674: supplier_authoring_acceptance,
675: cat_admin_authoring_acceptance
676: INTO PO_PDOI_PARAMS.g_sys.price_break_lookup_code,
677: PO_PDOI_PARAMS.g_sys.supplier_auth_acc,
678: PO_PDOI_PARAMS.g_sys.cat_admin_auth_acc
679: FROM po_system_parameters;
680:
681: d_position := 20;
682: SELECT match_option,
680:
681: d_position := 20;
682: SELECT match_option,
683: business_group_id
684: INTO PO_PDOI_PARAMS.g_sys.invoice_match_option,
685: PO_PDOI_PARAMS.g_sys.def_business_group_id
686: FROM financials_system_parameters;
687:
688: d_position := 30;
681: d_position := 20;
682: SELECT match_option,
683: business_group_id
684: INTO PO_PDOI_PARAMS.g_sys.invoice_match_option,
685: PO_PDOI_PARAMS.g_sys.def_business_group_id
686: FROM financials_system_parameters;
687:
688: d_position := 30;
689: SELECT master_organization_id
686: FROM financials_system_parameters;
687:
688: d_position := 30;
689: SELECT master_organization_id
690: INTO PO_PDOI_PARAMS.g_sys.master_inv_org_id
691: FROM mtl_parameters
692: WHERE organization_id = PO_PDOI_PARAMS.g_sys.def_inv_org_id;
693:
694: d_position := 40;
688: d_position := 30;
689: SELECT master_organization_id
690: INTO PO_PDOI_PARAMS.g_sys.master_inv_org_id
691: FROM mtl_parameters
692: WHERE organization_id = PO_PDOI_PARAMS.g_sys.def_inv_org_id;
693:
694: d_position := 40;
695: -- receiving parameters for defaulting org
696: RCV_CORE_S.get_receiving_controls
696: RCV_CORE_S.get_receiving_controls
697: ( x_line_loc_id => NULL,
698: x_item_id => NULL,
699: x_vendor_id => NULL,
700: x_org_id => PO_PDOI_PARAMS.g_sys.def_inv_org_id,
701: x_enforce_ship_to_loc => PO_PDOI_PARAMS.g_sys.enforce_ship_to_loc,
702: x_allow_substitutes => PO_PDOI_PARAMS.g_sys.allow_substitutes,
703: x_routing_id => PO_PDOI_PARAMS.g_sys.routing_id,
704: x_qty_rcv_tolerance => PO_PDOI_PARAMS.g_sys.qty_rcv_tolerance,
697: ( x_line_loc_id => NULL,
698: x_item_id => NULL,
699: x_vendor_id => NULL,
700: x_org_id => PO_PDOI_PARAMS.g_sys.def_inv_org_id,
701: x_enforce_ship_to_loc => PO_PDOI_PARAMS.g_sys.enforce_ship_to_loc,
702: x_allow_substitutes => PO_PDOI_PARAMS.g_sys.allow_substitutes,
703: x_routing_id => PO_PDOI_PARAMS.g_sys.routing_id,
704: x_qty_rcv_tolerance => PO_PDOI_PARAMS.g_sys.qty_rcv_tolerance,
705: x_qty_rcv_exception => PO_PDOI_PARAMS.g_sys.qty_rcv_exception,
698: x_item_id => NULL,
699: x_vendor_id => NULL,
700: x_org_id => PO_PDOI_PARAMS.g_sys.def_inv_org_id,
701: x_enforce_ship_to_loc => PO_PDOI_PARAMS.g_sys.enforce_ship_to_loc,
702: x_allow_substitutes => PO_PDOI_PARAMS.g_sys.allow_substitutes,
703: x_routing_id => PO_PDOI_PARAMS.g_sys.routing_id,
704: x_qty_rcv_tolerance => PO_PDOI_PARAMS.g_sys.qty_rcv_tolerance,
705: x_qty_rcv_exception => PO_PDOI_PARAMS.g_sys.qty_rcv_exception,
706: x_days_early_receipt => PO_PDOI_PARAMS.g_sys.days_early_receipt,
699: x_vendor_id => NULL,
700: x_org_id => PO_PDOI_PARAMS.g_sys.def_inv_org_id,
701: x_enforce_ship_to_loc => PO_PDOI_PARAMS.g_sys.enforce_ship_to_loc,
702: x_allow_substitutes => PO_PDOI_PARAMS.g_sys.allow_substitutes,
703: x_routing_id => PO_PDOI_PARAMS.g_sys.routing_id,
704: x_qty_rcv_tolerance => PO_PDOI_PARAMS.g_sys.qty_rcv_tolerance,
705: x_qty_rcv_exception => PO_PDOI_PARAMS.g_sys.qty_rcv_exception,
706: x_days_early_receipt => PO_PDOI_PARAMS.g_sys.days_early_receipt,
707: x_days_late_receipt => PO_PDOI_PARAMS.g_sys.days_late_receipt,
700: x_org_id => PO_PDOI_PARAMS.g_sys.def_inv_org_id,
701: x_enforce_ship_to_loc => PO_PDOI_PARAMS.g_sys.enforce_ship_to_loc,
702: x_allow_substitutes => PO_PDOI_PARAMS.g_sys.allow_substitutes,
703: x_routing_id => PO_PDOI_PARAMS.g_sys.routing_id,
704: x_qty_rcv_tolerance => PO_PDOI_PARAMS.g_sys.qty_rcv_tolerance,
705: x_qty_rcv_exception => PO_PDOI_PARAMS.g_sys.qty_rcv_exception,
706: x_days_early_receipt => PO_PDOI_PARAMS.g_sys.days_early_receipt,
707: x_days_late_receipt => PO_PDOI_PARAMS.g_sys.days_late_receipt,
708: x_rcv_date_exception => PO_PDOI_PARAMS.g_sys.rcv_days_exception
701: x_enforce_ship_to_loc => PO_PDOI_PARAMS.g_sys.enforce_ship_to_loc,
702: x_allow_substitutes => PO_PDOI_PARAMS.g_sys.allow_substitutes,
703: x_routing_id => PO_PDOI_PARAMS.g_sys.routing_id,
704: x_qty_rcv_tolerance => PO_PDOI_PARAMS.g_sys.qty_rcv_tolerance,
705: x_qty_rcv_exception => PO_PDOI_PARAMS.g_sys.qty_rcv_exception,
706: x_days_early_receipt => PO_PDOI_PARAMS.g_sys.days_early_receipt,
707: x_days_late_receipt => PO_PDOI_PARAMS.g_sys.days_late_receipt,
708: x_rcv_date_exception => PO_PDOI_PARAMS.g_sys.rcv_days_exception
709: );
702: x_allow_substitutes => PO_PDOI_PARAMS.g_sys.allow_substitutes,
703: x_routing_id => PO_PDOI_PARAMS.g_sys.routing_id,
704: x_qty_rcv_tolerance => PO_PDOI_PARAMS.g_sys.qty_rcv_tolerance,
705: x_qty_rcv_exception => PO_PDOI_PARAMS.g_sys.qty_rcv_exception,
706: x_days_early_receipt => PO_PDOI_PARAMS.g_sys.days_early_receipt,
707: x_days_late_receipt => PO_PDOI_PARAMS.g_sys.days_late_receipt,
708: x_rcv_date_exception => PO_PDOI_PARAMS.g_sys.rcv_days_exception
709: );
710:
703: x_routing_id => PO_PDOI_PARAMS.g_sys.routing_id,
704: x_qty_rcv_tolerance => PO_PDOI_PARAMS.g_sys.qty_rcv_tolerance,
705: x_qty_rcv_exception => PO_PDOI_PARAMS.g_sys.qty_rcv_exception,
706: x_days_early_receipt => PO_PDOI_PARAMS.g_sys.days_early_receipt,
707: x_days_late_receipt => PO_PDOI_PARAMS.g_sys.days_late_receipt,
708: x_rcv_date_exception => PO_PDOI_PARAMS.g_sys.rcv_days_exception
709: );
710:
711: d_position := 50;
704: x_qty_rcv_tolerance => PO_PDOI_PARAMS.g_sys.qty_rcv_tolerance,
705: x_qty_rcv_exception => PO_PDOI_PARAMS.g_sys.qty_rcv_exception,
706: x_days_early_receipt => PO_PDOI_PARAMS.g_sys.days_early_receipt,
707: x_days_late_receipt => PO_PDOI_PARAMS.g_sys.days_late_receipt,
708: x_rcv_date_exception => PO_PDOI_PARAMS.g_sys.rcv_days_exception
709: );
710:
711: d_position := 50;
712: get_when_to_archive_property
711: d_position := 50;
712: get_when_to_archive_property
713: ( p_document_type => 'PA',
714: p_document_subtype => 'BLANKET',
715: x_when_to_archive => PO_PDOI_PARAMS.g_sys.when_to_archive_blanket
716: );
717:
718: d_position := 60;
719: get_when_to_archive_property
718: d_position := 60;
719: get_when_to_archive_property
720: ( p_document_type => 'PO',
721: p_document_subtype => 'STANDARD',
722: x_when_to_archive => PO_PDOI_PARAMS.g_sys.when_to_archive_std_po
723: );
724:
725: d_position := 70;
726: SELECT MCSB.structure_id,
725: d_position := 70;
726: SELECT MCSB.structure_id,
727: MCSB.category_set_id,
728: MCSB.default_category_id
729: INTO PO_PDOI_PARAMS.g_sys.def_structure_id,
730: PO_PDOI_PARAMS.g_sys.def_cat_set_id,
731: PO_PDOI_PARAMS.g_sys.def_category_id
732: FROM MTL_DEFAULT_CATEGORY_SETS MDCS,
733: MTL_CATEGORY_SETS_B MCSB
726: SELECT MCSB.structure_id,
727: MCSB.category_set_id,
728: MCSB.default_category_id
729: INTO PO_PDOI_PARAMS.g_sys.def_structure_id,
730: PO_PDOI_PARAMS.g_sys.def_cat_set_id,
731: PO_PDOI_PARAMS.g_sys.def_category_id
732: FROM MTL_DEFAULT_CATEGORY_SETS MDCS,
733: MTL_CATEGORY_SETS_B MCSB
734: WHERE MDCS.functional_area_id = 2
727: MCSB.category_set_id,
728: MCSB.default_category_id
729: INTO PO_PDOI_PARAMS.g_sys.def_structure_id,
730: PO_PDOI_PARAMS.g_sys.def_cat_set_id,
731: PO_PDOI_PARAMS.g_sys.def_category_id
732: FROM MTL_DEFAULT_CATEGORY_SETS MDCS,
733: MTL_CATEGORY_SETS_B MCSB
734: WHERE MDCS.functional_area_id = 2
735: AND MDCS.category_set_id = MCSB.category_set_id;
734: WHERE MDCS.functional_area_id = 2
735: AND MDCS.category_set_id = MCSB.category_set_id;
736:
737: d_position := 80;
738: PO_PDOI_PARAMS.g_sys.is_federal_instance :=
739: PO_CORE_S.check_federal_instance
740: ( p_org_id => PO_PDOI_PARAMS.g_request.org_id
741: );
742:
736:
737: d_position := 80;
738: PO_PDOI_PARAMS.g_sys.is_federal_instance :=
739: PO_CORE_S.check_federal_instance
740: ( p_org_id => PO_PDOI_PARAMS.g_request.org_id
741: );
742:
743: d_position := 90;
744: IF (PO_LOG.d_stmt) THEN
741: );
742:
743: d_position := 90;
744: IF (PO_LOG.d_stmt) THEN
745: PO_LOG.stmt (d_module, d_position, 'currency_code', PO_PDOI_PARAMS.g_sys.currency_code);
746: PO_LOG.stmt (d_module, d_position, 'coa_id', PO_PDOI_PARAMS.g_sys.coa_id);
747: PO_LOG.stmt (d_module, d_position, 'po_encumbrance_flag', PO_PDOI_PARAMS.g_sys.po_encumbrance_flag);
748: PO_LOG.stmt (d_module, d_position, 'req_encumbrance_flag', PO_PDOI_PARAMS.g_sys.req_encumbrance_flag);
749: PO_LOG.stmt (d_module, d_position, 'sob_id', PO_PDOI_PARAMS.g_sys.sob_id);
742:
743: d_position := 90;
744: IF (PO_LOG.d_stmt) THEN
745: PO_LOG.stmt (d_module, d_position, 'currency_code', PO_PDOI_PARAMS.g_sys.currency_code);
746: PO_LOG.stmt (d_module, d_position, 'coa_id', PO_PDOI_PARAMS.g_sys.coa_id);
747: PO_LOG.stmt (d_module, d_position, 'po_encumbrance_flag', PO_PDOI_PARAMS.g_sys.po_encumbrance_flag);
748: PO_LOG.stmt (d_module, d_position, 'req_encumbrance_flag', PO_PDOI_PARAMS.g_sys.req_encumbrance_flag);
749: PO_LOG.stmt (d_module, d_position, 'sob_id', PO_PDOI_PARAMS.g_sys.sob_id);
750: PO_LOG.stmt (d_module, d_position, 'ship_to_location_id', PO_PDOI_PARAMS.g_sys.ship_to_location_id);
743: d_position := 90;
744: IF (PO_LOG.d_stmt) THEN
745: PO_LOG.stmt (d_module, d_position, 'currency_code', PO_PDOI_PARAMS.g_sys.currency_code);
746: PO_LOG.stmt (d_module, d_position, 'coa_id', PO_PDOI_PARAMS.g_sys.coa_id);
747: PO_LOG.stmt (d_module, d_position, 'po_encumbrance_flag', PO_PDOI_PARAMS.g_sys.po_encumbrance_flag);
748: PO_LOG.stmt (d_module, d_position, 'req_encumbrance_flag', PO_PDOI_PARAMS.g_sys.req_encumbrance_flag);
749: PO_LOG.stmt (d_module, d_position, 'sob_id', PO_PDOI_PARAMS.g_sys.sob_id);
750: PO_LOG.stmt (d_module, d_position, 'ship_to_location_id', PO_PDOI_PARAMS.g_sys.ship_to_location_id);
751: PO_LOG.stmt (d_module, d_position, 'bill_to_location_id', PO_PDOI_PARAMS.g_sys.bill_to_location_id);
744: IF (PO_LOG.d_stmt) THEN
745: PO_LOG.stmt (d_module, d_position, 'currency_code', PO_PDOI_PARAMS.g_sys.currency_code);
746: PO_LOG.stmt (d_module, d_position, 'coa_id', PO_PDOI_PARAMS.g_sys.coa_id);
747: PO_LOG.stmt (d_module, d_position, 'po_encumbrance_flag', PO_PDOI_PARAMS.g_sys.po_encumbrance_flag);
748: PO_LOG.stmt (d_module, d_position, 'req_encumbrance_flag', PO_PDOI_PARAMS.g_sys.req_encumbrance_flag);
749: PO_LOG.stmt (d_module, d_position, 'sob_id', PO_PDOI_PARAMS.g_sys.sob_id);
750: PO_LOG.stmt (d_module, d_position, 'ship_to_location_id', PO_PDOI_PARAMS.g_sys.ship_to_location_id);
751: PO_LOG.stmt (d_module, d_position, 'bill_to_location_id', PO_PDOI_PARAMS.g_sys.bill_to_location_id);
752: PO_LOG.stmt (d_module, d_position, 'fob_lookup_code', PO_PDOI_PARAMS.g_sys.fob_lookup_code);
745: PO_LOG.stmt (d_module, d_position, 'currency_code', PO_PDOI_PARAMS.g_sys.currency_code);
746: PO_LOG.stmt (d_module, d_position, 'coa_id', PO_PDOI_PARAMS.g_sys.coa_id);
747: PO_LOG.stmt (d_module, d_position, 'po_encumbrance_flag', PO_PDOI_PARAMS.g_sys.po_encumbrance_flag);
748: PO_LOG.stmt (d_module, d_position, 'req_encumbrance_flag', PO_PDOI_PARAMS.g_sys.req_encumbrance_flag);
749: PO_LOG.stmt (d_module, d_position, 'sob_id', PO_PDOI_PARAMS.g_sys.sob_id);
750: PO_LOG.stmt (d_module, d_position, 'ship_to_location_id', PO_PDOI_PARAMS.g_sys.ship_to_location_id);
751: PO_LOG.stmt (d_module, d_position, 'bill_to_location_id', PO_PDOI_PARAMS.g_sys.bill_to_location_id);
752: PO_LOG.stmt (d_module, d_position, 'fob_lookup_code', PO_PDOI_PARAMS.g_sys.fob_lookup_code);
753: PO_LOG.stmt (d_module, d_position, 'freight_terms_lookup_code', PO_PDOI_PARAMS.g_sys.freight_terms_lookup_code);
746: PO_LOG.stmt (d_module, d_position, 'coa_id', PO_PDOI_PARAMS.g_sys.coa_id);
747: PO_LOG.stmt (d_module, d_position, 'po_encumbrance_flag', PO_PDOI_PARAMS.g_sys.po_encumbrance_flag);
748: PO_LOG.stmt (d_module, d_position, 'req_encumbrance_flag', PO_PDOI_PARAMS.g_sys.req_encumbrance_flag);
749: PO_LOG.stmt (d_module, d_position, 'sob_id', PO_PDOI_PARAMS.g_sys.sob_id);
750: PO_LOG.stmt (d_module, d_position, 'ship_to_location_id', PO_PDOI_PARAMS.g_sys.ship_to_location_id);
751: PO_LOG.stmt (d_module, d_position, 'bill_to_location_id', PO_PDOI_PARAMS.g_sys.bill_to_location_id);
752: PO_LOG.stmt (d_module, d_position, 'fob_lookup_code', PO_PDOI_PARAMS.g_sys.fob_lookup_code);
753: PO_LOG.stmt (d_module, d_position, 'freight_terms_lookup_code', PO_PDOI_PARAMS.g_sys.freight_terms_lookup_code);
754: PO_LOG.stmt (d_module, d_position, 'terms_id', PO_PDOI_PARAMS.g_sys.terms_id);
747: PO_LOG.stmt (d_module, d_position, 'po_encumbrance_flag', PO_PDOI_PARAMS.g_sys.po_encumbrance_flag);
748: PO_LOG.stmt (d_module, d_position, 'req_encumbrance_flag', PO_PDOI_PARAMS.g_sys.req_encumbrance_flag);
749: PO_LOG.stmt (d_module, d_position, 'sob_id', PO_PDOI_PARAMS.g_sys.sob_id);
750: PO_LOG.stmt (d_module, d_position, 'ship_to_location_id', PO_PDOI_PARAMS.g_sys.ship_to_location_id);
751: PO_LOG.stmt (d_module, d_position, 'bill_to_location_id', PO_PDOI_PARAMS.g_sys.bill_to_location_id);
752: PO_LOG.stmt (d_module, d_position, 'fob_lookup_code', PO_PDOI_PARAMS.g_sys.fob_lookup_code);
753: PO_LOG.stmt (d_module, d_position, 'freight_terms_lookup_code', PO_PDOI_PARAMS.g_sys.freight_terms_lookup_code);
754: PO_LOG.stmt (d_module, d_position, 'terms_id', PO_PDOI_PARAMS.g_sys.terms_id);
755: PO_LOG.stmt (d_module, d_position, 'default_rate_type', PO_PDOI_PARAMS.g_sys.default_rate_type);
748: PO_LOG.stmt (d_module, d_position, 'req_encumbrance_flag', PO_PDOI_PARAMS.g_sys.req_encumbrance_flag);
749: PO_LOG.stmt (d_module, d_position, 'sob_id', PO_PDOI_PARAMS.g_sys.sob_id);
750: PO_LOG.stmt (d_module, d_position, 'ship_to_location_id', PO_PDOI_PARAMS.g_sys.ship_to_location_id);
751: PO_LOG.stmt (d_module, d_position, 'bill_to_location_id', PO_PDOI_PARAMS.g_sys.bill_to_location_id);
752: PO_LOG.stmt (d_module, d_position, 'fob_lookup_code', PO_PDOI_PARAMS.g_sys.fob_lookup_code);
753: PO_LOG.stmt (d_module, d_position, 'freight_terms_lookup_code', PO_PDOI_PARAMS.g_sys.freight_terms_lookup_code);
754: PO_LOG.stmt (d_module, d_position, 'terms_id', PO_PDOI_PARAMS.g_sys.terms_id);
755: PO_LOG.stmt (d_module, d_position, 'default_rate_type', PO_PDOI_PARAMS.g_sys.default_rate_type);
756: PO_LOG.stmt (d_module, d_position, 'taxable_flag', PO_PDOI_PARAMS.g_sys.taxable_flag);
749: PO_LOG.stmt (d_module, d_position, 'sob_id', PO_PDOI_PARAMS.g_sys.sob_id);
750: PO_LOG.stmt (d_module, d_position, 'ship_to_location_id', PO_PDOI_PARAMS.g_sys.ship_to_location_id);
751: PO_LOG.stmt (d_module, d_position, 'bill_to_location_id', PO_PDOI_PARAMS.g_sys.bill_to_location_id);
752: PO_LOG.stmt (d_module, d_position, 'fob_lookup_code', PO_PDOI_PARAMS.g_sys.fob_lookup_code);
753: PO_LOG.stmt (d_module, d_position, 'freight_terms_lookup_code', PO_PDOI_PARAMS.g_sys.freight_terms_lookup_code);
754: PO_LOG.stmt (d_module, d_position, 'terms_id', PO_PDOI_PARAMS.g_sys.terms_id);
755: PO_LOG.stmt (d_module, d_position, 'default_rate_type', PO_PDOI_PARAMS.g_sys.default_rate_type);
756: PO_LOG.stmt (d_module, d_position, 'taxable_flag', PO_PDOI_PARAMS.g_sys.taxable_flag);
757: PO_LOG.stmt (d_module, d_position, 'receiving_flag', PO_PDOI_PARAMS.g_sys.receiving_flag);
750: PO_LOG.stmt (d_module, d_position, 'ship_to_location_id', PO_PDOI_PARAMS.g_sys.ship_to_location_id);
751: PO_LOG.stmt (d_module, d_position, 'bill_to_location_id', PO_PDOI_PARAMS.g_sys.bill_to_location_id);
752: PO_LOG.stmt (d_module, d_position, 'fob_lookup_code', PO_PDOI_PARAMS.g_sys.fob_lookup_code);
753: PO_LOG.stmt (d_module, d_position, 'freight_terms_lookup_code', PO_PDOI_PARAMS.g_sys.freight_terms_lookup_code);
754: PO_LOG.stmt (d_module, d_position, 'terms_id', PO_PDOI_PARAMS.g_sys.terms_id);
755: PO_LOG.stmt (d_module, d_position, 'default_rate_type', PO_PDOI_PARAMS.g_sys.default_rate_type);
756: PO_LOG.stmt (d_module, d_position, 'taxable_flag', PO_PDOI_PARAMS.g_sys.taxable_flag);
757: PO_LOG.stmt (d_module, d_position, 'receiving_flag', PO_PDOI_PARAMS.g_sys.receiving_flag);
758: PO_LOG.stmt (d_module, d_position, 'line_type_id', PO_PDOI_PARAMS.g_sys.line_type_id);
751: PO_LOG.stmt (d_module, d_position, 'bill_to_location_id', PO_PDOI_PARAMS.g_sys.bill_to_location_id);
752: PO_LOG.stmt (d_module, d_position, 'fob_lookup_code', PO_PDOI_PARAMS.g_sys.fob_lookup_code);
753: PO_LOG.stmt (d_module, d_position, 'freight_terms_lookup_code', PO_PDOI_PARAMS.g_sys.freight_terms_lookup_code);
754: PO_LOG.stmt (d_module, d_position, 'terms_id', PO_PDOI_PARAMS.g_sys.terms_id);
755: PO_LOG.stmt (d_module, d_position, 'default_rate_type', PO_PDOI_PARAMS.g_sys.default_rate_type);
756: PO_LOG.stmt (d_module, d_position, 'taxable_flag', PO_PDOI_PARAMS.g_sys.taxable_flag);
757: PO_LOG.stmt (d_module, d_position, 'receiving_flag', PO_PDOI_PARAMS.g_sys.receiving_flag);
758: PO_LOG.stmt (d_module, d_position, 'line_type_id', PO_PDOI_PARAMS.g_sys.line_type_id);
759: PO_LOG.stmt (d_module, d_position, 'manual_po_num_type', PO_PDOI_PARAMS.g_sys.manual_po_num_type);
752: PO_LOG.stmt (d_module, d_position, 'fob_lookup_code', PO_PDOI_PARAMS.g_sys.fob_lookup_code);
753: PO_LOG.stmt (d_module, d_position, 'freight_terms_lookup_code', PO_PDOI_PARAMS.g_sys.freight_terms_lookup_code);
754: PO_LOG.stmt (d_module, d_position, 'terms_id', PO_PDOI_PARAMS.g_sys.terms_id);
755: PO_LOG.stmt (d_module, d_position, 'default_rate_type', PO_PDOI_PARAMS.g_sys.default_rate_type);
756: PO_LOG.stmt (d_module, d_position, 'taxable_flag', PO_PDOI_PARAMS.g_sys.taxable_flag);
757: PO_LOG.stmt (d_module, d_position, 'receiving_flag', PO_PDOI_PARAMS.g_sys.receiving_flag);
758: PO_LOG.stmt (d_module, d_position, 'line_type_id', PO_PDOI_PARAMS.g_sys.line_type_id);
759: PO_LOG.stmt (d_module, d_position, 'manual_po_num_type', PO_PDOI_PARAMS.g_sys.manual_po_num_type);
760: PO_LOG.stmt (d_module, d_position, 'user_defined_po_num_code', PO_PDOI_PARAMS.g_sys.user_defined_po_num_code);
753: PO_LOG.stmt (d_module, d_position, 'freight_terms_lookup_code', PO_PDOI_PARAMS.g_sys.freight_terms_lookup_code);
754: PO_LOG.stmt (d_module, d_position, 'terms_id', PO_PDOI_PARAMS.g_sys.terms_id);
755: PO_LOG.stmt (d_module, d_position, 'default_rate_type', PO_PDOI_PARAMS.g_sys.default_rate_type);
756: PO_LOG.stmt (d_module, d_position, 'taxable_flag', PO_PDOI_PARAMS.g_sys.taxable_flag);
757: PO_LOG.stmt (d_module, d_position, 'receiving_flag', PO_PDOI_PARAMS.g_sys.receiving_flag);
758: PO_LOG.stmt (d_module, d_position, 'line_type_id', PO_PDOI_PARAMS.g_sys.line_type_id);
759: PO_LOG.stmt (d_module, d_position, 'manual_po_num_type', PO_PDOI_PARAMS.g_sys.manual_po_num_type);
760: PO_LOG.stmt (d_module, d_position, 'user_defined_po_num_code', PO_PDOI_PARAMS.g_sys.user_defined_po_num_code);
761: PO_LOG.stmt (d_module, d_position, 'price_type_lookup_code', PO_PDOI_PARAMS.g_sys.price_type_lookup_code);
754: PO_LOG.stmt (d_module, d_position, 'terms_id', PO_PDOI_PARAMS.g_sys.terms_id);
755: PO_LOG.stmt (d_module, d_position, 'default_rate_type', PO_PDOI_PARAMS.g_sys.default_rate_type);
756: PO_LOG.stmt (d_module, d_position, 'taxable_flag', PO_PDOI_PARAMS.g_sys.taxable_flag);
757: PO_LOG.stmt (d_module, d_position, 'receiving_flag', PO_PDOI_PARAMS.g_sys.receiving_flag);
758: PO_LOG.stmt (d_module, d_position, 'line_type_id', PO_PDOI_PARAMS.g_sys.line_type_id);
759: PO_LOG.stmt (d_module, d_position, 'manual_po_num_type', PO_PDOI_PARAMS.g_sys.manual_po_num_type);
760: PO_LOG.stmt (d_module, d_position, 'user_defined_po_num_code', PO_PDOI_PARAMS.g_sys.user_defined_po_num_code);
761: PO_LOG.stmt (d_module, d_position, 'price_type_lookup_code', PO_PDOI_PARAMS.g_sys.price_type_lookup_code);
762: PO_LOG.stmt (d_module, d_position, 'def_inv_org_id', PO_PDOI_PARAMS.g_sys.def_inv_org_id);
755: PO_LOG.stmt (d_module, d_position, 'default_rate_type', PO_PDOI_PARAMS.g_sys.default_rate_type);
756: PO_LOG.stmt (d_module, d_position, 'taxable_flag', PO_PDOI_PARAMS.g_sys.taxable_flag);
757: PO_LOG.stmt (d_module, d_position, 'receiving_flag', PO_PDOI_PARAMS.g_sys.receiving_flag);
758: PO_LOG.stmt (d_module, d_position, 'line_type_id', PO_PDOI_PARAMS.g_sys.line_type_id);
759: PO_LOG.stmt (d_module, d_position, 'manual_po_num_type', PO_PDOI_PARAMS.g_sys.manual_po_num_type);
760: PO_LOG.stmt (d_module, d_position, 'user_defined_po_num_code', PO_PDOI_PARAMS.g_sys.user_defined_po_num_code);
761: PO_LOG.stmt (d_module, d_position, 'price_type_lookup_code', PO_PDOI_PARAMS.g_sys.price_type_lookup_code);
762: PO_LOG.stmt (d_module, d_position, 'def_inv_org_id', PO_PDOI_PARAMS.g_sys.def_inv_org_id);
763: PO_LOG.stmt (d_module, d_position, 'min_rel_amount', PO_PDOI_PARAMS.g_sys.min_rel_amount);
756: PO_LOG.stmt (d_module, d_position, 'taxable_flag', PO_PDOI_PARAMS.g_sys.taxable_flag);
757: PO_LOG.stmt (d_module, d_position, 'receiving_flag', PO_PDOI_PARAMS.g_sys.receiving_flag);
758: PO_LOG.stmt (d_module, d_position, 'line_type_id', PO_PDOI_PARAMS.g_sys.line_type_id);
759: PO_LOG.stmt (d_module, d_position, 'manual_po_num_type', PO_PDOI_PARAMS.g_sys.manual_po_num_type);
760: PO_LOG.stmt (d_module, d_position, 'user_defined_po_num_code', PO_PDOI_PARAMS.g_sys.user_defined_po_num_code);
761: PO_LOG.stmt (d_module, d_position, 'price_type_lookup_code', PO_PDOI_PARAMS.g_sys.price_type_lookup_code);
762: PO_LOG.stmt (d_module, d_position, 'def_inv_org_id', PO_PDOI_PARAMS.g_sys.def_inv_org_id);
763: PO_LOG.stmt (d_module, d_position, 'min_rel_amount', PO_PDOI_PARAMS.g_sys.min_rel_amount);
764: PO_LOG.stmt (d_module, d_position, 'def_quote_warning_delay', PO_PDOI_PARAMS.g_sys.def_quote_warning_delay);
757: PO_LOG.stmt (d_module, d_position, 'receiving_flag', PO_PDOI_PARAMS.g_sys.receiving_flag);
758: PO_LOG.stmt (d_module, d_position, 'line_type_id', PO_PDOI_PARAMS.g_sys.line_type_id);
759: PO_LOG.stmt (d_module, d_position, 'manual_po_num_type', PO_PDOI_PARAMS.g_sys.manual_po_num_type);
760: PO_LOG.stmt (d_module, d_position, 'user_defined_po_num_code', PO_PDOI_PARAMS.g_sys.user_defined_po_num_code);
761: PO_LOG.stmt (d_module, d_position, 'price_type_lookup_code', PO_PDOI_PARAMS.g_sys.price_type_lookup_code);
762: PO_LOG.stmt (d_module, d_position, 'def_inv_org_id', PO_PDOI_PARAMS.g_sys.def_inv_org_id);
763: PO_LOG.stmt (d_module, d_position, 'min_rel_amount', PO_PDOI_PARAMS.g_sys.min_rel_amount);
764: PO_LOG.stmt (d_module, d_position, 'def_quote_warning_delay', PO_PDOI_PARAMS.g_sys.def_quote_warning_delay);
765: PO_LOG.stmt (d_module, d_position, 'inspection_required_flag', PO_PDOI_PARAMS.g_sys.inspection_required_flag);
758: PO_LOG.stmt (d_module, d_position, 'line_type_id', PO_PDOI_PARAMS.g_sys.line_type_id);
759: PO_LOG.stmt (d_module, d_position, 'manual_po_num_type', PO_PDOI_PARAMS.g_sys.manual_po_num_type);
760: PO_LOG.stmt (d_module, d_position, 'user_defined_po_num_code', PO_PDOI_PARAMS.g_sys.user_defined_po_num_code);
761: PO_LOG.stmt (d_module, d_position, 'price_type_lookup_code', PO_PDOI_PARAMS.g_sys.price_type_lookup_code);
762: PO_LOG.stmt (d_module, d_position, 'def_inv_org_id', PO_PDOI_PARAMS.g_sys.def_inv_org_id);
763: PO_LOG.stmt (d_module, d_position, 'min_rel_amount', PO_PDOI_PARAMS.g_sys.min_rel_amount);
764: PO_LOG.stmt (d_module, d_position, 'def_quote_warning_delay', PO_PDOI_PARAMS.g_sys.def_quote_warning_delay);
765: PO_LOG.stmt (d_module, d_position, 'inspection_required_flag', PO_PDOI_PARAMS.g_sys.inspection_required_flag);
766: PO_LOG.stmt (d_module, d_position, 'user_defined_quote_num_code', PO_PDOI_PARAMS.g_sys.user_defined_quote_num_code);
759: PO_LOG.stmt (d_module, d_position, 'manual_po_num_type', PO_PDOI_PARAMS.g_sys.manual_po_num_type);
760: PO_LOG.stmt (d_module, d_position, 'user_defined_po_num_code', PO_PDOI_PARAMS.g_sys.user_defined_po_num_code);
761: PO_LOG.stmt (d_module, d_position, 'price_type_lookup_code', PO_PDOI_PARAMS.g_sys.price_type_lookup_code);
762: PO_LOG.stmt (d_module, d_position, 'def_inv_org_id', PO_PDOI_PARAMS.g_sys.def_inv_org_id);
763: PO_LOG.stmt (d_module, d_position, 'min_rel_amount', PO_PDOI_PARAMS.g_sys.min_rel_amount);
764: PO_LOG.stmt (d_module, d_position, 'def_quote_warning_delay', PO_PDOI_PARAMS.g_sys.def_quote_warning_delay);
765: PO_LOG.stmt (d_module, d_position, 'inspection_required_flag', PO_PDOI_PARAMS.g_sys.inspection_required_flag);
766: PO_LOG.stmt (d_module, d_position, 'user_defined_quote_num_code', PO_PDOI_PARAMS.g_sys.user_defined_quote_num_code);
767: PO_LOG.stmt (d_module, d_position, 'manual_quote_num_type', PO_PDOI_PARAMS.g_sys.manual_quote_num_type);
760: PO_LOG.stmt (d_module, d_position, 'user_defined_po_num_code', PO_PDOI_PARAMS.g_sys.user_defined_po_num_code);
761: PO_LOG.stmt (d_module, d_position, 'price_type_lookup_code', PO_PDOI_PARAMS.g_sys.price_type_lookup_code);
762: PO_LOG.stmt (d_module, d_position, 'def_inv_org_id', PO_PDOI_PARAMS.g_sys.def_inv_org_id);
763: PO_LOG.stmt (d_module, d_position, 'min_rel_amount', PO_PDOI_PARAMS.g_sys.min_rel_amount);
764: PO_LOG.stmt (d_module, d_position, 'def_quote_warning_delay', PO_PDOI_PARAMS.g_sys.def_quote_warning_delay);
765: PO_LOG.stmt (d_module, d_position, 'inspection_required_flag', PO_PDOI_PARAMS.g_sys.inspection_required_flag);
766: PO_LOG.stmt (d_module, d_position, 'user_defined_quote_num_code', PO_PDOI_PARAMS.g_sys.user_defined_quote_num_code);
767: PO_LOG.stmt (d_module, d_position, 'manual_quote_num_type', PO_PDOI_PARAMS.g_sys.manual_quote_num_type);
768: PO_LOG.stmt (d_module, d_position, 'ship_via_lookup_code', PO_PDOI_PARAMS.g_sys.ship_via_lookup_code);
761: PO_LOG.stmt (d_module, d_position, 'price_type_lookup_code', PO_PDOI_PARAMS.g_sys.price_type_lookup_code);
762: PO_LOG.stmt (d_module, d_position, 'def_inv_org_id', PO_PDOI_PARAMS.g_sys.def_inv_org_id);
763: PO_LOG.stmt (d_module, d_position, 'min_rel_amount', PO_PDOI_PARAMS.g_sys.min_rel_amount);
764: PO_LOG.stmt (d_module, d_position, 'def_quote_warning_delay', PO_PDOI_PARAMS.g_sys.def_quote_warning_delay);
765: PO_LOG.stmt (d_module, d_position, 'inspection_required_flag', PO_PDOI_PARAMS.g_sys.inspection_required_flag);
766: PO_LOG.stmt (d_module, d_position, 'user_defined_quote_num_code', PO_PDOI_PARAMS.g_sys.user_defined_quote_num_code);
767: PO_LOG.stmt (d_module, d_position, 'manual_quote_num_type', PO_PDOI_PARAMS.g_sys.manual_quote_num_type);
768: PO_LOG.stmt (d_module, d_position, 'ship_via_lookup_code', PO_PDOI_PARAMS.g_sys.ship_via_lookup_code);
769: PO_LOG.stmt (d_module, d_position, 'qty_rcv_tolerance', PO_PDOI_PARAMS.g_sys.qty_rcv_tolerance);
762: PO_LOG.stmt (d_module, d_position, 'def_inv_org_id', PO_PDOI_PARAMS.g_sys.def_inv_org_id);
763: PO_LOG.stmt (d_module, d_position, 'min_rel_amount', PO_PDOI_PARAMS.g_sys.min_rel_amount);
764: PO_LOG.stmt (d_module, d_position, 'def_quote_warning_delay', PO_PDOI_PARAMS.g_sys.def_quote_warning_delay);
765: PO_LOG.stmt (d_module, d_position, 'inspection_required_flag', PO_PDOI_PARAMS.g_sys.inspection_required_flag);
766: PO_LOG.stmt (d_module, d_position, 'user_defined_quote_num_code', PO_PDOI_PARAMS.g_sys.user_defined_quote_num_code);
767: PO_LOG.stmt (d_module, d_position, 'manual_quote_num_type', PO_PDOI_PARAMS.g_sys.manual_quote_num_type);
768: PO_LOG.stmt (d_module, d_position, 'ship_via_lookup_code', PO_PDOI_PARAMS.g_sys.ship_via_lookup_code);
769: PO_LOG.stmt (d_module, d_position, 'qty_rcv_tolerance', PO_PDOI_PARAMS.g_sys.qty_rcv_tolerance);
770: PO_LOG.stmt (d_module, d_position, 'price_break_lookup_code', PO_PDOI_PARAMS.g_sys.price_break_lookup_code);
763: PO_LOG.stmt (d_module, d_position, 'min_rel_amount', PO_PDOI_PARAMS.g_sys.min_rel_amount);
764: PO_LOG.stmt (d_module, d_position, 'def_quote_warning_delay', PO_PDOI_PARAMS.g_sys.def_quote_warning_delay);
765: PO_LOG.stmt (d_module, d_position, 'inspection_required_flag', PO_PDOI_PARAMS.g_sys.inspection_required_flag);
766: PO_LOG.stmt (d_module, d_position, 'user_defined_quote_num_code', PO_PDOI_PARAMS.g_sys.user_defined_quote_num_code);
767: PO_LOG.stmt (d_module, d_position, 'manual_quote_num_type', PO_PDOI_PARAMS.g_sys.manual_quote_num_type);
768: PO_LOG.stmt (d_module, d_position, 'ship_via_lookup_code', PO_PDOI_PARAMS.g_sys.ship_via_lookup_code);
769: PO_LOG.stmt (d_module, d_position, 'qty_rcv_tolerance', PO_PDOI_PARAMS.g_sys.qty_rcv_tolerance);
770: PO_LOG.stmt (d_module, d_position, 'price_break_lookup_code', PO_PDOI_PARAMS.g_sys.price_break_lookup_code);
771: PO_LOG.stmt (d_module, d_position, 'invoice_close_tolerance', PO_PDOI_PARAMS.g_sys.invoice_close_tolerance);
764: PO_LOG.stmt (d_module, d_position, 'def_quote_warning_delay', PO_PDOI_PARAMS.g_sys.def_quote_warning_delay);
765: PO_LOG.stmt (d_module, d_position, 'inspection_required_flag', PO_PDOI_PARAMS.g_sys.inspection_required_flag);
766: PO_LOG.stmt (d_module, d_position, 'user_defined_quote_num_code', PO_PDOI_PARAMS.g_sys.user_defined_quote_num_code);
767: PO_LOG.stmt (d_module, d_position, 'manual_quote_num_type', PO_PDOI_PARAMS.g_sys.manual_quote_num_type);
768: PO_LOG.stmt (d_module, d_position, 'ship_via_lookup_code', PO_PDOI_PARAMS.g_sys.ship_via_lookup_code);
769: PO_LOG.stmt (d_module, d_position, 'qty_rcv_tolerance', PO_PDOI_PARAMS.g_sys.qty_rcv_tolerance);
770: PO_LOG.stmt (d_module, d_position, 'price_break_lookup_code', PO_PDOI_PARAMS.g_sys.price_break_lookup_code);
771: PO_LOG.stmt (d_module, d_position, 'invoice_close_tolerance', PO_PDOI_PARAMS.g_sys.invoice_close_tolerance);
772: PO_LOG.stmt (d_module, d_position, 'receive_close_tolerance', PO_PDOI_PARAMS.g_sys.receive_close_tolerance);
765: PO_LOG.stmt (d_module, d_position, 'inspection_required_flag', PO_PDOI_PARAMS.g_sys.inspection_required_flag);
766: PO_LOG.stmt (d_module, d_position, 'user_defined_quote_num_code', PO_PDOI_PARAMS.g_sys.user_defined_quote_num_code);
767: PO_LOG.stmt (d_module, d_position, 'manual_quote_num_type', PO_PDOI_PARAMS.g_sys.manual_quote_num_type);
768: PO_LOG.stmt (d_module, d_position, 'ship_via_lookup_code', PO_PDOI_PARAMS.g_sys.ship_via_lookup_code);
769: PO_LOG.stmt (d_module, d_position, 'qty_rcv_tolerance', PO_PDOI_PARAMS.g_sys.qty_rcv_tolerance);
770: PO_LOG.stmt (d_module, d_position, 'price_break_lookup_code', PO_PDOI_PARAMS.g_sys.price_break_lookup_code);
771: PO_LOG.stmt (d_module, d_position, 'invoice_close_tolerance', PO_PDOI_PARAMS.g_sys.invoice_close_tolerance);
772: PO_LOG.stmt (d_module, d_position, 'receive_close_tolerance', PO_PDOI_PARAMS.g_sys.receive_close_tolerance);
773: PO_LOG.stmt (d_module, d_position, 'expense_accrual_code', PO_PDOI_PARAMS.g_sys.expense_accrual_code);
766: PO_LOG.stmt (d_module, d_position, 'user_defined_quote_num_code', PO_PDOI_PARAMS.g_sys.user_defined_quote_num_code);
767: PO_LOG.stmt (d_module, d_position, 'manual_quote_num_type', PO_PDOI_PARAMS.g_sys.manual_quote_num_type);
768: PO_LOG.stmt (d_module, d_position, 'ship_via_lookup_code', PO_PDOI_PARAMS.g_sys.ship_via_lookup_code);
769: PO_LOG.stmt (d_module, d_position, 'qty_rcv_tolerance', PO_PDOI_PARAMS.g_sys.qty_rcv_tolerance);
770: PO_LOG.stmt (d_module, d_position, 'price_break_lookup_code', PO_PDOI_PARAMS.g_sys.price_break_lookup_code);
771: PO_LOG.stmt (d_module, d_position, 'invoice_close_tolerance', PO_PDOI_PARAMS.g_sys.invoice_close_tolerance);
772: PO_LOG.stmt (d_module, d_position, 'receive_close_tolerance', PO_PDOI_PARAMS.g_sys.receive_close_tolerance);
773: PO_LOG.stmt (d_module, d_position, 'expense_accrual_code', PO_PDOI_PARAMS.g_sys.expense_accrual_code);
774: PO_LOG.stmt (d_module, d_position, 'master_inv_org_id', PO_PDOI_PARAMS.g_sys.master_inv_org_id);
767: PO_LOG.stmt (d_module, d_position, 'manual_quote_num_type', PO_PDOI_PARAMS.g_sys.manual_quote_num_type);
768: PO_LOG.stmt (d_module, d_position, 'ship_via_lookup_code', PO_PDOI_PARAMS.g_sys.ship_via_lookup_code);
769: PO_LOG.stmt (d_module, d_position, 'qty_rcv_tolerance', PO_PDOI_PARAMS.g_sys.qty_rcv_tolerance);
770: PO_LOG.stmt (d_module, d_position, 'price_break_lookup_code', PO_PDOI_PARAMS.g_sys.price_break_lookup_code);
771: PO_LOG.stmt (d_module, d_position, 'invoice_close_tolerance', PO_PDOI_PARAMS.g_sys.invoice_close_tolerance);
772: PO_LOG.stmt (d_module, d_position, 'receive_close_tolerance', PO_PDOI_PARAMS.g_sys.receive_close_tolerance);
773: PO_LOG.stmt (d_module, d_position, 'expense_accrual_code', PO_PDOI_PARAMS.g_sys.expense_accrual_code);
774: PO_LOG.stmt (d_module, d_position, 'master_inv_org_id', PO_PDOI_PARAMS.g_sys.master_inv_org_id);
775: PO_LOG.stmt (d_module, d_position, 'enforce_ship_to_loc', PO_PDOI_PARAMS.g_sys.enforce_ship_to_loc);
768: PO_LOG.stmt (d_module, d_position, 'ship_via_lookup_code', PO_PDOI_PARAMS.g_sys.ship_via_lookup_code);
769: PO_LOG.stmt (d_module, d_position, 'qty_rcv_tolerance', PO_PDOI_PARAMS.g_sys.qty_rcv_tolerance);
770: PO_LOG.stmt (d_module, d_position, 'price_break_lookup_code', PO_PDOI_PARAMS.g_sys.price_break_lookup_code);
771: PO_LOG.stmt (d_module, d_position, 'invoice_close_tolerance', PO_PDOI_PARAMS.g_sys.invoice_close_tolerance);
772: PO_LOG.stmt (d_module, d_position, 'receive_close_tolerance', PO_PDOI_PARAMS.g_sys.receive_close_tolerance);
773: PO_LOG.stmt (d_module, d_position, 'expense_accrual_code', PO_PDOI_PARAMS.g_sys.expense_accrual_code);
774: PO_LOG.stmt (d_module, d_position, 'master_inv_org_id', PO_PDOI_PARAMS.g_sys.master_inv_org_id);
775: PO_LOG.stmt (d_module, d_position, 'enforce_ship_to_loc', PO_PDOI_PARAMS.g_sys.enforce_ship_to_loc);
776: PO_LOG.stmt (d_module, d_position, 'allow_substitutes', PO_PDOI_PARAMS.g_sys.allow_substitutes);
769: PO_LOG.stmt (d_module, d_position, 'qty_rcv_tolerance', PO_PDOI_PARAMS.g_sys.qty_rcv_tolerance);
770: PO_LOG.stmt (d_module, d_position, 'price_break_lookup_code', PO_PDOI_PARAMS.g_sys.price_break_lookup_code);
771: PO_LOG.stmt (d_module, d_position, 'invoice_close_tolerance', PO_PDOI_PARAMS.g_sys.invoice_close_tolerance);
772: PO_LOG.stmt (d_module, d_position, 'receive_close_tolerance', PO_PDOI_PARAMS.g_sys.receive_close_tolerance);
773: PO_LOG.stmt (d_module, d_position, 'expense_accrual_code', PO_PDOI_PARAMS.g_sys.expense_accrual_code);
774: PO_LOG.stmt (d_module, d_position, 'master_inv_org_id', PO_PDOI_PARAMS.g_sys.master_inv_org_id);
775: PO_LOG.stmt (d_module, d_position, 'enforce_ship_to_loc', PO_PDOI_PARAMS.g_sys.enforce_ship_to_loc);
776: PO_LOG.stmt (d_module, d_position, 'allow_substitutes', PO_PDOI_PARAMS.g_sys.allow_substitutes);
777: PO_LOG.stmt (d_module, d_position, 'routing_id', PO_PDOI_PARAMS.g_sys.routing_id);
770: PO_LOG.stmt (d_module, d_position, 'price_break_lookup_code', PO_PDOI_PARAMS.g_sys.price_break_lookup_code);
771: PO_LOG.stmt (d_module, d_position, 'invoice_close_tolerance', PO_PDOI_PARAMS.g_sys.invoice_close_tolerance);
772: PO_LOG.stmt (d_module, d_position, 'receive_close_tolerance', PO_PDOI_PARAMS.g_sys.receive_close_tolerance);
773: PO_LOG.stmt (d_module, d_position, 'expense_accrual_code', PO_PDOI_PARAMS.g_sys.expense_accrual_code);
774: PO_LOG.stmt (d_module, d_position, 'master_inv_org_id', PO_PDOI_PARAMS.g_sys.master_inv_org_id);
775: PO_LOG.stmt (d_module, d_position, 'enforce_ship_to_loc', PO_PDOI_PARAMS.g_sys.enforce_ship_to_loc);
776: PO_LOG.stmt (d_module, d_position, 'allow_substitutes', PO_PDOI_PARAMS.g_sys.allow_substitutes);
777: PO_LOG.stmt (d_module, d_position, 'routing_id', PO_PDOI_PARAMS.g_sys.routing_id);
778: PO_LOG.stmt (d_module, d_position, 'qty_rcv_exception', PO_PDOI_PARAMS.g_sys.qty_rcv_exception);
771: PO_LOG.stmt (d_module, d_position, 'invoice_close_tolerance', PO_PDOI_PARAMS.g_sys.invoice_close_tolerance);
772: PO_LOG.stmt (d_module, d_position, 'receive_close_tolerance', PO_PDOI_PARAMS.g_sys.receive_close_tolerance);
773: PO_LOG.stmt (d_module, d_position, 'expense_accrual_code', PO_PDOI_PARAMS.g_sys.expense_accrual_code);
774: PO_LOG.stmt (d_module, d_position, 'master_inv_org_id', PO_PDOI_PARAMS.g_sys.master_inv_org_id);
775: PO_LOG.stmt (d_module, d_position, 'enforce_ship_to_loc', PO_PDOI_PARAMS.g_sys.enforce_ship_to_loc);
776: PO_LOG.stmt (d_module, d_position, 'allow_substitutes', PO_PDOI_PARAMS.g_sys.allow_substitutes);
777: PO_LOG.stmt (d_module, d_position, 'routing_id', PO_PDOI_PARAMS.g_sys.routing_id);
778: PO_LOG.stmt (d_module, d_position, 'qty_rcv_exception', PO_PDOI_PARAMS.g_sys.qty_rcv_exception);
779: PO_LOG.stmt (d_module, d_position, 'days_early_receipt', PO_PDOI_PARAMS.g_sys.days_early_receipt);
772: PO_LOG.stmt (d_module, d_position, 'receive_close_tolerance', PO_PDOI_PARAMS.g_sys.receive_close_tolerance);
773: PO_LOG.stmt (d_module, d_position, 'expense_accrual_code', PO_PDOI_PARAMS.g_sys.expense_accrual_code);
774: PO_LOG.stmt (d_module, d_position, 'master_inv_org_id', PO_PDOI_PARAMS.g_sys.master_inv_org_id);
775: PO_LOG.stmt (d_module, d_position, 'enforce_ship_to_loc', PO_PDOI_PARAMS.g_sys.enforce_ship_to_loc);
776: PO_LOG.stmt (d_module, d_position, 'allow_substitutes', PO_PDOI_PARAMS.g_sys.allow_substitutes);
777: PO_LOG.stmt (d_module, d_position, 'routing_id', PO_PDOI_PARAMS.g_sys.routing_id);
778: PO_LOG.stmt (d_module, d_position, 'qty_rcv_exception', PO_PDOI_PARAMS.g_sys.qty_rcv_exception);
779: PO_LOG.stmt (d_module, d_position, 'days_early_receipt', PO_PDOI_PARAMS.g_sys.days_early_receipt);
780: PO_LOG.stmt (d_module, d_position, 'days_late_receipt', PO_PDOI_PARAMS.g_sys.days_late_receipt);
773: PO_LOG.stmt (d_module, d_position, 'expense_accrual_code', PO_PDOI_PARAMS.g_sys.expense_accrual_code);
774: PO_LOG.stmt (d_module, d_position, 'master_inv_org_id', PO_PDOI_PARAMS.g_sys.master_inv_org_id);
775: PO_LOG.stmt (d_module, d_position, 'enforce_ship_to_loc', PO_PDOI_PARAMS.g_sys.enforce_ship_to_loc);
776: PO_LOG.stmt (d_module, d_position, 'allow_substitutes', PO_PDOI_PARAMS.g_sys.allow_substitutes);
777: PO_LOG.stmt (d_module, d_position, 'routing_id', PO_PDOI_PARAMS.g_sys.routing_id);
778: PO_LOG.stmt (d_module, d_position, 'qty_rcv_exception', PO_PDOI_PARAMS.g_sys.qty_rcv_exception);
779: PO_LOG.stmt (d_module, d_position, 'days_early_receipt', PO_PDOI_PARAMS.g_sys.days_early_receipt);
780: PO_LOG.stmt (d_module, d_position, 'days_late_receipt', PO_PDOI_PARAMS.g_sys.days_late_receipt);
781: PO_LOG.stmt (d_module, d_position, 'rcv_days_exception', PO_PDOI_PARAMS.g_sys.rcv_days_exception);
774: PO_LOG.stmt (d_module, d_position, 'master_inv_org_id', PO_PDOI_PARAMS.g_sys.master_inv_org_id);
775: PO_LOG.stmt (d_module, d_position, 'enforce_ship_to_loc', PO_PDOI_PARAMS.g_sys.enforce_ship_to_loc);
776: PO_LOG.stmt (d_module, d_position, 'allow_substitutes', PO_PDOI_PARAMS.g_sys.allow_substitutes);
777: PO_LOG.stmt (d_module, d_position, 'routing_id', PO_PDOI_PARAMS.g_sys.routing_id);
778: PO_LOG.stmt (d_module, d_position, 'qty_rcv_exception', PO_PDOI_PARAMS.g_sys.qty_rcv_exception);
779: PO_LOG.stmt (d_module, d_position, 'days_early_receipt', PO_PDOI_PARAMS.g_sys.days_early_receipt);
780: PO_LOG.stmt (d_module, d_position, 'days_late_receipt', PO_PDOI_PARAMS.g_sys.days_late_receipt);
781: PO_LOG.stmt (d_module, d_position, 'rcv_days_exception', PO_PDOI_PARAMS.g_sys.rcv_days_exception);
782: PO_LOG.stmt (d_module, d_position, 'supplier_auth_acc', PO_PDOI_PARAMS.g_sys.supplier_auth_acc);
775: PO_LOG.stmt (d_module, d_position, 'enforce_ship_to_loc', PO_PDOI_PARAMS.g_sys.enforce_ship_to_loc);
776: PO_LOG.stmt (d_module, d_position, 'allow_substitutes', PO_PDOI_PARAMS.g_sys.allow_substitutes);
777: PO_LOG.stmt (d_module, d_position, 'routing_id', PO_PDOI_PARAMS.g_sys.routing_id);
778: PO_LOG.stmt (d_module, d_position, 'qty_rcv_exception', PO_PDOI_PARAMS.g_sys.qty_rcv_exception);
779: PO_LOG.stmt (d_module, d_position, 'days_early_receipt', PO_PDOI_PARAMS.g_sys.days_early_receipt);
780: PO_LOG.stmt (d_module, d_position, 'days_late_receipt', PO_PDOI_PARAMS.g_sys.days_late_receipt);
781: PO_LOG.stmt (d_module, d_position, 'rcv_days_exception', PO_PDOI_PARAMS.g_sys.rcv_days_exception);
782: PO_LOG.stmt (d_module, d_position, 'supplier_auth_acc', PO_PDOI_PARAMS.g_sys.supplier_auth_acc);
783: PO_LOG.stmt (d_module, d_position, 'cat_admin_auth_acc', PO_PDOI_PARAMS.g_sys.cat_admin_auth_acc);
776: PO_LOG.stmt (d_module, d_position, 'allow_substitutes', PO_PDOI_PARAMS.g_sys.allow_substitutes);
777: PO_LOG.stmt (d_module, d_position, 'routing_id', PO_PDOI_PARAMS.g_sys.routing_id);
778: PO_LOG.stmt (d_module, d_position, 'qty_rcv_exception', PO_PDOI_PARAMS.g_sys.qty_rcv_exception);
779: PO_LOG.stmt (d_module, d_position, 'days_early_receipt', PO_PDOI_PARAMS.g_sys.days_early_receipt);
780: PO_LOG.stmt (d_module, d_position, 'days_late_receipt', PO_PDOI_PARAMS.g_sys.days_late_receipt);
781: PO_LOG.stmt (d_module, d_position, 'rcv_days_exception', PO_PDOI_PARAMS.g_sys.rcv_days_exception);
782: PO_LOG.stmt (d_module, d_position, 'supplier_auth_acc', PO_PDOI_PARAMS.g_sys.supplier_auth_acc);
783: PO_LOG.stmt (d_module, d_position, 'cat_admin_auth_acc', PO_PDOI_PARAMS.g_sys.cat_admin_auth_acc);
784: PO_LOG.stmt (d_module, d_position, 'invoice_match_option', PO_PDOI_PARAMS.g_sys.invoice_match_option);
777: PO_LOG.stmt (d_module, d_position, 'routing_id', PO_PDOI_PARAMS.g_sys.routing_id);
778: PO_LOG.stmt (d_module, d_position, 'qty_rcv_exception', PO_PDOI_PARAMS.g_sys.qty_rcv_exception);
779: PO_LOG.stmt (d_module, d_position, 'days_early_receipt', PO_PDOI_PARAMS.g_sys.days_early_receipt);
780: PO_LOG.stmt (d_module, d_position, 'days_late_receipt', PO_PDOI_PARAMS.g_sys.days_late_receipt);
781: PO_LOG.stmt (d_module, d_position, 'rcv_days_exception', PO_PDOI_PARAMS.g_sys.rcv_days_exception);
782: PO_LOG.stmt (d_module, d_position, 'supplier_auth_acc', PO_PDOI_PARAMS.g_sys.supplier_auth_acc);
783: PO_LOG.stmt (d_module, d_position, 'cat_admin_auth_acc', PO_PDOI_PARAMS.g_sys.cat_admin_auth_acc);
784: PO_LOG.stmt (d_module, d_position, 'invoice_match_option', PO_PDOI_PARAMS.g_sys.invoice_match_option);
785: PO_LOG.stmt (d_module, d_position, 'when_to_archive_blanket', PO_PDOI_PARAMS.g_sys.when_to_archive_blanket);
778: PO_LOG.stmt (d_module, d_position, 'qty_rcv_exception', PO_PDOI_PARAMS.g_sys.qty_rcv_exception);
779: PO_LOG.stmt (d_module, d_position, 'days_early_receipt', PO_PDOI_PARAMS.g_sys.days_early_receipt);
780: PO_LOG.stmt (d_module, d_position, 'days_late_receipt', PO_PDOI_PARAMS.g_sys.days_late_receipt);
781: PO_LOG.stmt (d_module, d_position, 'rcv_days_exception', PO_PDOI_PARAMS.g_sys.rcv_days_exception);
782: PO_LOG.stmt (d_module, d_position, 'supplier_auth_acc', PO_PDOI_PARAMS.g_sys.supplier_auth_acc);
783: PO_LOG.stmt (d_module, d_position, 'cat_admin_auth_acc', PO_PDOI_PARAMS.g_sys.cat_admin_auth_acc);
784: PO_LOG.stmt (d_module, d_position, 'invoice_match_option', PO_PDOI_PARAMS.g_sys.invoice_match_option);
785: PO_LOG.stmt (d_module, d_position, 'when_to_archive_blanket', PO_PDOI_PARAMS.g_sys.when_to_archive_blanket);
786: PO_LOG.stmt (d_module, d_position, 'when_to_archive_std_po', PO_PDOI_PARAMS.g_sys.when_to_archive_std_po);
779: PO_LOG.stmt (d_module, d_position, 'days_early_receipt', PO_PDOI_PARAMS.g_sys.days_early_receipt);
780: PO_LOG.stmt (d_module, d_position, 'days_late_receipt', PO_PDOI_PARAMS.g_sys.days_late_receipt);
781: PO_LOG.stmt (d_module, d_position, 'rcv_days_exception', PO_PDOI_PARAMS.g_sys.rcv_days_exception);
782: PO_LOG.stmt (d_module, d_position, 'supplier_auth_acc', PO_PDOI_PARAMS.g_sys.supplier_auth_acc);
783: PO_LOG.stmt (d_module, d_position, 'cat_admin_auth_acc', PO_PDOI_PARAMS.g_sys.cat_admin_auth_acc);
784: PO_LOG.stmt (d_module, d_position, 'invoice_match_option', PO_PDOI_PARAMS.g_sys.invoice_match_option);
785: PO_LOG.stmt (d_module, d_position, 'when_to_archive_blanket', PO_PDOI_PARAMS.g_sys.when_to_archive_blanket);
786: PO_LOG.stmt (d_module, d_position, 'when_to_archive_std_po', PO_PDOI_PARAMS.g_sys.when_to_archive_std_po);
787: PO_LOG.stmt (d_module, d_position, 'def_business_group_id', PO_PDOI_PARAMS.g_sys.def_business_group_id);
780: PO_LOG.stmt (d_module, d_position, 'days_late_receipt', PO_PDOI_PARAMS.g_sys.days_late_receipt);
781: PO_LOG.stmt (d_module, d_position, 'rcv_days_exception', PO_PDOI_PARAMS.g_sys.rcv_days_exception);
782: PO_LOG.stmt (d_module, d_position, 'supplier_auth_acc', PO_PDOI_PARAMS.g_sys.supplier_auth_acc);
783: PO_LOG.stmt (d_module, d_position, 'cat_admin_auth_acc', PO_PDOI_PARAMS.g_sys.cat_admin_auth_acc);
784: PO_LOG.stmt (d_module, d_position, 'invoice_match_option', PO_PDOI_PARAMS.g_sys.invoice_match_option);
785: PO_LOG.stmt (d_module, d_position, 'when_to_archive_blanket', PO_PDOI_PARAMS.g_sys.when_to_archive_blanket);
786: PO_LOG.stmt (d_module, d_position, 'when_to_archive_std_po', PO_PDOI_PARAMS.g_sys.when_to_archive_std_po);
787: PO_LOG.stmt (d_module, d_position, 'def_business_group_id', PO_PDOI_PARAMS.g_sys.def_business_group_id);
788: PO_LOG.stmt (d_module, d_position, 'def_structure_id', PO_PDOI_PARAMS.g_sys.def_structure_id);
781: PO_LOG.stmt (d_module, d_position, 'rcv_days_exception', PO_PDOI_PARAMS.g_sys.rcv_days_exception);
782: PO_LOG.stmt (d_module, d_position, 'supplier_auth_acc', PO_PDOI_PARAMS.g_sys.supplier_auth_acc);
783: PO_LOG.stmt (d_module, d_position, 'cat_admin_auth_acc', PO_PDOI_PARAMS.g_sys.cat_admin_auth_acc);
784: PO_LOG.stmt (d_module, d_position, 'invoice_match_option', PO_PDOI_PARAMS.g_sys.invoice_match_option);
785: PO_LOG.stmt (d_module, d_position, 'when_to_archive_blanket', PO_PDOI_PARAMS.g_sys.when_to_archive_blanket);
786: PO_LOG.stmt (d_module, d_position, 'when_to_archive_std_po', PO_PDOI_PARAMS.g_sys.when_to_archive_std_po);
787: PO_LOG.stmt (d_module, d_position, 'def_business_group_id', PO_PDOI_PARAMS.g_sys.def_business_group_id);
788: PO_LOG.stmt (d_module, d_position, 'def_structure_id', PO_PDOI_PARAMS.g_sys.def_structure_id);
789: PO_LOG.stmt (d_module, d_position, 'def_cat_set_id', PO_PDOI_PARAMS.g_sys.def_cat_set_id);
782: PO_LOG.stmt (d_module, d_position, 'supplier_auth_acc', PO_PDOI_PARAMS.g_sys.supplier_auth_acc);
783: PO_LOG.stmt (d_module, d_position, 'cat_admin_auth_acc', PO_PDOI_PARAMS.g_sys.cat_admin_auth_acc);
784: PO_LOG.stmt (d_module, d_position, 'invoice_match_option', PO_PDOI_PARAMS.g_sys.invoice_match_option);
785: PO_LOG.stmt (d_module, d_position, 'when_to_archive_blanket', PO_PDOI_PARAMS.g_sys.when_to_archive_blanket);
786: PO_LOG.stmt (d_module, d_position, 'when_to_archive_std_po', PO_PDOI_PARAMS.g_sys.when_to_archive_std_po);
787: PO_LOG.stmt (d_module, d_position, 'def_business_group_id', PO_PDOI_PARAMS.g_sys.def_business_group_id);
788: PO_LOG.stmt (d_module, d_position, 'def_structure_id', PO_PDOI_PARAMS.g_sys.def_structure_id);
789: PO_LOG.stmt (d_module, d_position, 'def_cat_set_id', PO_PDOI_PARAMS.g_sys.def_cat_set_id);
790: PO_LOG.stmt (d_module, d_position, 'def_category_id', PO_PDOI_PARAMS.g_sys.def_category_id);
783: PO_LOG.stmt (d_module, d_position, 'cat_admin_auth_acc', PO_PDOI_PARAMS.g_sys.cat_admin_auth_acc);
784: PO_LOG.stmt (d_module, d_position, 'invoice_match_option', PO_PDOI_PARAMS.g_sys.invoice_match_option);
785: PO_LOG.stmt (d_module, d_position, 'when_to_archive_blanket', PO_PDOI_PARAMS.g_sys.when_to_archive_blanket);
786: PO_LOG.stmt (d_module, d_position, 'when_to_archive_std_po', PO_PDOI_PARAMS.g_sys.when_to_archive_std_po);
787: PO_LOG.stmt (d_module, d_position, 'def_business_group_id', PO_PDOI_PARAMS.g_sys.def_business_group_id);
788: PO_LOG.stmt (d_module, d_position, 'def_structure_id', PO_PDOI_PARAMS.g_sys.def_structure_id);
789: PO_LOG.stmt (d_module, d_position, 'def_cat_set_id', PO_PDOI_PARAMS.g_sys.def_cat_set_id);
790: PO_LOG.stmt (d_module, d_position, 'def_category_id', PO_PDOI_PARAMS.g_sys.def_category_id);
791: PO_LOG.stmt (d_module, d_position, 'is_federal_instance', PO_PDOI_PARAMS.g_sys.is_federal_instance);
784: PO_LOG.stmt (d_module, d_position, 'invoice_match_option', PO_PDOI_PARAMS.g_sys.invoice_match_option);
785: PO_LOG.stmt (d_module, d_position, 'when_to_archive_blanket', PO_PDOI_PARAMS.g_sys.when_to_archive_blanket);
786: PO_LOG.stmt (d_module, d_position, 'when_to_archive_std_po', PO_PDOI_PARAMS.g_sys.when_to_archive_std_po);
787: PO_LOG.stmt (d_module, d_position, 'def_business_group_id', PO_PDOI_PARAMS.g_sys.def_business_group_id);
788: PO_LOG.stmt (d_module, d_position, 'def_structure_id', PO_PDOI_PARAMS.g_sys.def_structure_id);
789: PO_LOG.stmt (d_module, d_position, 'def_cat_set_id', PO_PDOI_PARAMS.g_sys.def_cat_set_id);
790: PO_LOG.stmt (d_module, d_position, 'def_category_id', PO_PDOI_PARAMS.g_sys.def_category_id);
791: PO_LOG.stmt (d_module, d_position, 'is_federal_instance', PO_PDOI_PARAMS.g_sys.is_federal_instance);
792: END IF;
785: PO_LOG.stmt (d_module, d_position, 'when_to_archive_blanket', PO_PDOI_PARAMS.g_sys.when_to_archive_blanket);
786: PO_LOG.stmt (d_module, d_position, 'when_to_archive_std_po', PO_PDOI_PARAMS.g_sys.when_to_archive_std_po);
787: PO_LOG.stmt (d_module, d_position, 'def_business_group_id', PO_PDOI_PARAMS.g_sys.def_business_group_id);
788: PO_LOG.stmt (d_module, d_position, 'def_structure_id', PO_PDOI_PARAMS.g_sys.def_structure_id);
789: PO_LOG.stmt (d_module, d_position, 'def_cat_set_id', PO_PDOI_PARAMS.g_sys.def_cat_set_id);
790: PO_LOG.stmt (d_module, d_position, 'def_category_id', PO_PDOI_PARAMS.g_sys.def_category_id);
791: PO_LOG.stmt (d_module, d_position, 'is_federal_instance', PO_PDOI_PARAMS.g_sys.is_federal_instance);
792: END IF;
793:
786: PO_LOG.stmt (d_module, d_position, 'when_to_archive_std_po', PO_PDOI_PARAMS.g_sys.when_to_archive_std_po);
787: PO_LOG.stmt (d_module, d_position, 'def_business_group_id', PO_PDOI_PARAMS.g_sys.def_business_group_id);
788: PO_LOG.stmt (d_module, d_position, 'def_structure_id', PO_PDOI_PARAMS.g_sys.def_structure_id);
789: PO_LOG.stmt (d_module, d_position, 'def_cat_set_id', PO_PDOI_PARAMS.g_sys.def_cat_set_id);
790: PO_LOG.stmt (d_module, d_position, 'def_category_id', PO_PDOI_PARAMS.g_sys.def_category_id);
791: PO_LOG.stmt (d_module, d_position, 'is_federal_instance', PO_PDOI_PARAMS.g_sys.is_federal_instance);
792: END IF;
793:
794: IF (PO_LOG.d_proc) THEN
787: PO_LOG.stmt (d_module, d_position, 'def_business_group_id', PO_PDOI_PARAMS.g_sys.def_business_group_id);
788: PO_LOG.stmt (d_module, d_position, 'def_structure_id', PO_PDOI_PARAMS.g_sys.def_structure_id);
789: PO_LOG.stmt (d_module, d_position, 'def_cat_set_id', PO_PDOI_PARAMS.g_sys.def_cat_set_id);
790: PO_LOG.stmt (d_module, d_position, 'def_category_id', PO_PDOI_PARAMS.g_sys.def_category_id);
791: PO_LOG.stmt (d_module, d_position, 'is_federal_instance', PO_PDOI_PARAMS.g_sys.is_federal_instance);
792: END IF;
793:
794: IF (PO_LOG.d_proc) THEN
795: PO_LOG.proc_end (d_module);
808: -----------------------------------------------------------------------
809: --Start of Comments
810: --Name: init_profile_parameters
811: --Function:
812: -- Derive necessary profiles and populate the same to PO_PDOI_PARAMS.g_profile
813: -- record
814: --Parameters:
815: --IN:
816: --IN OUT:
829: IF (PO_LOG.d_proc) THEN
830: PO_LOG.proc_begin (d_module);
831: END IF;
832:
833: PO_PDOI_PARAMS.g_profile.pdoi_write_to_file :=
834: NVL(FND_PROFILE.value('PO_PDOI_WRITE_TO_FILE'),'N');
835:
836: PO_PDOI_PARAMS.g_profile.service_uom_class :=
837: NVL(FND_PROFILE.value('PO_RATE_UOM_CLASS'), '999');
832:
833: PO_PDOI_PARAMS.g_profile.pdoi_write_to_file :=
834: NVL(FND_PROFILE.value('PO_PDOI_WRITE_TO_FILE'),'N');
835:
836: PO_PDOI_PARAMS.g_profile.service_uom_class :=
837: NVL(FND_PROFILE.value('PO_RATE_UOM_CLASS'), '999');
838:
839: PO_PDOI_PARAMS.g_profile.pdoi_archive_on_approval :=
840: NVL(FND_PROFILE.value('PO_PDOI_ARCHIVE_ON_APPROVAL'), 'N');
835:
836: PO_PDOI_PARAMS.g_profile.service_uom_class :=
837: NVL(FND_PROFILE.value('PO_RATE_UOM_CLASS'), '999');
838:
839: PO_PDOI_PARAMS.g_profile.pdoi_archive_on_approval :=
840: NVL(FND_PROFILE.value('PO_PDOI_ARCHIVE_ON_APPROVAL'), 'N');
841:
842: PO_PDOI_PARAMS.g_profile.override_funds :=
843: FND_PROFILE.value('PO_REQAPPR_OVERRIDE_FUNDS');
838:
839: PO_PDOI_PARAMS.g_profile.pdoi_archive_on_approval :=
840: NVL(FND_PROFILE.value('PO_PDOI_ARCHIVE_ON_APPROVAL'), 'N');
841:
842: PO_PDOI_PARAMS.g_profile.override_funds :=
843: FND_PROFILE.value('PO_REQAPPR_OVERRIDE_FUNDS');
844:
845: PO_PDOI_PARAMS.g_profile.xbg := NVL(HR_GENERAL.get_xbg_profile, 'N');
846:
841:
842: PO_PDOI_PARAMS.g_profile.override_funds :=
843: FND_PROFILE.value('PO_REQAPPR_OVERRIDE_FUNDS');
844:
845: PO_PDOI_PARAMS.g_profile.xbg := NVL(HR_GENERAL.get_xbg_profile, 'N');
846:
847: PO_PDOI_PARAMS.g_profile.po_price_update_tolerance :=
848: FND_PROFILE.value('PO_PRICE_UPDATE_TOLERANCE');
849:
843: FND_PROFILE.value('PO_REQAPPR_OVERRIDE_FUNDS');
844:
845: PO_PDOI_PARAMS.g_profile.xbg := NVL(HR_GENERAL.get_xbg_profile, 'N');
846:
847: PO_PDOI_PARAMS.g_profile.po_price_update_tolerance :=
848: FND_PROFILE.value('PO_PRICE_UPDATE_TOLERANCE');
849:
850: -- bug 5015608
851: -- get profile value from eTax. Default the value to 'Y' if NULL
848: FND_PROFILE.value('PO_PRICE_UPDATE_TOLERANCE');
849:
850: -- bug 5015608
851: -- get profile value from eTax. Default the value to 'Y' if NULL
852: PO_PDOI_PARAMS.g_profile.allow_tax_rate_override :=
853: NVL(FND_PROFILE.value('ZX_ALLOW_TAX_RECVRY_RATE_OVERRIDE'), 'Y');
854:
855: PO_PDOI_PARAMS.g_profile.allow_tax_code_override :=
856: NVL(FND_PROFILE.value('ZX_ALLOW_TAX_CLASSIF_OVERRIDE'), 'Y');
851: -- get profile value from eTax. Default the value to 'Y' if NULL
852: PO_PDOI_PARAMS.g_profile.allow_tax_rate_override :=
853: NVL(FND_PROFILE.value('ZX_ALLOW_TAX_RECVRY_RATE_OVERRIDE'), 'Y');
854:
855: PO_PDOI_PARAMS.g_profile.allow_tax_code_override :=
856: NVL(FND_PROFILE.value('ZX_ALLOW_TAX_CLASSIF_OVERRIDE'), 'Y');
857:
858:
859: IF (PO_LOG.d_stmt) THEN
856: NVL(FND_PROFILE.value('ZX_ALLOW_TAX_CLASSIF_OVERRIDE'), 'Y');
857:
858:
859: IF (PO_LOG.d_stmt) THEN
860: PO_LOG.stmt (d_module, d_position, 'pdoi_write_to_file', PO_PDOI_PARAMS.g_profile.pdoi_write_to_file);
861: PO_LOG.stmt (d_module, d_position, 'service_uom_class', PO_PDOI_PARAMS.g_profile.service_uom_class);
862: PO_LOG.stmt (d_module, d_position, 'pdoi_archive_on_approval', PO_PDOI_PARAMS.g_profile.pdoi_archive_on_approval);
863: PO_LOG.stmt (d_module, d_position, 'override_funds', PO_PDOI_PARAMS.g_profile.override_funds);
864: PO_LOG.stmt (d_module, d_position, 'xbg', PO_PDOI_PARAMS.g_profile.xbg);
857:
858:
859: IF (PO_LOG.d_stmt) THEN
860: PO_LOG.stmt (d_module, d_position, 'pdoi_write_to_file', PO_PDOI_PARAMS.g_profile.pdoi_write_to_file);
861: PO_LOG.stmt (d_module, d_position, 'service_uom_class', PO_PDOI_PARAMS.g_profile.service_uom_class);
862: PO_LOG.stmt (d_module, d_position, 'pdoi_archive_on_approval', PO_PDOI_PARAMS.g_profile.pdoi_archive_on_approval);
863: PO_LOG.stmt (d_module, d_position, 'override_funds', PO_PDOI_PARAMS.g_profile.override_funds);
864: PO_LOG.stmt (d_module, d_position, 'xbg', PO_PDOI_PARAMS.g_profile.xbg);
865: PO_LOG.stmt (d_module, d_position, 'po_price_update_tolerance', PO_PDOI_PARAMS.g_profile.po_price_update_tolerance);
858:
859: IF (PO_LOG.d_stmt) THEN
860: PO_LOG.stmt (d_module, d_position, 'pdoi_write_to_file', PO_PDOI_PARAMS.g_profile.pdoi_write_to_file);
861: PO_LOG.stmt (d_module, d_position, 'service_uom_class', PO_PDOI_PARAMS.g_profile.service_uom_class);
862: PO_LOG.stmt (d_module, d_position, 'pdoi_archive_on_approval', PO_PDOI_PARAMS.g_profile.pdoi_archive_on_approval);
863: PO_LOG.stmt (d_module, d_position, 'override_funds', PO_PDOI_PARAMS.g_profile.override_funds);
864: PO_LOG.stmt (d_module, d_position, 'xbg', PO_PDOI_PARAMS.g_profile.xbg);
865: PO_LOG.stmt (d_module, d_position, 'po_price_update_tolerance', PO_PDOI_PARAMS.g_profile.po_price_update_tolerance);
866: PO_LOG.stmt (d_module, d_position, 'allow_tax_rate_override', PO_PDOI_PARAMS.g_profile.allow_tax_rate_override);
859: IF (PO_LOG.d_stmt) THEN
860: PO_LOG.stmt (d_module, d_position, 'pdoi_write_to_file', PO_PDOI_PARAMS.g_profile.pdoi_write_to_file);
861: PO_LOG.stmt (d_module, d_position, 'service_uom_class', PO_PDOI_PARAMS.g_profile.service_uom_class);
862: PO_LOG.stmt (d_module, d_position, 'pdoi_archive_on_approval', PO_PDOI_PARAMS.g_profile.pdoi_archive_on_approval);
863: PO_LOG.stmt (d_module, d_position, 'override_funds', PO_PDOI_PARAMS.g_profile.override_funds);
864: PO_LOG.stmt (d_module, d_position, 'xbg', PO_PDOI_PARAMS.g_profile.xbg);
865: PO_LOG.stmt (d_module, d_position, 'po_price_update_tolerance', PO_PDOI_PARAMS.g_profile.po_price_update_tolerance);
866: PO_LOG.stmt (d_module, d_position, 'allow_tax_rate_override', PO_PDOI_PARAMS.g_profile.allow_tax_rate_override);
867: PO_LOG.stmt (d_module, d_position, 'allow_tax_code_override', PO_PDOI_PARAMS.g_profile.allow_tax_code_override);
860: PO_LOG.stmt (d_module, d_position, 'pdoi_write_to_file', PO_PDOI_PARAMS.g_profile.pdoi_write_to_file);
861: PO_LOG.stmt (d_module, d_position, 'service_uom_class', PO_PDOI_PARAMS.g_profile.service_uom_class);
862: PO_LOG.stmt (d_module, d_position, 'pdoi_archive_on_approval', PO_PDOI_PARAMS.g_profile.pdoi_archive_on_approval);
863: PO_LOG.stmt (d_module, d_position, 'override_funds', PO_PDOI_PARAMS.g_profile.override_funds);
864: PO_LOG.stmt (d_module, d_position, 'xbg', PO_PDOI_PARAMS.g_profile.xbg);
865: PO_LOG.stmt (d_module, d_position, 'po_price_update_tolerance', PO_PDOI_PARAMS.g_profile.po_price_update_tolerance);
866: PO_LOG.stmt (d_module, d_position, 'allow_tax_rate_override', PO_PDOI_PARAMS.g_profile.allow_tax_rate_override);
867: PO_LOG.stmt (d_module, d_position, 'allow_tax_code_override', PO_PDOI_PARAMS.g_profile.allow_tax_code_override);
868: END IF;
861: PO_LOG.stmt (d_module, d_position, 'service_uom_class', PO_PDOI_PARAMS.g_profile.service_uom_class);
862: PO_LOG.stmt (d_module, d_position, 'pdoi_archive_on_approval', PO_PDOI_PARAMS.g_profile.pdoi_archive_on_approval);
863: PO_LOG.stmt (d_module, d_position, 'override_funds', PO_PDOI_PARAMS.g_profile.override_funds);
864: PO_LOG.stmt (d_module, d_position, 'xbg', PO_PDOI_PARAMS.g_profile.xbg);
865: PO_LOG.stmt (d_module, d_position, 'po_price_update_tolerance', PO_PDOI_PARAMS.g_profile.po_price_update_tolerance);
866: PO_LOG.stmt (d_module, d_position, 'allow_tax_rate_override', PO_PDOI_PARAMS.g_profile.allow_tax_rate_override);
867: PO_LOG.stmt (d_module, d_position, 'allow_tax_code_override', PO_PDOI_PARAMS.g_profile.allow_tax_code_override);
868: END IF;
869:
862: PO_LOG.stmt (d_module, d_position, 'pdoi_archive_on_approval', PO_PDOI_PARAMS.g_profile.pdoi_archive_on_approval);
863: PO_LOG.stmt (d_module, d_position, 'override_funds', PO_PDOI_PARAMS.g_profile.override_funds);
864: PO_LOG.stmt (d_module, d_position, 'xbg', PO_PDOI_PARAMS.g_profile.xbg);
865: PO_LOG.stmt (d_module, d_position, 'po_price_update_tolerance', PO_PDOI_PARAMS.g_profile.po_price_update_tolerance);
866: PO_LOG.stmt (d_module, d_position, 'allow_tax_rate_override', PO_PDOI_PARAMS.g_profile.allow_tax_rate_override);
867: PO_LOG.stmt (d_module, d_position, 'allow_tax_code_override', PO_PDOI_PARAMS.g_profile.allow_tax_code_override);
868: END IF;
869:
870: IF (PO_LOG.d_proc) THEN
863: PO_LOG.stmt (d_module, d_position, 'override_funds', PO_PDOI_PARAMS.g_profile.override_funds);
864: PO_LOG.stmt (d_module, d_position, 'xbg', PO_PDOI_PARAMS.g_profile.xbg);
865: PO_LOG.stmt (d_module, d_position, 'po_price_update_tolerance', PO_PDOI_PARAMS.g_profile.po_price_update_tolerance);
866: PO_LOG.stmt (d_module, d_position, 'allow_tax_rate_override', PO_PDOI_PARAMS.g_profile.allow_tax_rate_override);
867: PO_LOG.stmt (d_module, d_position, 'allow_tax_code_override', PO_PDOI_PARAMS.g_profile.allow_tax_code_override);
868: END IF;
869:
870: IF (PO_LOG.d_proc) THEN
871: PO_LOG.proc_end (d_module);
884: --Start of Comments
885: --Name: init_product_parameters
886: --Function:
887: -- Derive necessary product installation status and populate the same
888: -- to PO_PDOI_PARAMS.g_product record
889: --Parameters:
890: --IN:
891: --IN OUT:
892: --OUT:
905: PO_LOG.proc_begin (d_module);
906: END IF;
907:
908: IF (PO_CORE_S.get_product_install_status('WIP') = 'I') THEN
909: PO_PDOI_PARAMS.g_product.wip_installed := FND_API.G_TRUE;
910: ELSE
911: PO_PDOI_PARAMS.g_product.wip_installed := FND_API.G_FALSE;
912: END IF;
913:
907:
908: IF (PO_CORE_S.get_product_install_status('WIP') = 'I') THEN
909: PO_PDOI_PARAMS.g_product.wip_installed := FND_API.G_TRUE;
910: ELSE
911: PO_PDOI_PARAMS.g_product.wip_installed := FND_API.G_FALSE;
912: END IF;
913:
914: IF (PO_CORE_S.get_product_install_status('INV') = 'I') THEN
915: PO_PDOI_PARAMS.g_product.inv_installed := FND_API.G_TRUE;
911: PO_PDOI_PARAMS.g_product.wip_installed := FND_API.G_FALSE;
912: END IF;
913:
914: IF (PO_CORE_S.get_product_install_status('INV') = 'I') THEN
915: PO_PDOI_PARAMS.g_product.inv_installed := FND_API.G_TRUE;
916: ELSE
917: PO_PDOI_PARAMS.g_product.inv_installed := FND_API.G_FALSE;
918: END IF;
919:
913:
914: IF (PO_CORE_S.get_product_install_status('INV') = 'I') THEN
915: PO_PDOI_PARAMS.g_product.inv_installed := FND_API.G_TRUE;
916: ELSE
917: PO_PDOI_PARAMS.g_product.inv_installed := FND_API.G_FALSE;
918: END IF;
919:
920: IF (PA_PO_INTEGRATION.is_pjc_11i10_enabled <> 'N') THEN
921: PO_PDOI_PARAMS.g_product.project_11510_installed := FND_API.G_TRUE;
917: PO_PDOI_PARAMS.g_product.inv_installed := FND_API.G_FALSE;
918: END IF;
919:
920: IF (PA_PO_INTEGRATION.is_pjc_11i10_enabled <> 'N') THEN
921: PO_PDOI_PARAMS.g_product.project_11510_installed := FND_API.G_TRUE;
922: ELSE
923: PO_PDOI_PARAMS.g_product.project_11510_installed := FND_API.G_FALSE;
924: END IF;
925:
919:
920: IF (PA_PO_INTEGRATION.is_pjc_11i10_enabled <> 'N') THEN
921: PO_PDOI_PARAMS.g_product.project_11510_installed := FND_API.G_TRUE;
922: ELSE
923: PO_PDOI_PARAMS.g_product.project_11510_installed := FND_API.G_FALSE;
924: END IF;
925:
926: IF (PO_CORE_S.get_product_install_status('PA') = 'I') THEN
927: PO_PDOI_PARAMS.g_product.pa_installed := FND_API.G_TRUE;
923: PO_PDOI_PARAMS.g_product.project_11510_installed := FND_API.G_FALSE;
924: END IF;
925:
926: IF (PO_CORE_S.get_product_install_status('PA') = 'I') THEN
927: PO_PDOI_PARAMS.g_product.pa_installed := FND_API.G_TRUE;
928: ELSE
929: PO_PDOI_PARAMS.g_product.pa_installed := FND_API.G_FALSE;
930: END IF;
931:
925:
926: IF (PO_CORE_S.get_product_install_status('PA') = 'I') THEN
927: PO_PDOI_PARAMS.g_product.pa_installed := FND_API.G_TRUE;
928: ELSE
929: PO_PDOI_PARAMS.g_product.pa_installed := FND_API.G_FALSE;
930: END IF;
931:
932: IF (GMS_PO_API_GRP.gms_enabled) THEN
933: PO_PDOI_PARAMS.g_product.gms_enabled := FND_API.G_TRUE;
929: PO_PDOI_PARAMS.g_product.pa_installed := FND_API.G_FALSE;
930: END IF;
931:
932: IF (GMS_PO_API_GRP.gms_enabled) THEN
933: PO_PDOI_PARAMS.g_product.gms_enabled := FND_API.G_TRUE;
934: ELSE
935: PO_PDOI_PARAMS.g_product.gms_enabled := FND_API.G_FALSE;
936: END IF;
937:
931:
932: IF (GMS_PO_API_GRP.gms_enabled) THEN
933: PO_PDOI_PARAMS.g_product.gms_enabled := FND_API.G_TRUE;
934: ELSE
935: PO_PDOI_PARAMS.g_product.gms_enabled := FND_API.G_FALSE;
936: END IF;
937:
938: IF (PA_PO_INTEGRATION.is_pjc_po_cwk_intg_enab <> 'N') THEN
939: PO_PDOI_PARAMS.g_product.project_cwk_installed := FND_API.G_TRUE;
935: PO_PDOI_PARAMS.g_product.gms_enabled := FND_API.G_FALSE;
936: END IF;
937:
938: IF (PA_PO_INTEGRATION.is_pjc_po_cwk_intg_enab <> 'N') THEN
939: PO_PDOI_PARAMS.g_product.project_cwk_installed := FND_API.G_TRUE;
940: ELSE
941: PO_PDOI_PARAMS.g_product.project_cwk_installed := FND_API.G_FALSE;
942: END IF;
943:
937:
938: IF (PA_PO_INTEGRATION.is_pjc_po_cwk_intg_enab <> 'N') THEN
939: PO_PDOI_PARAMS.g_product.project_cwk_installed := FND_API.G_TRUE;
940: ELSE
941: PO_PDOI_PARAMS.g_product.project_cwk_installed := FND_API.G_FALSE;
942: END IF;
943:
944: IF (PO_LOG.d_stmt) THEN
945: PO_LOG.stmt (d_module, d_position, 'wip_installed', PO_PDOI_PARAMS.g_product.wip_installed);
941: PO_PDOI_PARAMS.g_product.project_cwk_installed := FND_API.G_FALSE;
942: END IF;
943:
944: IF (PO_LOG.d_stmt) THEN
945: PO_LOG.stmt (d_module, d_position, 'wip_installed', PO_PDOI_PARAMS.g_product.wip_installed);
946: PO_LOG.stmt (d_module, d_position, 'inv_installed', PO_PDOI_PARAMS.g_product.inv_installed);
947: PO_LOG.stmt (d_module, d_position, 'project_11510_installed', PO_PDOI_PARAMS.g_product.project_11510_installed);
948: PO_LOG.stmt (d_module, d_position, 'pa_installed', PO_PDOI_PARAMS.g_product.pa_installed);
949: PO_LOG.stmt (d_module, d_position, 'gms_enabled', PO_PDOI_PARAMS.g_product.gms_enabled);
942: END IF;
943:
944: IF (PO_LOG.d_stmt) THEN
945: PO_LOG.stmt (d_module, d_position, 'wip_installed', PO_PDOI_PARAMS.g_product.wip_installed);
946: PO_LOG.stmt (d_module, d_position, 'inv_installed', PO_PDOI_PARAMS.g_product.inv_installed);
947: PO_LOG.stmt (d_module, d_position, 'project_11510_installed', PO_PDOI_PARAMS.g_product.project_11510_installed);
948: PO_LOG.stmt (d_module, d_position, 'pa_installed', PO_PDOI_PARAMS.g_product.pa_installed);
949: PO_LOG.stmt (d_module, d_position, 'gms_enabled', PO_PDOI_PARAMS.g_product.gms_enabled);
950: PO_LOG.stmt (d_module, d_position, 'project_cwk_installed', PO_PDOI_PARAMS.g_product.project_cwk_installed);
943:
944: IF (PO_LOG.d_stmt) THEN
945: PO_LOG.stmt (d_module, d_position, 'wip_installed', PO_PDOI_PARAMS.g_product.wip_installed);
946: PO_LOG.stmt (d_module, d_position, 'inv_installed', PO_PDOI_PARAMS.g_product.inv_installed);
947: PO_LOG.stmt (d_module, d_position, 'project_11510_installed', PO_PDOI_PARAMS.g_product.project_11510_installed);
948: PO_LOG.stmt (d_module, d_position, 'pa_installed', PO_PDOI_PARAMS.g_product.pa_installed);
949: PO_LOG.stmt (d_module, d_position, 'gms_enabled', PO_PDOI_PARAMS.g_product.gms_enabled);
950: PO_LOG.stmt (d_module, d_position, 'project_cwk_installed', PO_PDOI_PARAMS.g_product.project_cwk_installed);
951: END IF;
944: IF (PO_LOG.d_stmt) THEN
945: PO_LOG.stmt (d_module, d_position, 'wip_installed', PO_PDOI_PARAMS.g_product.wip_installed);
946: PO_LOG.stmt (d_module, d_position, 'inv_installed', PO_PDOI_PARAMS.g_product.inv_installed);
947: PO_LOG.stmt (d_module, d_position, 'project_11510_installed', PO_PDOI_PARAMS.g_product.project_11510_installed);
948: PO_LOG.stmt (d_module, d_position, 'pa_installed', PO_PDOI_PARAMS.g_product.pa_installed);
949: PO_LOG.stmt (d_module, d_position, 'gms_enabled', PO_PDOI_PARAMS.g_product.gms_enabled);
950: PO_LOG.stmt (d_module, d_position, 'project_cwk_installed', PO_PDOI_PARAMS.g_product.project_cwk_installed);
951: END IF;
952:
945: PO_LOG.stmt (d_module, d_position, 'wip_installed', PO_PDOI_PARAMS.g_product.wip_installed);
946: PO_LOG.stmt (d_module, d_position, 'inv_installed', PO_PDOI_PARAMS.g_product.inv_installed);
947: PO_LOG.stmt (d_module, d_position, 'project_11510_installed', PO_PDOI_PARAMS.g_product.project_11510_installed);
948: PO_LOG.stmt (d_module, d_position, 'pa_installed', PO_PDOI_PARAMS.g_product.pa_installed);
949: PO_LOG.stmt (d_module, d_position, 'gms_enabled', PO_PDOI_PARAMS.g_product.gms_enabled);
950: PO_LOG.stmt (d_module, d_position, 'project_cwk_installed', PO_PDOI_PARAMS.g_product.project_cwk_installed);
951: END IF;
952:
953: IF (PO_LOG.d_proc) THEN
946: PO_LOG.stmt (d_module, d_position, 'inv_installed', PO_PDOI_PARAMS.g_product.inv_installed);
947: PO_LOG.stmt (d_module, d_position, 'project_11510_installed', PO_PDOI_PARAMS.g_product.project_11510_installed);
948: PO_LOG.stmt (d_module, d_position, 'pa_installed', PO_PDOI_PARAMS.g_product.pa_installed);
949: PO_LOG.stmt (d_module, d_position, 'gms_enabled', PO_PDOI_PARAMS.g_product.gms_enabled);
950: PO_LOG.stmt (d_module, d_position, 'project_cwk_installed', PO_PDOI_PARAMS.g_product.project_cwk_installed);
951: END IF;
952:
953: IF (PO_LOG.d_proc) THEN
954: PO_LOG.proc_end (d_module);
1155: WHERE DFT.status = PO_DRAFTS_PVT.g_status_PDOI_PROCESSING
1156: AND DFT.draft_id IN
1157: (SELECT PHI.draft_id
1158: FROM po_headers_interface PHI
1159: WHERE PHI.processing_id IN (PO_PDOI_PARAMS.g_processing_id,
1160: -PO_PDOI_PARAMS.g_processing_id)
1161: AND PHI.processing_round_num=PO_PDOI_PARAMS.g_current_round_num);
1162:
1163: IF (PO_LOG.d_proc) THEN
1156: AND DFT.draft_id IN
1157: (SELECT PHI.draft_id
1158: FROM po_headers_interface PHI
1159: WHERE PHI.processing_id IN (PO_PDOI_PARAMS.g_processing_id,
1160: -PO_PDOI_PARAMS.g_processing_id)
1161: AND PHI.processing_round_num=PO_PDOI_PARAMS.g_current_round_num);
1162:
1163: IF (PO_LOG.d_proc) THEN
1164: PO_LOG.proc_end (d_module);
1157: (SELECT PHI.draft_id
1158: FROM po_headers_interface PHI
1159: WHERE PHI.processing_id IN (PO_PDOI_PARAMS.g_processing_id,
1160: -PO_PDOI_PARAMS.g_processing_id)
1161: AND PHI.processing_round_num=PO_PDOI_PARAMS.g_current_round_num);
1162:
1163: IF (PO_LOG.d_proc) THEN
1164: PO_LOG.proc_end (d_module);
1165: END IF;