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