eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.OKS_MASS_UPDATE_PVT dependencies on OKC_API

Line 409: x_return_status := okc_api.g_ret_sts_unexp_error;

405:
406: NULL;
407: WHEN OTHERS
408: THEN
409: x_return_status := okc_api.g_ret_sts_unexp_error;
410: fnd_file.put_line(fnd_file.log,' Error while creating the transaction sourec : '
411: || SQLCODE||':'|| SQLERRM );
412: okc_api.set_message (g_app_name,
413: g_unexpected_error,

Line 412: okc_api.set_message (g_app_name,

408: THEN
409: x_return_status := okc_api.g_ret_sts_unexp_error;
410: fnd_file.put_line(fnd_file.log,' Error while creating the transaction sourec : '
411: || SQLCODE||':'|| SQLERRM );
412: okc_api.set_message (g_app_name,
413: g_unexpected_error,
414: g_sqlcode_token,
415: SQLCODE,
416: g_sqlerrm_token,

Line 584: OKC_API.SET_MESSAGE(

580: CLOSE l_sts_csr;
581: END IF;
582: EXCEPTION
583: WHEN OTHERS THEN
584: OKC_API.SET_MESSAGE(
585: g_app_name,
586: g_unexpected_error,
587: g_sqlcode_token,
588: SQLCODE,

Line 613: x_okc_hdr_tbl (p_index).ID := okc_api.g_miss_num;

609: 'Begin'
610: );
611: END IF;
612:
613: x_okc_hdr_tbl (p_index).ID := okc_api.g_miss_num;
614: x_okc_hdr_tbl (p_index).object_version_number := okc_api.g_miss_num;
615: x_okc_hdr_tbl (p_index).sfwt_flag := okc_api.g_miss_char;
616: x_okc_hdr_tbl (p_index).chr_id_response := okc_api.g_miss_num;
617: x_okc_hdr_tbl (p_index).chr_id_award := okc_api.g_miss_num;

Line 614: x_okc_hdr_tbl (p_index).object_version_number := okc_api.g_miss_num;

610: );
611: END IF;
612:
613: x_okc_hdr_tbl (p_index).ID := okc_api.g_miss_num;
614: x_okc_hdr_tbl (p_index).object_version_number := okc_api.g_miss_num;
615: x_okc_hdr_tbl (p_index).sfwt_flag := okc_api.g_miss_char;
616: x_okc_hdr_tbl (p_index).chr_id_response := okc_api.g_miss_num;
617: x_okc_hdr_tbl (p_index).chr_id_award := okc_api.g_miss_num;
618: x_okc_hdr_tbl (p_index).chr_id_renewed := okc_api.g_miss_num;

Line 615: x_okc_hdr_tbl (p_index).sfwt_flag := okc_api.g_miss_char;

611: END IF;
612:
613: x_okc_hdr_tbl (p_index).ID := okc_api.g_miss_num;
614: x_okc_hdr_tbl (p_index).object_version_number := okc_api.g_miss_num;
615: x_okc_hdr_tbl (p_index).sfwt_flag := okc_api.g_miss_char;
616: x_okc_hdr_tbl (p_index).chr_id_response := okc_api.g_miss_num;
617: x_okc_hdr_tbl (p_index).chr_id_award := okc_api.g_miss_num;
618: x_okc_hdr_tbl (p_index).chr_id_renewed := okc_api.g_miss_num;
619: x_okc_hdr_tbl (p_index).inv_organization_id := okc_api.g_miss_num;

Line 616: x_okc_hdr_tbl (p_index).chr_id_response := okc_api.g_miss_num;

612:
613: x_okc_hdr_tbl (p_index).ID := okc_api.g_miss_num;
614: x_okc_hdr_tbl (p_index).object_version_number := okc_api.g_miss_num;
615: x_okc_hdr_tbl (p_index).sfwt_flag := okc_api.g_miss_char;
616: x_okc_hdr_tbl (p_index).chr_id_response := okc_api.g_miss_num;
617: x_okc_hdr_tbl (p_index).chr_id_award := okc_api.g_miss_num;
618: x_okc_hdr_tbl (p_index).chr_id_renewed := okc_api.g_miss_num;
619: x_okc_hdr_tbl (p_index).inv_organization_id := okc_api.g_miss_num;
620: x_okc_hdr_tbl (p_index).sts_code := okc_api.g_miss_char;

Line 617: x_okc_hdr_tbl (p_index).chr_id_award := okc_api.g_miss_num;

613: x_okc_hdr_tbl (p_index).ID := okc_api.g_miss_num;
614: x_okc_hdr_tbl (p_index).object_version_number := okc_api.g_miss_num;
615: x_okc_hdr_tbl (p_index).sfwt_flag := okc_api.g_miss_char;
616: x_okc_hdr_tbl (p_index).chr_id_response := okc_api.g_miss_num;
617: x_okc_hdr_tbl (p_index).chr_id_award := okc_api.g_miss_num;
618: x_okc_hdr_tbl (p_index).chr_id_renewed := okc_api.g_miss_num;
619: x_okc_hdr_tbl (p_index).inv_organization_id := okc_api.g_miss_num;
620: x_okc_hdr_tbl (p_index).sts_code := okc_api.g_miss_char;
621: x_okc_hdr_tbl (p_index).qcl_id := okc_api.g_miss_num;

Line 618: x_okc_hdr_tbl (p_index).chr_id_renewed := okc_api.g_miss_num;

614: x_okc_hdr_tbl (p_index).object_version_number := okc_api.g_miss_num;
615: x_okc_hdr_tbl (p_index).sfwt_flag := okc_api.g_miss_char;
616: x_okc_hdr_tbl (p_index).chr_id_response := okc_api.g_miss_num;
617: x_okc_hdr_tbl (p_index).chr_id_award := okc_api.g_miss_num;
618: x_okc_hdr_tbl (p_index).chr_id_renewed := okc_api.g_miss_num;
619: x_okc_hdr_tbl (p_index).inv_organization_id := okc_api.g_miss_num;
620: x_okc_hdr_tbl (p_index).sts_code := okc_api.g_miss_char;
621: x_okc_hdr_tbl (p_index).qcl_id := okc_api.g_miss_num;
622: x_okc_hdr_tbl (p_index).scs_code := okc_api.g_miss_char;

Line 619: x_okc_hdr_tbl (p_index).inv_organization_id := okc_api.g_miss_num;

615: x_okc_hdr_tbl (p_index).sfwt_flag := okc_api.g_miss_char;
616: x_okc_hdr_tbl (p_index).chr_id_response := okc_api.g_miss_num;
617: x_okc_hdr_tbl (p_index).chr_id_award := okc_api.g_miss_num;
618: x_okc_hdr_tbl (p_index).chr_id_renewed := okc_api.g_miss_num;
619: x_okc_hdr_tbl (p_index).inv_organization_id := okc_api.g_miss_num;
620: x_okc_hdr_tbl (p_index).sts_code := okc_api.g_miss_char;
621: x_okc_hdr_tbl (p_index).qcl_id := okc_api.g_miss_num;
622: x_okc_hdr_tbl (p_index).scs_code := okc_api.g_miss_char;
623: x_okc_hdr_tbl (p_index).contract_number := okc_api.g_miss_char;

Line 620: x_okc_hdr_tbl (p_index).sts_code := okc_api.g_miss_char;

616: x_okc_hdr_tbl (p_index).chr_id_response := okc_api.g_miss_num;
617: x_okc_hdr_tbl (p_index).chr_id_award := okc_api.g_miss_num;
618: x_okc_hdr_tbl (p_index).chr_id_renewed := okc_api.g_miss_num;
619: x_okc_hdr_tbl (p_index).inv_organization_id := okc_api.g_miss_num;
620: x_okc_hdr_tbl (p_index).sts_code := okc_api.g_miss_char;
621: x_okc_hdr_tbl (p_index).qcl_id := okc_api.g_miss_num;
622: x_okc_hdr_tbl (p_index).scs_code := okc_api.g_miss_char;
623: x_okc_hdr_tbl (p_index).contract_number := okc_api.g_miss_char;
624: x_okc_hdr_tbl (p_index).currency_code := okc_api.g_miss_char;

Line 621: x_okc_hdr_tbl (p_index).qcl_id := okc_api.g_miss_num;

617: x_okc_hdr_tbl (p_index).chr_id_award := okc_api.g_miss_num;
618: x_okc_hdr_tbl (p_index).chr_id_renewed := okc_api.g_miss_num;
619: x_okc_hdr_tbl (p_index).inv_organization_id := okc_api.g_miss_num;
620: x_okc_hdr_tbl (p_index).sts_code := okc_api.g_miss_char;
621: x_okc_hdr_tbl (p_index).qcl_id := okc_api.g_miss_num;
622: x_okc_hdr_tbl (p_index).scs_code := okc_api.g_miss_char;
623: x_okc_hdr_tbl (p_index).contract_number := okc_api.g_miss_char;
624: x_okc_hdr_tbl (p_index).currency_code := okc_api.g_miss_char;
625: x_okc_hdr_tbl (p_index).contract_number_modifier := okc_api.g_miss_char;

Line 622: x_okc_hdr_tbl (p_index).scs_code := okc_api.g_miss_char;

618: x_okc_hdr_tbl (p_index).chr_id_renewed := okc_api.g_miss_num;
619: x_okc_hdr_tbl (p_index).inv_organization_id := okc_api.g_miss_num;
620: x_okc_hdr_tbl (p_index).sts_code := okc_api.g_miss_char;
621: x_okc_hdr_tbl (p_index).qcl_id := okc_api.g_miss_num;
622: x_okc_hdr_tbl (p_index).scs_code := okc_api.g_miss_char;
623: x_okc_hdr_tbl (p_index).contract_number := okc_api.g_miss_char;
624: x_okc_hdr_tbl (p_index).currency_code := okc_api.g_miss_char;
625: x_okc_hdr_tbl (p_index).contract_number_modifier := okc_api.g_miss_char;
626: x_okc_hdr_tbl (p_index).archived_yn := okc_api.g_miss_char;

Line 623: x_okc_hdr_tbl (p_index).contract_number := okc_api.g_miss_char;

619: x_okc_hdr_tbl (p_index).inv_organization_id := okc_api.g_miss_num;
620: x_okc_hdr_tbl (p_index).sts_code := okc_api.g_miss_char;
621: x_okc_hdr_tbl (p_index).qcl_id := okc_api.g_miss_num;
622: x_okc_hdr_tbl (p_index).scs_code := okc_api.g_miss_char;
623: x_okc_hdr_tbl (p_index).contract_number := okc_api.g_miss_char;
624: x_okc_hdr_tbl (p_index).currency_code := okc_api.g_miss_char;
625: x_okc_hdr_tbl (p_index).contract_number_modifier := okc_api.g_miss_char;
626: x_okc_hdr_tbl (p_index).archived_yn := okc_api.g_miss_char;
627: x_okc_hdr_tbl (p_index).deleted_yn := okc_api.g_miss_char;

Line 624: x_okc_hdr_tbl (p_index).currency_code := okc_api.g_miss_char;

620: x_okc_hdr_tbl (p_index).sts_code := okc_api.g_miss_char;
621: x_okc_hdr_tbl (p_index).qcl_id := okc_api.g_miss_num;
622: x_okc_hdr_tbl (p_index).scs_code := okc_api.g_miss_char;
623: x_okc_hdr_tbl (p_index).contract_number := okc_api.g_miss_char;
624: x_okc_hdr_tbl (p_index).currency_code := okc_api.g_miss_char;
625: x_okc_hdr_tbl (p_index).contract_number_modifier := okc_api.g_miss_char;
626: x_okc_hdr_tbl (p_index).archived_yn := okc_api.g_miss_char;
627: x_okc_hdr_tbl (p_index).deleted_yn := okc_api.g_miss_char;
628: x_okc_hdr_tbl (p_index).cust_po_number_req_yn := okc_api.g_miss_char;

Line 625: x_okc_hdr_tbl (p_index).contract_number_modifier := okc_api.g_miss_char;

621: x_okc_hdr_tbl (p_index).qcl_id := okc_api.g_miss_num;
622: x_okc_hdr_tbl (p_index).scs_code := okc_api.g_miss_char;
623: x_okc_hdr_tbl (p_index).contract_number := okc_api.g_miss_char;
624: x_okc_hdr_tbl (p_index).currency_code := okc_api.g_miss_char;
625: x_okc_hdr_tbl (p_index).contract_number_modifier := okc_api.g_miss_char;
626: x_okc_hdr_tbl (p_index).archived_yn := okc_api.g_miss_char;
627: x_okc_hdr_tbl (p_index).deleted_yn := okc_api.g_miss_char;
628: x_okc_hdr_tbl (p_index).cust_po_number_req_yn := okc_api.g_miss_char;
629: x_okc_hdr_tbl (p_index).pre_pay_req_yn := okc_api.g_miss_char;

Line 626: x_okc_hdr_tbl (p_index).archived_yn := okc_api.g_miss_char;

622: x_okc_hdr_tbl (p_index).scs_code := okc_api.g_miss_char;
623: x_okc_hdr_tbl (p_index).contract_number := okc_api.g_miss_char;
624: x_okc_hdr_tbl (p_index).currency_code := okc_api.g_miss_char;
625: x_okc_hdr_tbl (p_index).contract_number_modifier := okc_api.g_miss_char;
626: x_okc_hdr_tbl (p_index).archived_yn := okc_api.g_miss_char;
627: x_okc_hdr_tbl (p_index).deleted_yn := okc_api.g_miss_char;
628: x_okc_hdr_tbl (p_index).cust_po_number_req_yn := okc_api.g_miss_char;
629: x_okc_hdr_tbl (p_index).pre_pay_req_yn := okc_api.g_miss_char;
630: x_okc_hdr_tbl (p_index).cust_po_number := okc_api.g_miss_char;

Line 627: x_okc_hdr_tbl (p_index).deleted_yn := okc_api.g_miss_char;

623: x_okc_hdr_tbl (p_index).contract_number := okc_api.g_miss_char;
624: x_okc_hdr_tbl (p_index).currency_code := okc_api.g_miss_char;
625: x_okc_hdr_tbl (p_index).contract_number_modifier := okc_api.g_miss_char;
626: x_okc_hdr_tbl (p_index).archived_yn := okc_api.g_miss_char;
627: x_okc_hdr_tbl (p_index).deleted_yn := okc_api.g_miss_char;
628: x_okc_hdr_tbl (p_index).cust_po_number_req_yn := okc_api.g_miss_char;
629: x_okc_hdr_tbl (p_index).pre_pay_req_yn := okc_api.g_miss_char;
630: x_okc_hdr_tbl (p_index).cust_po_number := okc_api.g_miss_char;
631: x_okc_hdr_tbl (p_index).short_description := okc_api.g_miss_char;

Line 628: x_okc_hdr_tbl (p_index).cust_po_number_req_yn := okc_api.g_miss_char;

624: x_okc_hdr_tbl (p_index).currency_code := okc_api.g_miss_char;
625: x_okc_hdr_tbl (p_index).contract_number_modifier := okc_api.g_miss_char;
626: x_okc_hdr_tbl (p_index).archived_yn := okc_api.g_miss_char;
627: x_okc_hdr_tbl (p_index).deleted_yn := okc_api.g_miss_char;
628: x_okc_hdr_tbl (p_index).cust_po_number_req_yn := okc_api.g_miss_char;
629: x_okc_hdr_tbl (p_index).pre_pay_req_yn := okc_api.g_miss_char;
630: x_okc_hdr_tbl (p_index).cust_po_number := okc_api.g_miss_char;
631: x_okc_hdr_tbl (p_index).short_description := okc_api.g_miss_char;
632: x_okc_hdr_tbl (p_index).comments := okc_api.g_miss_char;

Line 629: x_okc_hdr_tbl (p_index).pre_pay_req_yn := okc_api.g_miss_char;

625: x_okc_hdr_tbl (p_index).contract_number_modifier := okc_api.g_miss_char;
626: x_okc_hdr_tbl (p_index).archived_yn := okc_api.g_miss_char;
627: x_okc_hdr_tbl (p_index).deleted_yn := okc_api.g_miss_char;
628: x_okc_hdr_tbl (p_index).cust_po_number_req_yn := okc_api.g_miss_char;
629: x_okc_hdr_tbl (p_index).pre_pay_req_yn := okc_api.g_miss_char;
630: x_okc_hdr_tbl (p_index).cust_po_number := okc_api.g_miss_char;
631: x_okc_hdr_tbl (p_index).short_description := okc_api.g_miss_char;
632: x_okc_hdr_tbl (p_index).comments := okc_api.g_miss_char;
633: x_okc_hdr_tbl (p_index).description := okc_api.g_miss_char;

Line 630: x_okc_hdr_tbl (p_index).cust_po_number := okc_api.g_miss_char;

626: x_okc_hdr_tbl (p_index).archived_yn := okc_api.g_miss_char;
627: x_okc_hdr_tbl (p_index).deleted_yn := okc_api.g_miss_char;
628: x_okc_hdr_tbl (p_index).cust_po_number_req_yn := okc_api.g_miss_char;
629: x_okc_hdr_tbl (p_index).pre_pay_req_yn := okc_api.g_miss_char;
630: x_okc_hdr_tbl (p_index).cust_po_number := okc_api.g_miss_char;
631: x_okc_hdr_tbl (p_index).short_description := okc_api.g_miss_char;
632: x_okc_hdr_tbl (p_index).comments := okc_api.g_miss_char;
633: x_okc_hdr_tbl (p_index).description := okc_api.g_miss_char;
634: x_okc_hdr_tbl (p_index).dpas_rating := okc_api.g_miss_char;

Line 631: x_okc_hdr_tbl (p_index).short_description := okc_api.g_miss_char;

627: x_okc_hdr_tbl (p_index).deleted_yn := okc_api.g_miss_char;
628: x_okc_hdr_tbl (p_index).cust_po_number_req_yn := okc_api.g_miss_char;
629: x_okc_hdr_tbl (p_index).pre_pay_req_yn := okc_api.g_miss_char;
630: x_okc_hdr_tbl (p_index).cust_po_number := okc_api.g_miss_char;
631: x_okc_hdr_tbl (p_index).short_description := okc_api.g_miss_char;
632: x_okc_hdr_tbl (p_index).comments := okc_api.g_miss_char;
633: x_okc_hdr_tbl (p_index).description := okc_api.g_miss_char;
634: x_okc_hdr_tbl (p_index).dpas_rating := okc_api.g_miss_char;
635: x_okc_hdr_tbl (p_index).cognomen := okc_api.g_miss_char;

Line 632: x_okc_hdr_tbl (p_index).comments := okc_api.g_miss_char;

628: x_okc_hdr_tbl (p_index).cust_po_number_req_yn := okc_api.g_miss_char;
629: x_okc_hdr_tbl (p_index).pre_pay_req_yn := okc_api.g_miss_char;
630: x_okc_hdr_tbl (p_index).cust_po_number := okc_api.g_miss_char;
631: x_okc_hdr_tbl (p_index).short_description := okc_api.g_miss_char;
632: x_okc_hdr_tbl (p_index).comments := okc_api.g_miss_char;
633: x_okc_hdr_tbl (p_index).description := okc_api.g_miss_char;
634: x_okc_hdr_tbl (p_index).dpas_rating := okc_api.g_miss_char;
635: x_okc_hdr_tbl (p_index).cognomen := okc_api.g_miss_char;
636: x_okc_hdr_tbl (p_index).template_yn := okc_api.g_miss_char;

Line 633: x_okc_hdr_tbl (p_index).description := okc_api.g_miss_char;

629: x_okc_hdr_tbl (p_index).pre_pay_req_yn := okc_api.g_miss_char;
630: x_okc_hdr_tbl (p_index).cust_po_number := okc_api.g_miss_char;
631: x_okc_hdr_tbl (p_index).short_description := okc_api.g_miss_char;
632: x_okc_hdr_tbl (p_index).comments := okc_api.g_miss_char;
633: x_okc_hdr_tbl (p_index).description := okc_api.g_miss_char;
634: x_okc_hdr_tbl (p_index).dpas_rating := okc_api.g_miss_char;
635: x_okc_hdr_tbl (p_index).cognomen := okc_api.g_miss_char;
636: x_okc_hdr_tbl (p_index).template_yn := okc_api.g_miss_char;
637: x_okc_hdr_tbl (p_index).template_used := okc_api.g_miss_char;

Line 634: x_okc_hdr_tbl (p_index).dpas_rating := okc_api.g_miss_char;

630: x_okc_hdr_tbl (p_index).cust_po_number := okc_api.g_miss_char;
631: x_okc_hdr_tbl (p_index).short_description := okc_api.g_miss_char;
632: x_okc_hdr_tbl (p_index).comments := okc_api.g_miss_char;
633: x_okc_hdr_tbl (p_index).description := okc_api.g_miss_char;
634: x_okc_hdr_tbl (p_index).dpas_rating := okc_api.g_miss_char;
635: x_okc_hdr_tbl (p_index).cognomen := okc_api.g_miss_char;
636: x_okc_hdr_tbl (p_index).template_yn := okc_api.g_miss_char;
637: x_okc_hdr_tbl (p_index).template_used := okc_api.g_miss_char;
638: x_okc_hdr_tbl (p_index).date_approved := okc_api.g_miss_date;

Line 635: x_okc_hdr_tbl (p_index).cognomen := okc_api.g_miss_char;

631: x_okc_hdr_tbl (p_index).short_description := okc_api.g_miss_char;
632: x_okc_hdr_tbl (p_index).comments := okc_api.g_miss_char;
633: x_okc_hdr_tbl (p_index).description := okc_api.g_miss_char;
634: x_okc_hdr_tbl (p_index).dpas_rating := okc_api.g_miss_char;
635: x_okc_hdr_tbl (p_index).cognomen := okc_api.g_miss_char;
636: x_okc_hdr_tbl (p_index).template_yn := okc_api.g_miss_char;
637: x_okc_hdr_tbl (p_index).template_used := okc_api.g_miss_char;
638: x_okc_hdr_tbl (p_index).date_approved := okc_api.g_miss_date;
639: x_okc_hdr_tbl (p_index).datetime_cancelled := okc_api.g_miss_date;

Line 636: x_okc_hdr_tbl (p_index).template_yn := okc_api.g_miss_char;

632: x_okc_hdr_tbl (p_index).comments := okc_api.g_miss_char;
633: x_okc_hdr_tbl (p_index).description := okc_api.g_miss_char;
634: x_okc_hdr_tbl (p_index).dpas_rating := okc_api.g_miss_char;
635: x_okc_hdr_tbl (p_index).cognomen := okc_api.g_miss_char;
636: x_okc_hdr_tbl (p_index).template_yn := okc_api.g_miss_char;
637: x_okc_hdr_tbl (p_index).template_used := okc_api.g_miss_char;
638: x_okc_hdr_tbl (p_index).date_approved := okc_api.g_miss_date;
639: x_okc_hdr_tbl (p_index).datetime_cancelled := okc_api.g_miss_date;
640: x_okc_hdr_tbl (p_index).auto_renew_days := okc_api.g_miss_num;

Line 637: x_okc_hdr_tbl (p_index).template_used := okc_api.g_miss_char;

633: x_okc_hdr_tbl (p_index).description := okc_api.g_miss_char;
634: x_okc_hdr_tbl (p_index).dpas_rating := okc_api.g_miss_char;
635: x_okc_hdr_tbl (p_index).cognomen := okc_api.g_miss_char;
636: x_okc_hdr_tbl (p_index).template_yn := okc_api.g_miss_char;
637: x_okc_hdr_tbl (p_index).template_used := okc_api.g_miss_char;
638: x_okc_hdr_tbl (p_index).date_approved := okc_api.g_miss_date;
639: x_okc_hdr_tbl (p_index).datetime_cancelled := okc_api.g_miss_date;
640: x_okc_hdr_tbl (p_index).auto_renew_days := okc_api.g_miss_num;
641: x_okc_hdr_tbl (p_index).date_issued := okc_api.g_miss_date;

Line 638: x_okc_hdr_tbl (p_index).date_approved := okc_api.g_miss_date;

634: x_okc_hdr_tbl (p_index).dpas_rating := okc_api.g_miss_char;
635: x_okc_hdr_tbl (p_index).cognomen := okc_api.g_miss_char;
636: x_okc_hdr_tbl (p_index).template_yn := okc_api.g_miss_char;
637: x_okc_hdr_tbl (p_index).template_used := okc_api.g_miss_char;
638: x_okc_hdr_tbl (p_index).date_approved := okc_api.g_miss_date;
639: x_okc_hdr_tbl (p_index).datetime_cancelled := okc_api.g_miss_date;
640: x_okc_hdr_tbl (p_index).auto_renew_days := okc_api.g_miss_num;
641: x_okc_hdr_tbl (p_index).date_issued := okc_api.g_miss_date;
642: x_okc_hdr_tbl (p_index).datetime_responded := okc_api.g_miss_date;

Line 639: x_okc_hdr_tbl (p_index).datetime_cancelled := okc_api.g_miss_date;

635: x_okc_hdr_tbl (p_index).cognomen := okc_api.g_miss_char;
636: x_okc_hdr_tbl (p_index).template_yn := okc_api.g_miss_char;
637: x_okc_hdr_tbl (p_index).template_used := okc_api.g_miss_char;
638: x_okc_hdr_tbl (p_index).date_approved := okc_api.g_miss_date;
639: x_okc_hdr_tbl (p_index).datetime_cancelled := okc_api.g_miss_date;
640: x_okc_hdr_tbl (p_index).auto_renew_days := okc_api.g_miss_num;
641: x_okc_hdr_tbl (p_index).date_issued := okc_api.g_miss_date;
642: x_okc_hdr_tbl (p_index).datetime_responded := okc_api.g_miss_date;
643: x_okc_hdr_tbl (p_index).non_response_reason := okc_api.g_miss_char;

Line 640: x_okc_hdr_tbl (p_index).auto_renew_days := okc_api.g_miss_num;

636: x_okc_hdr_tbl (p_index).template_yn := okc_api.g_miss_char;
637: x_okc_hdr_tbl (p_index).template_used := okc_api.g_miss_char;
638: x_okc_hdr_tbl (p_index).date_approved := okc_api.g_miss_date;
639: x_okc_hdr_tbl (p_index).datetime_cancelled := okc_api.g_miss_date;
640: x_okc_hdr_tbl (p_index).auto_renew_days := okc_api.g_miss_num;
641: x_okc_hdr_tbl (p_index).date_issued := okc_api.g_miss_date;
642: x_okc_hdr_tbl (p_index).datetime_responded := okc_api.g_miss_date;
643: x_okc_hdr_tbl (p_index).non_response_reason := okc_api.g_miss_char;
644: x_okc_hdr_tbl (p_index).non_response_explain := okc_api.g_miss_char;

Line 641: x_okc_hdr_tbl (p_index).date_issued := okc_api.g_miss_date;

637: x_okc_hdr_tbl (p_index).template_used := okc_api.g_miss_char;
638: x_okc_hdr_tbl (p_index).date_approved := okc_api.g_miss_date;
639: x_okc_hdr_tbl (p_index).datetime_cancelled := okc_api.g_miss_date;
640: x_okc_hdr_tbl (p_index).auto_renew_days := okc_api.g_miss_num;
641: x_okc_hdr_tbl (p_index).date_issued := okc_api.g_miss_date;
642: x_okc_hdr_tbl (p_index).datetime_responded := okc_api.g_miss_date;
643: x_okc_hdr_tbl (p_index).non_response_reason := okc_api.g_miss_char;
644: x_okc_hdr_tbl (p_index).non_response_explain := okc_api.g_miss_char;
645: x_okc_hdr_tbl (p_index).rfp_type := okc_api.g_miss_char;

Line 642: x_okc_hdr_tbl (p_index).datetime_responded := okc_api.g_miss_date;

638: x_okc_hdr_tbl (p_index).date_approved := okc_api.g_miss_date;
639: x_okc_hdr_tbl (p_index).datetime_cancelled := okc_api.g_miss_date;
640: x_okc_hdr_tbl (p_index).auto_renew_days := okc_api.g_miss_num;
641: x_okc_hdr_tbl (p_index).date_issued := okc_api.g_miss_date;
642: x_okc_hdr_tbl (p_index).datetime_responded := okc_api.g_miss_date;
643: x_okc_hdr_tbl (p_index).non_response_reason := okc_api.g_miss_char;
644: x_okc_hdr_tbl (p_index).non_response_explain := okc_api.g_miss_char;
645: x_okc_hdr_tbl (p_index).rfp_type := okc_api.g_miss_char;
646: x_okc_hdr_tbl (p_index).chr_type := okc_api.g_miss_char;

Line 643: x_okc_hdr_tbl (p_index).non_response_reason := okc_api.g_miss_char;

639: x_okc_hdr_tbl (p_index).datetime_cancelled := okc_api.g_miss_date;
640: x_okc_hdr_tbl (p_index).auto_renew_days := okc_api.g_miss_num;
641: x_okc_hdr_tbl (p_index).date_issued := okc_api.g_miss_date;
642: x_okc_hdr_tbl (p_index).datetime_responded := okc_api.g_miss_date;
643: x_okc_hdr_tbl (p_index).non_response_reason := okc_api.g_miss_char;
644: x_okc_hdr_tbl (p_index).non_response_explain := okc_api.g_miss_char;
645: x_okc_hdr_tbl (p_index).rfp_type := okc_api.g_miss_char;
646: x_okc_hdr_tbl (p_index).chr_type := okc_api.g_miss_char;
647: x_okc_hdr_tbl (p_index).keep_on_mail_list := okc_api.g_miss_char;

Line 644: x_okc_hdr_tbl (p_index).non_response_explain := okc_api.g_miss_char;

640: x_okc_hdr_tbl (p_index).auto_renew_days := okc_api.g_miss_num;
641: x_okc_hdr_tbl (p_index).date_issued := okc_api.g_miss_date;
642: x_okc_hdr_tbl (p_index).datetime_responded := okc_api.g_miss_date;
643: x_okc_hdr_tbl (p_index).non_response_reason := okc_api.g_miss_char;
644: x_okc_hdr_tbl (p_index).non_response_explain := okc_api.g_miss_char;
645: x_okc_hdr_tbl (p_index).rfp_type := okc_api.g_miss_char;
646: x_okc_hdr_tbl (p_index).chr_type := okc_api.g_miss_char;
647: x_okc_hdr_tbl (p_index).keep_on_mail_list := okc_api.g_miss_char;
648: x_okc_hdr_tbl (p_index).set_aside_reason := okc_api.g_miss_char;

Line 645: x_okc_hdr_tbl (p_index).rfp_type := okc_api.g_miss_char;

641: x_okc_hdr_tbl (p_index).date_issued := okc_api.g_miss_date;
642: x_okc_hdr_tbl (p_index).datetime_responded := okc_api.g_miss_date;
643: x_okc_hdr_tbl (p_index).non_response_reason := okc_api.g_miss_char;
644: x_okc_hdr_tbl (p_index).non_response_explain := okc_api.g_miss_char;
645: x_okc_hdr_tbl (p_index).rfp_type := okc_api.g_miss_char;
646: x_okc_hdr_tbl (p_index).chr_type := okc_api.g_miss_char;
647: x_okc_hdr_tbl (p_index).keep_on_mail_list := okc_api.g_miss_char;
648: x_okc_hdr_tbl (p_index).set_aside_reason := okc_api.g_miss_char;
649: x_okc_hdr_tbl (p_index).set_aside_percent := okc_api.g_miss_num;

Line 646: x_okc_hdr_tbl (p_index).chr_type := okc_api.g_miss_char;

642: x_okc_hdr_tbl (p_index).datetime_responded := okc_api.g_miss_date;
643: x_okc_hdr_tbl (p_index).non_response_reason := okc_api.g_miss_char;
644: x_okc_hdr_tbl (p_index).non_response_explain := okc_api.g_miss_char;
645: x_okc_hdr_tbl (p_index).rfp_type := okc_api.g_miss_char;
646: x_okc_hdr_tbl (p_index).chr_type := okc_api.g_miss_char;
647: x_okc_hdr_tbl (p_index).keep_on_mail_list := okc_api.g_miss_char;
648: x_okc_hdr_tbl (p_index).set_aside_reason := okc_api.g_miss_char;
649: x_okc_hdr_tbl (p_index).set_aside_percent := okc_api.g_miss_num;
650: x_okc_hdr_tbl (p_index).response_copies_req := okc_api.g_miss_num;

Line 647: x_okc_hdr_tbl (p_index).keep_on_mail_list := okc_api.g_miss_char;

643: x_okc_hdr_tbl (p_index).non_response_reason := okc_api.g_miss_char;
644: x_okc_hdr_tbl (p_index).non_response_explain := okc_api.g_miss_char;
645: x_okc_hdr_tbl (p_index).rfp_type := okc_api.g_miss_char;
646: x_okc_hdr_tbl (p_index).chr_type := okc_api.g_miss_char;
647: x_okc_hdr_tbl (p_index).keep_on_mail_list := okc_api.g_miss_char;
648: x_okc_hdr_tbl (p_index).set_aside_reason := okc_api.g_miss_char;
649: x_okc_hdr_tbl (p_index).set_aside_percent := okc_api.g_miss_num;
650: x_okc_hdr_tbl (p_index).response_copies_req := okc_api.g_miss_num;
651: x_okc_hdr_tbl (p_index).date_close_projected := okc_api.g_miss_date;

Line 648: x_okc_hdr_tbl (p_index).set_aside_reason := okc_api.g_miss_char;

644: x_okc_hdr_tbl (p_index).non_response_explain := okc_api.g_miss_char;
645: x_okc_hdr_tbl (p_index).rfp_type := okc_api.g_miss_char;
646: x_okc_hdr_tbl (p_index).chr_type := okc_api.g_miss_char;
647: x_okc_hdr_tbl (p_index).keep_on_mail_list := okc_api.g_miss_char;
648: x_okc_hdr_tbl (p_index).set_aside_reason := okc_api.g_miss_char;
649: x_okc_hdr_tbl (p_index).set_aside_percent := okc_api.g_miss_num;
650: x_okc_hdr_tbl (p_index).response_copies_req := okc_api.g_miss_num;
651: x_okc_hdr_tbl (p_index).date_close_projected := okc_api.g_miss_date;
652: x_okc_hdr_tbl (p_index).datetime_proposed := okc_api.g_miss_date;

Line 649: x_okc_hdr_tbl (p_index).set_aside_percent := okc_api.g_miss_num;

645: x_okc_hdr_tbl (p_index).rfp_type := okc_api.g_miss_char;
646: x_okc_hdr_tbl (p_index).chr_type := okc_api.g_miss_char;
647: x_okc_hdr_tbl (p_index).keep_on_mail_list := okc_api.g_miss_char;
648: x_okc_hdr_tbl (p_index).set_aside_reason := okc_api.g_miss_char;
649: x_okc_hdr_tbl (p_index).set_aside_percent := okc_api.g_miss_num;
650: x_okc_hdr_tbl (p_index).response_copies_req := okc_api.g_miss_num;
651: x_okc_hdr_tbl (p_index).date_close_projected := okc_api.g_miss_date;
652: x_okc_hdr_tbl (p_index).datetime_proposed := okc_api.g_miss_date;
653: x_okc_hdr_tbl (p_index).date_signed := okc_api.g_miss_date;

Line 650: x_okc_hdr_tbl (p_index).response_copies_req := okc_api.g_miss_num;

646: x_okc_hdr_tbl (p_index).chr_type := okc_api.g_miss_char;
647: x_okc_hdr_tbl (p_index).keep_on_mail_list := okc_api.g_miss_char;
648: x_okc_hdr_tbl (p_index).set_aside_reason := okc_api.g_miss_char;
649: x_okc_hdr_tbl (p_index).set_aside_percent := okc_api.g_miss_num;
650: x_okc_hdr_tbl (p_index).response_copies_req := okc_api.g_miss_num;
651: x_okc_hdr_tbl (p_index).date_close_projected := okc_api.g_miss_date;
652: x_okc_hdr_tbl (p_index).datetime_proposed := okc_api.g_miss_date;
653: x_okc_hdr_tbl (p_index).date_signed := okc_api.g_miss_date;
654: x_okc_hdr_tbl (p_index).date_terminated := okc_api.g_miss_date;

Line 651: x_okc_hdr_tbl (p_index).date_close_projected := okc_api.g_miss_date;

647: x_okc_hdr_tbl (p_index).keep_on_mail_list := okc_api.g_miss_char;
648: x_okc_hdr_tbl (p_index).set_aside_reason := okc_api.g_miss_char;
649: x_okc_hdr_tbl (p_index).set_aside_percent := okc_api.g_miss_num;
650: x_okc_hdr_tbl (p_index).response_copies_req := okc_api.g_miss_num;
651: x_okc_hdr_tbl (p_index).date_close_projected := okc_api.g_miss_date;
652: x_okc_hdr_tbl (p_index).datetime_proposed := okc_api.g_miss_date;
653: x_okc_hdr_tbl (p_index).date_signed := okc_api.g_miss_date;
654: x_okc_hdr_tbl (p_index).date_terminated := okc_api.g_miss_date;
655: x_okc_hdr_tbl (p_index).date_renewed := okc_api.g_miss_date;

Line 652: x_okc_hdr_tbl (p_index).datetime_proposed := okc_api.g_miss_date;

648: x_okc_hdr_tbl (p_index).set_aside_reason := okc_api.g_miss_char;
649: x_okc_hdr_tbl (p_index).set_aside_percent := okc_api.g_miss_num;
650: x_okc_hdr_tbl (p_index).response_copies_req := okc_api.g_miss_num;
651: x_okc_hdr_tbl (p_index).date_close_projected := okc_api.g_miss_date;
652: x_okc_hdr_tbl (p_index).datetime_proposed := okc_api.g_miss_date;
653: x_okc_hdr_tbl (p_index).date_signed := okc_api.g_miss_date;
654: x_okc_hdr_tbl (p_index).date_terminated := okc_api.g_miss_date;
655: x_okc_hdr_tbl (p_index).date_renewed := okc_api.g_miss_date;
656: x_okc_hdr_tbl (p_index).trn_code := okc_api.g_miss_char;

Line 653: x_okc_hdr_tbl (p_index).date_signed := okc_api.g_miss_date;

649: x_okc_hdr_tbl (p_index).set_aside_percent := okc_api.g_miss_num;
650: x_okc_hdr_tbl (p_index).response_copies_req := okc_api.g_miss_num;
651: x_okc_hdr_tbl (p_index).date_close_projected := okc_api.g_miss_date;
652: x_okc_hdr_tbl (p_index).datetime_proposed := okc_api.g_miss_date;
653: x_okc_hdr_tbl (p_index).date_signed := okc_api.g_miss_date;
654: x_okc_hdr_tbl (p_index).date_terminated := okc_api.g_miss_date;
655: x_okc_hdr_tbl (p_index).date_renewed := okc_api.g_miss_date;
656: x_okc_hdr_tbl (p_index).trn_code := okc_api.g_miss_char;
657: x_okc_hdr_tbl (p_index).start_date := okc_api.g_miss_date;

Line 654: x_okc_hdr_tbl (p_index).date_terminated := okc_api.g_miss_date;

650: x_okc_hdr_tbl (p_index).response_copies_req := okc_api.g_miss_num;
651: x_okc_hdr_tbl (p_index).date_close_projected := okc_api.g_miss_date;
652: x_okc_hdr_tbl (p_index).datetime_proposed := okc_api.g_miss_date;
653: x_okc_hdr_tbl (p_index).date_signed := okc_api.g_miss_date;
654: x_okc_hdr_tbl (p_index).date_terminated := okc_api.g_miss_date;
655: x_okc_hdr_tbl (p_index).date_renewed := okc_api.g_miss_date;
656: x_okc_hdr_tbl (p_index).trn_code := okc_api.g_miss_char;
657: x_okc_hdr_tbl (p_index).start_date := okc_api.g_miss_date;
658: x_okc_hdr_tbl (p_index).end_date := okc_api.g_miss_date;

Line 655: x_okc_hdr_tbl (p_index).date_renewed := okc_api.g_miss_date;

651: x_okc_hdr_tbl (p_index).date_close_projected := okc_api.g_miss_date;
652: x_okc_hdr_tbl (p_index).datetime_proposed := okc_api.g_miss_date;
653: x_okc_hdr_tbl (p_index).date_signed := okc_api.g_miss_date;
654: x_okc_hdr_tbl (p_index).date_terminated := okc_api.g_miss_date;
655: x_okc_hdr_tbl (p_index).date_renewed := okc_api.g_miss_date;
656: x_okc_hdr_tbl (p_index).trn_code := okc_api.g_miss_char;
657: x_okc_hdr_tbl (p_index).start_date := okc_api.g_miss_date;
658: x_okc_hdr_tbl (p_index).end_date := okc_api.g_miss_date;
659: x_okc_hdr_tbl (p_index).org_id := okc_api.g_miss_num;

Line 656: x_okc_hdr_tbl (p_index).trn_code := okc_api.g_miss_char;

652: x_okc_hdr_tbl (p_index).datetime_proposed := okc_api.g_miss_date;
653: x_okc_hdr_tbl (p_index).date_signed := okc_api.g_miss_date;
654: x_okc_hdr_tbl (p_index).date_terminated := okc_api.g_miss_date;
655: x_okc_hdr_tbl (p_index).date_renewed := okc_api.g_miss_date;
656: x_okc_hdr_tbl (p_index).trn_code := okc_api.g_miss_char;
657: x_okc_hdr_tbl (p_index).start_date := okc_api.g_miss_date;
658: x_okc_hdr_tbl (p_index).end_date := okc_api.g_miss_date;
659: x_okc_hdr_tbl (p_index).org_id := okc_api.g_miss_num;
660: x_okc_hdr_tbl (p_index).buy_or_sell := okc_api.g_miss_char;

Line 657: x_okc_hdr_tbl (p_index).start_date := okc_api.g_miss_date;

653: x_okc_hdr_tbl (p_index).date_signed := okc_api.g_miss_date;
654: x_okc_hdr_tbl (p_index).date_terminated := okc_api.g_miss_date;
655: x_okc_hdr_tbl (p_index).date_renewed := okc_api.g_miss_date;
656: x_okc_hdr_tbl (p_index).trn_code := okc_api.g_miss_char;
657: x_okc_hdr_tbl (p_index).start_date := okc_api.g_miss_date;
658: x_okc_hdr_tbl (p_index).end_date := okc_api.g_miss_date;
659: x_okc_hdr_tbl (p_index).org_id := okc_api.g_miss_num;
660: x_okc_hdr_tbl (p_index).buy_or_sell := okc_api.g_miss_char;
661: x_okc_hdr_tbl (p_index).issue_or_receive := okc_api.g_miss_char;

Line 658: x_okc_hdr_tbl (p_index).end_date := okc_api.g_miss_date;

654: x_okc_hdr_tbl (p_index).date_terminated := okc_api.g_miss_date;
655: x_okc_hdr_tbl (p_index).date_renewed := okc_api.g_miss_date;
656: x_okc_hdr_tbl (p_index).trn_code := okc_api.g_miss_char;
657: x_okc_hdr_tbl (p_index).start_date := okc_api.g_miss_date;
658: x_okc_hdr_tbl (p_index).end_date := okc_api.g_miss_date;
659: x_okc_hdr_tbl (p_index).org_id := okc_api.g_miss_num;
660: x_okc_hdr_tbl (p_index).buy_or_sell := okc_api.g_miss_char;
661: x_okc_hdr_tbl (p_index).issue_or_receive := okc_api.g_miss_char;
662: x_okc_hdr_tbl (p_index).estimated_amount := okc_api.g_miss_num;

Line 659: x_okc_hdr_tbl (p_index).org_id := okc_api.g_miss_num;

655: x_okc_hdr_tbl (p_index).date_renewed := okc_api.g_miss_date;
656: x_okc_hdr_tbl (p_index).trn_code := okc_api.g_miss_char;
657: x_okc_hdr_tbl (p_index).start_date := okc_api.g_miss_date;
658: x_okc_hdr_tbl (p_index).end_date := okc_api.g_miss_date;
659: x_okc_hdr_tbl (p_index).org_id := okc_api.g_miss_num;
660: x_okc_hdr_tbl (p_index).buy_or_sell := okc_api.g_miss_char;
661: x_okc_hdr_tbl (p_index).issue_or_receive := okc_api.g_miss_char;
662: x_okc_hdr_tbl (p_index).estimated_amount := okc_api.g_miss_num;
663: x_okc_hdr_tbl (p_index).chr_id_renewed_to := okc_api.g_miss_num;

Line 660: x_okc_hdr_tbl (p_index).buy_or_sell := okc_api.g_miss_char;

656: x_okc_hdr_tbl (p_index).trn_code := okc_api.g_miss_char;
657: x_okc_hdr_tbl (p_index).start_date := okc_api.g_miss_date;
658: x_okc_hdr_tbl (p_index).end_date := okc_api.g_miss_date;
659: x_okc_hdr_tbl (p_index).org_id := okc_api.g_miss_num;
660: x_okc_hdr_tbl (p_index).buy_or_sell := okc_api.g_miss_char;
661: x_okc_hdr_tbl (p_index).issue_or_receive := okc_api.g_miss_char;
662: x_okc_hdr_tbl (p_index).estimated_amount := okc_api.g_miss_num;
663: x_okc_hdr_tbl (p_index).chr_id_renewed_to := okc_api.g_miss_num;
664: x_okc_hdr_tbl (p_index).estimated_amount_renewed

Line 661: x_okc_hdr_tbl (p_index).issue_or_receive := okc_api.g_miss_char;

657: x_okc_hdr_tbl (p_index).start_date := okc_api.g_miss_date;
658: x_okc_hdr_tbl (p_index).end_date := okc_api.g_miss_date;
659: x_okc_hdr_tbl (p_index).org_id := okc_api.g_miss_num;
660: x_okc_hdr_tbl (p_index).buy_or_sell := okc_api.g_miss_char;
661: x_okc_hdr_tbl (p_index).issue_or_receive := okc_api.g_miss_char;
662: x_okc_hdr_tbl (p_index).estimated_amount := okc_api.g_miss_num;
663: x_okc_hdr_tbl (p_index).chr_id_renewed_to := okc_api.g_miss_num;
664: x_okc_hdr_tbl (p_index).estimated_amount_renewed
665: := okc_api.g_miss_num;

Line 662: x_okc_hdr_tbl (p_index).estimated_amount := okc_api.g_miss_num;

658: x_okc_hdr_tbl (p_index).end_date := okc_api.g_miss_date;
659: x_okc_hdr_tbl (p_index).org_id := okc_api.g_miss_num;
660: x_okc_hdr_tbl (p_index).buy_or_sell := okc_api.g_miss_char;
661: x_okc_hdr_tbl (p_index).issue_or_receive := okc_api.g_miss_char;
662: x_okc_hdr_tbl (p_index).estimated_amount := okc_api.g_miss_num;
663: x_okc_hdr_tbl (p_index).chr_id_renewed_to := okc_api.g_miss_num;
664: x_okc_hdr_tbl (p_index).estimated_amount_renewed
665: := okc_api.g_miss_num;
666: x_okc_hdr_tbl (p_index).currency_code_renewed := okc_api.g_miss_char;

Line 663: x_okc_hdr_tbl (p_index).chr_id_renewed_to := okc_api.g_miss_num;

659: x_okc_hdr_tbl (p_index).org_id := okc_api.g_miss_num;
660: x_okc_hdr_tbl (p_index).buy_or_sell := okc_api.g_miss_char;
661: x_okc_hdr_tbl (p_index).issue_or_receive := okc_api.g_miss_char;
662: x_okc_hdr_tbl (p_index).estimated_amount := okc_api.g_miss_num;
663: x_okc_hdr_tbl (p_index).chr_id_renewed_to := okc_api.g_miss_num;
664: x_okc_hdr_tbl (p_index).estimated_amount_renewed
665: := okc_api.g_miss_num;
666: x_okc_hdr_tbl (p_index).currency_code_renewed := okc_api.g_miss_char;
667: x_okc_hdr_tbl (p_index).upg_orig_system_ref := okc_api.g_miss_char;

Line 665: := okc_api.g_miss_num;

661: x_okc_hdr_tbl (p_index).issue_or_receive := okc_api.g_miss_char;
662: x_okc_hdr_tbl (p_index).estimated_amount := okc_api.g_miss_num;
663: x_okc_hdr_tbl (p_index).chr_id_renewed_to := okc_api.g_miss_num;
664: x_okc_hdr_tbl (p_index).estimated_amount_renewed
665: := okc_api.g_miss_num;
666: x_okc_hdr_tbl (p_index).currency_code_renewed := okc_api.g_miss_char;
667: x_okc_hdr_tbl (p_index).upg_orig_system_ref := okc_api.g_miss_char;
668: x_okc_hdr_tbl (p_index).upg_orig_system_ref_id
669: := okc_api.g_miss_num;

Line 666: x_okc_hdr_tbl (p_index).currency_code_renewed := okc_api.g_miss_char;

662: x_okc_hdr_tbl (p_index).estimated_amount := okc_api.g_miss_num;
663: x_okc_hdr_tbl (p_index).chr_id_renewed_to := okc_api.g_miss_num;
664: x_okc_hdr_tbl (p_index).estimated_amount_renewed
665: := okc_api.g_miss_num;
666: x_okc_hdr_tbl (p_index).currency_code_renewed := okc_api.g_miss_char;
667: x_okc_hdr_tbl (p_index).upg_orig_system_ref := okc_api.g_miss_char;
668: x_okc_hdr_tbl (p_index).upg_orig_system_ref_id
669: := okc_api.g_miss_num;
670: x_okc_hdr_tbl (p_index).application_id := okc_api.g_miss_num;

Line 667: x_okc_hdr_tbl (p_index).upg_orig_system_ref := okc_api.g_miss_char;

663: x_okc_hdr_tbl (p_index).chr_id_renewed_to := okc_api.g_miss_num;
664: x_okc_hdr_tbl (p_index).estimated_amount_renewed
665: := okc_api.g_miss_num;
666: x_okc_hdr_tbl (p_index).currency_code_renewed := okc_api.g_miss_char;
667: x_okc_hdr_tbl (p_index).upg_orig_system_ref := okc_api.g_miss_char;
668: x_okc_hdr_tbl (p_index).upg_orig_system_ref_id
669: := okc_api.g_miss_num;
670: x_okc_hdr_tbl (p_index).application_id := okc_api.g_miss_num;
671: x_okc_hdr_tbl (p_index).orig_system_source_code

Line 669: := okc_api.g_miss_num;

665: := okc_api.g_miss_num;
666: x_okc_hdr_tbl (p_index).currency_code_renewed := okc_api.g_miss_char;
667: x_okc_hdr_tbl (p_index).upg_orig_system_ref := okc_api.g_miss_char;
668: x_okc_hdr_tbl (p_index).upg_orig_system_ref_id
669: := okc_api.g_miss_num;
670: x_okc_hdr_tbl (p_index).application_id := okc_api.g_miss_num;
671: x_okc_hdr_tbl (p_index).orig_system_source_code
672: := okc_api.g_miss_char;
673: x_okc_hdr_tbl (p_index).orig_system_id1 := okc_api.g_miss_num;

Line 670: x_okc_hdr_tbl (p_index).application_id := okc_api.g_miss_num;

666: x_okc_hdr_tbl (p_index).currency_code_renewed := okc_api.g_miss_char;
667: x_okc_hdr_tbl (p_index).upg_orig_system_ref := okc_api.g_miss_char;
668: x_okc_hdr_tbl (p_index).upg_orig_system_ref_id
669: := okc_api.g_miss_num;
670: x_okc_hdr_tbl (p_index).application_id := okc_api.g_miss_num;
671: x_okc_hdr_tbl (p_index).orig_system_source_code
672: := okc_api.g_miss_char;
673: x_okc_hdr_tbl (p_index).orig_system_id1 := okc_api.g_miss_num;
674: x_okc_hdr_tbl (p_index).orig_system_reference1

Line 672: := okc_api.g_miss_char;

668: x_okc_hdr_tbl (p_index).upg_orig_system_ref_id
669: := okc_api.g_miss_num;
670: x_okc_hdr_tbl (p_index).application_id := okc_api.g_miss_num;
671: x_okc_hdr_tbl (p_index).orig_system_source_code
672: := okc_api.g_miss_char;
673: x_okc_hdr_tbl (p_index).orig_system_id1 := okc_api.g_miss_num;
674: x_okc_hdr_tbl (p_index).orig_system_reference1
675: := okc_api.g_miss_char;
676: x_okc_hdr_tbl (p_index).program_id := okc_api.g_miss_num;

Line 673: x_okc_hdr_tbl (p_index).orig_system_id1 := okc_api.g_miss_num;

669: := okc_api.g_miss_num;
670: x_okc_hdr_tbl (p_index).application_id := okc_api.g_miss_num;
671: x_okc_hdr_tbl (p_index).orig_system_source_code
672: := okc_api.g_miss_char;
673: x_okc_hdr_tbl (p_index).orig_system_id1 := okc_api.g_miss_num;
674: x_okc_hdr_tbl (p_index).orig_system_reference1
675: := okc_api.g_miss_char;
676: x_okc_hdr_tbl (p_index).program_id := okc_api.g_miss_num;
677: x_okc_hdr_tbl (p_index).request_id := okc_api.g_miss_num;

Line 675: := okc_api.g_miss_char;

671: x_okc_hdr_tbl (p_index).orig_system_source_code
672: := okc_api.g_miss_char;
673: x_okc_hdr_tbl (p_index).orig_system_id1 := okc_api.g_miss_num;
674: x_okc_hdr_tbl (p_index).orig_system_reference1
675: := okc_api.g_miss_char;
676: x_okc_hdr_tbl (p_index).program_id := okc_api.g_miss_num;
677: x_okc_hdr_tbl (p_index).request_id := okc_api.g_miss_num;
678: x_okc_hdr_tbl (p_index).price_list_id := okc_api.g_miss_num;
679: x_okc_hdr_tbl (p_index).pricing_date := okc_api.g_miss_date;

Line 676: x_okc_hdr_tbl (p_index).program_id := okc_api.g_miss_num;

672: := okc_api.g_miss_char;
673: x_okc_hdr_tbl (p_index).orig_system_id1 := okc_api.g_miss_num;
674: x_okc_hdr_tbl (p_index).orig_system_reference1
675: := okc_api.g_miss_char;
676: x_okc_hdr_tbl (p_index).program_id := okc_api.g_miss_num;
677: x_okc_hdr_tbl (p_index).request_id := okc_api.g_miss_num;
678: x_okc_hdr_tbl (p_index).price_list_id := okc_api.g_miss_num;
679: x_okc_hdr_tbl (p_index).pricing_date := okc_api.g_miss_date;
680: x_okc_hdr_tbl (p_index).sign_by_date := okc_api.g_miss_date;

Line 677: x_okc_hdr_tbl (p_index).request_id := okc_api.g_miss_num;

673: x_okc_hdr_tbl (p_index).orig_system_id1 := okc_api.g_miss_num;
674: x_okc_hdr_tbl (p_index).orig_system_reference1
675: := okc_api.g_miss_char;
676: x_okc_hdr_tbl (p_index).program_id := okc_api.g_miss_num;
677: x_okc_hdr_tbl (p_index).request_id := okc_api.g_miss_num;
678: x_okc_hdr_tbl (p_index).price_list_id := okc_api.g_miss_num;
679: x_okc_hdr_tbl (p_index).pricing_date := okc_api.g_miss_date;
680: x_okc_hdr_tbl (p_index).sign_by_date := okc_api.g_miss_date;
681: x_okc_hdr_tbl (p_index).program_update_date := okc_api.g_miss_date;

Line 678: x_okc_hdr_tbl (p_index).price_list_id := okc_api.g_miss_num;

674: x_okc_hdr_tbl (p_index).orig_system_reference1
675: := okc_api.g_miss_char;
676: x_okc_hdr_tbl (p_index).program_id := okc_api.g_miss_num;
677: x_okc_hdr_tbl (p_index).request_id := okc_api.g_miss_num;
678: x_okc_hdr_tbl (p_index).price_list_id := okc_api.g_miss_num;
679: x_okc_hdr_tbl (p_index).pricing_date := okc_api.g_miss_date;
680: x_okc_hdr_tbl (p_index).sign_by_date := okc_api.g_miss_date;
681: x_okc_hdr_tbl (p_index).program_update_date := okc_api.g_miss_date;
682: x_okc_hdr_tbl (p_index).total_line_list_price := okc_api.g_miss_num;

Line 679: x_okc_hdr_tbl (p_index).pricing_date := okc_api.g_miss_date;

675: := okc_api.g_miss_char;
676: x_okc_hdr_tbl (p_index).program_id := okc_api.g_miss_num;
677: x_okc_hdr_tbl (p_index).request_id := okc_api.g_miss_num;
678: x_okc_hdr_tbl (p_index).price_list_id := okc_api.g_miss_num;
679: x_okc_hdr_tbl (p_index).pricing_date := okc_api.g_miss_date;
680: x_okc_hdr_tbl (p_index).sign_by_date := okc_api.g_miss_date;
681: x_okc_hdr_tbl (p_index).program_update_date := okc_api.g_miss_date;
682: x_okc_hdr_tbl (p_index).total_line_list_price := okc_api.g_miss_num;
683: x_okc_hdr_tbl (p_index).program_application_id

Line 680: x_okc_hdr_tbl (p_index).sign_by_date := okc_api.g_miss_date;

676: x_okc_hdr_tbl (p_index).program_id := okc_api.g_miss_num;
677: x_okc_hdr_tbl (p_index).request_id := okc_api.g_miss_num;
678: x_okc_hdr_tbl (p_index).price_list_id := okc_api.g_miss_num;
679: x_okc_hdr_tbl (p_index).pricing_date := okc_api.g_miss_date;
680: x_okc_hdr_tbl (p_index).sign_by_date := okc_api.g_miss_date;
681: x_okc_hdr_tbl (p_index).program_update_date := okc_api.g_miss_date;
682: x_okc_hdr_tbl (p_index).total_line_list_price := okc_api.g_miss_num;
683: x_okc_hdr_tbl (p_index).program_application_id
684: := okc_api.g_miss_num;

Line 681: x_okc_hdr_tbl (p_index).program_update_date := okc_api.g_miss_date;

677: x_okc_hdr_tbl (p_index).request_id := okc_api.g_miss_num;
678: x_okc_hdr_tbl (p_index).price_list_id := okc_api.g_miss_num;
679: x_okc_hdr_tbl (p_index).pricing_date := okc_api.g_miss_date;
680: x_okc_hdr_tbl (p_index).sign_by_date := okc_api.g_miss_date;
681: x_okc_hdr_tbl (p_index).program_update_date := okc_api.g_miss_date;
682: x_okc_hdr_tbl (p_index).total_line_list_price := okc_api.g_miss_num;
683: x_okc_hdr_tbl (p_index).program_application_id
684: := okc_api.g_miss_num;
685: x_okc_hdr_tbl (p_index).user_estimated_amount := okc_api.g_miss_num;

Line 682: x_okc_hdr_tbl (p_index).total_line_list_price := okc_api.g_miss_num;

678: x_okc_hdr_tbl (p_index).price_list_id := okc_api.g_miss_num;
679: x_okc_hdr_tbl (p_index).pricing_date := okc_api.g_miss_date;
680: x_okc_hdr_tbl (p_index).sign_by_date := okc_api.g_miss_date;
681: x_okc_hdr_tbl (p_index).program_update_date := okc_api.g_miss_date;
682: x_okc_hdr_tbl (p_index).total_line_list_price := okc_api.g_miss_num;
683: x_okc_hdr_tbl (p_index).program_application_id
684: := okc_api.g_miss_num;
685: x_okc_hdr_tbl (p_index).user_estimated_amount := okc_api.g_miss_num;
686: x_okc_hdr_tbl (p_index).governing_contract_yn := okc_api.g_miss_char;

Line 684: := okc_api.g_miss_num;

680: x_okc_hdr_tbl (p_index).sign_by_date := okc_api.g_miss_date;
681: x_okc_hdr_tbl (p_index).program_update_date := okc_api.g_miss_date;
682: x_okc_hdr_tbl (p_index).total_line_list_price := okc_api.g_miss_num;
683: x_okc_hdr_tbl (p_index).program_application_id
684: := okc_api.g_miss_num;
685: x_okc_hdr_tbl (p_index).user_estimated_amount := okc_api.g_miss_num;
686: x_okc_hdr_tbl (p_index).governing_contract_yn := okc_api.g_miss_char;
687: x_okc_hdr_tbl (p_index).attribute_category := okc_api.g_miss_char;
688: x_okc_hdr_tbl (p_index).attribute1 := okc_api.g_miss_char;

Line 685: x_okc_hdr_tbl (p_index).user_estimated_amount := okc_api.g_miss_num;

681: x_okc_hdr_tbl (p_index).program_update_date := okc_api.g_miss_date;
682: x_okc_hdr_tbl (p_index).total_line_list_price := okc_api.g_miss_num;
683: x_okc_hdr_tbl (p_index).program_application_id
684: := okc_api.g_miss_num;
685: x_okc_hdr_tbl (p_index).user_estimated_amount := okc_api.g_miss_num;
686: x_okc_hdr_tbl (p_index).governing_contract_yn := okc_api.g_miss_char;
687: x_okc_hdr_tbl (p_index).attribute_category := okc_api.g_miss_char;
688: x_okc_hdr_tbl (p_index).attribute1 := okc_api.g_miss_char;
689: x_okc_hdr_tbl (p_index).attribute2 := okc_api.g_miss_char;

Line 686: x_okc_hdr_tbl (p_index).governing_contract_yn := okc_api.g_miss_char;

682: x_okc_hdr_tbl (p_index).total_line_list_price := okc_api.g_miss_num;
683: x_okc_hdr_tbl (p_index).program_application_id
684: := okc_api.g_miss_num;
685: x_okc_hdr_tbl (p_index).user_estimated_amount := okc_api.g_miss_num;
686: x_okc_hdr_tbl (p_index).governing_contract_yn := okc_api.g_miss_char;
687: x_okc_hdr_tbl (p_index).attribute_category := okc_api.g_miss_char;
688: x_okc_hdr_tbl (p_index).attribute1 := okc_api.g_miss_char;
689: x_okc_hdr_tbl (p_index).attribute2 := okc_api.g_miss_char;
690: x_okc_hdr_tbl (p_index).attribute3 := okc_api.g_miss_char;

Line 687: x_okc_hdr_tbl (p_index).attribute_category := okc_api.g_miss_char;

683: x_okc_hdr_tbl (p_index).program_application_id
684: := okc_api.g_miss_num;
685: x_okc_hdr_tbl (p_index).user_estimated_amount := okc_api.g_miss_num;
686: x_okc_hdr_tbl (p_index).governing_contract_yn := okc_api.g_miss_char;
687: x_okc_hdr_tbl (p_index).attribute_category := okc_api.g_miss_char;
688: x_okc_hdr_tbl (p_index).attribute1 := okc_api.g_miss_char;
689: x_okc_hdr_tbl (p_index).attribute2 := okc_api.g_miss_char;
690: x_okc_hdr_tbl (p_index).attribute3 := okc_api.g_miss_char;
691: x_okc_hdr_tbl (p_index).attribute4 := okc_api.g_miss_char;

Line 688: x_okc_hdr_tbl (p_index).attribute1 := okc_api.g_miss_char;

684: := okc_api.g_miss_num;
685: x_okc_hdr_tbl (p_index).user_estimated_amount := okc_api.g_miss_num;
686: x_okc_hdr_tbl (p_index).governing_contract_yn := okc_api.g_miss_char;
687: x_okc_hdr_tbl (p_index).attribute_category := okc_api.g_miss_char;
688: x_okc_hdr_tbl (p_index).attribute1 := okc_api.g_miss_char;
689: x_okc_hdr_tbl (p_index).attribute2 := okc_api.g_miss_char;
690: x_okc_hdr_tbl (p_index).attribute3 := okc_api.g_miss_char;
691: x_okc_hdr_tbl (p_index).attribute4 := okc_api.g_miss_char;
692: x_okc_hdr_tbl (p_index).attribute5 := okc_api.g_miss_char;

Line 689: x_okc_hdr_tbl (p_index).attribute2 := okc_api.g_miss_char;

685: x_okc_hdr_tbl (p_index).user_estimated_amount := okc_api.g_miss_num;
686: x_okc_hdr_tbl (p_index).governing_contract_yn := okc_api.g_miss_char;
687: x_okc_hdr_tbl (p_index).attribute_category := okc_api.g_miss_char;
688: x_okc_hdr_tbl (p_index).attribute1 := okc_api.g_miss_char;
689: x_okc_hdr_tbl (p_index).attribute2 := okc_api.g_miss_char;
690: x_okc_hdr_tbl (p_index).attribute3 := okc_api.g_miss_char;
691: x_okc_hdr_tbl (p_index).attribute4 := okc_api.g_miss_char;
692: x_okc_hdr_tbl (p_index).attribute5 := okc_api.g_miss_char;
693: x_okc_hdr_tbl (p_index).attribute6 := okc_api.g_miss_char;

Line 690: x_okc_hdr_tbl (p_index).attribute3 := okc_api.g_miss_char;

686: x_okc_hdr_tbl (p_index).governing_contract_yn := okc_api.g_miss_char;
687: x_okc_hdr_tbl (p_index).attribute_category := okc_api.g_miss_char;
688: x_okc_hdr_tbl (p_index).attribute1 := okc_api.g_miss_char;
689: x_okc_hdr_tbl (p_index).attribute2 := okc_api.g_miss_char;
690: x_okc_hdr_tbl (p_index).attribute3 := okc_api.g_miss_char;
691: x_okc_hdr_tbl (p_index).attribute4 := okc_api.g_miss_char;
692: x_okc_hdr_tbl (p_index).attribute5 := okc_api.g_miss_char;
693: x_okc_hdr_tbl (p_index).attribute6 := okc_api.g_miss_char;
694: x_okc_hdr_tbl (p_index).attribute7 := okc_api.g_miss_char;

Line 691: x_okc_hdr_tbl (p_index).attribute4 := okc_api.g_miss_char;

687: x_okc_hdr_tbl (p_index).attribute_category := okc_api.g_miss_char;
688: x_okc_hdr_tbl (p_index).attribute1 := okc_api.g_miss_char;
689: x_okc_hdr_tbl (p_index).attribute2 := okc_api.g_miss_char;
690: x_okc_hdr_tbl (p_index).attribute3 := okc_api.g_miss_char;
691: x_okc_hdr_tbl (p_index).attribute4 := okc_api.g_miss_char;
692: x_okc_hdr_tbl (p_index).attribute5 := okc_api.g_miss_char;
693: x_okc_hdr_tbl (p_index).attribute6 := okc_api.g_miss_char;
694: x_okc_hdr_tbl (p_index).attribute7 := okc_api.g_miss_char;
695: x_okc_hdr_tbl (p_index).attribute8 := okc_api.g_miss_char;

Line 692: x_okc_hdr_tbl (p_index).attribute5 := okc_api.g_miss_char;

688: x_okc_hdr_tbl (p_index).attribute1 := okc_api.g_miss_char;
689: x_okc_hdr_tbl (p_index).attribute2 := okc_api.g_miss_char;
690: x_okc_hdr_tbl (p_index).attribute3 := okc_api.g_miss_char;
691: x_okc_hdr_tbl (p_index).attribute4 := okc_api.g_miss_char;
692: x_okc_hdr_tbl (p_index).attribute5 := okc_api.g_miss_char;
693: x_okc_hdr_tbl (p_index).attribute6 := okc_api.g_miss_char;
694: x_okc_hdr_tbl (p_index).attribute7 := okc_api.g_miss_char;
695: x_okc_hdr_tbl (p_index).attribute8 := okc_api.g_miss_char;
696: x_okc_hdr_tbl (p_index).attribute9 := okc_api.g_miss_char;

Line 693: x_okc_hdr_tbl (p_index).attribute6 := okc_api.g_miss_char;

689: x_okc_hdr_tbl (p_index).attribute2 := okc_api.g_miss_char;
690: x_okc_hdr_tbl (p_index).attribute3 := okc_api.g_miss_char;
691: x_okc_hdr_tbl (p_index).attribute4 := okc_api.g_miss_char;
692: x_okc_hdr_tbl (p_index).attribute5 := okc_api.g_miss_char;
693: x_okc_hdr_tbl (p_index).attribute6 := okc_api.g_miss_char;
694: x_okc_hdr_tbl (p_index).attribute7 := okc_api.g_miss_char;
695: x_okc_hdr_tbl (p_index).attribute8 := okc_api.g_miss_char;
696: x_okc_hdr_tbl (p_index).attribute9 := okc_api.g_miss_char;
697: x_okc_hdr_tbl (p_index).attribute10 := okc_api.g_miss_char;

Line 694: x_okc_hdr_tbl (p_index).attribute7 := okc_api.g_miss_char;

690: x_okc_hdr_tbl (p_index).attribute3 := okc_api.g_miss_char;
691: x_okc_hdr_tbl (p_index).attribute4 := okc_api.g_miss_char;
692: x_okc_hdr_tbl (p_index).attribute5 := okc_api.g_miss_char;
693: x_okc_hdr_tbl (p_index).attribute6 := okc_api.g_miss_char;
694: x_okc_hdr_tbl (p_index).attribute7 := okc_api.g_miss_char;
695: x_okc_hdr_tbl (p_index).attribute8 := okc_api.g_miss_char;
696: x_okc_hdr_tbl (p_index).attribute9 := okc_api.g_miss_char;
697: x_okc_hdr_tbl (p_index).attribute10 := okc_api.g_miss_char;
698: x_okc_hdr_tbl (p_index).attribute11 := okc_api.g_miss_char;

Line 695: x_okc_hdr_tbl (p_index).attribute8 := okc_api.g_miss_char;

691: x_okc_hdr_tbl (p_index).attribute4 := okc_api.g_miss_char;
692: x_okc_hdr_tbl (p_index).attribute5 := okc_api.g_miss_char;
693: x_okc_hdr_tbl (p_index).attribute6 := okc_api.g_miss_char;
694: x_okc_hdr_tbl (p_index).attribute7 := okc_api.g_miss_char;
695: x_okc_hdr_tbl (p_index).attribute8 := okc_api.g_miss_char;
696: x_okc_hdr_tbl (p_index).attribute9 := okc_api.g_miss_char;
697: x_okc_hdr_tbl (p_index).attribute10 := okc_api.g_miss_char;
698: x_okc_hdr_tbl (p_index).attribute11 := okc_api.g_miss_char;
699: x_okc_hdr_tbl (p_index).attribute12 := okc_api.g_miss_char;

Line 696: x_okc_hdr_tbl (p_index).attribute9 := okc_api.g_miss_char;

692: x_okc_hdr_tbl (p_index).attribute5 := okc_api.g_miss_char;
693: x_okc_hdr_tbl (p_index).attribute6 := okc_api.g_miss_char;
694: x_okc_hdr_tbl (p_index).attribute7 := okc_api.g_miss_char;
695: x_okc_hdr_tbl (p_index).attribute8 := okc_api.g_miss_char;
696: x_okc_hdr_tbl (p_index).attribute9 := okc_api.g_miss_char;
697: x_okc_hdr_tbl (p_index).attribute10 := okc_api.g_miss_char;
698: x_okc_hdr_tbl (p_index).attribute11 := okc_api.g_miss_char;
699: x_okc_hdr_tbl (p_index).attribute12 := okc_api.g_miss_char;
700: x_okc_hdr_tbl (p_index).attribute13 := okc_api.g_miss_char;

Line 697: x_okc_hdr_tbl (p_index).attribute10 := okc_api.g_miss_char;

693: x_okc_hdr_tbl (p_index).attribute6 := okc_api.g_miss_char;
694: x_okc_hdr_tbl (p_index).attribute7 := okc_api.g_miss_char;
695: x_okc_hdr_tbl (p_index).attribute8 := okc_api.g_miss_char;
696: x_okc_hdr_tbl (p_index).attribute9 := okc_api.g_miss_char;
697: x_okc_hdr_tbl (p_index).attribute10 := okc_api.g_miss_char;
698: x_okc_hdr_tbl (p_index).attribute11 := okc_api.g_miss_char;
699: x_okc_hdr_tbl (p_index).attribute12 := okc_api.g_miss_char;
700: x_okc_hdr_tbl (p_index).attribute13 := okc_api.g_miss_char;
701: x_okc_hdr_tbl (p_index).attribute14 := okc_api.g_miss_char;

Line 698: x_okc_hdr_tbl (p_index).attribute11 := okc_api.g_miss_char;

694: x_okc_hdr_tbl (p_index).attribute7 := okc_api.g_miss_char;
695: x_okc_hdr_tbl (p_index).attribute8 := okc_api.g_miss_char;
696: x_okc_hdr_tbl (p_index).attribute9 := okc_api.g_miss_char;
697: x_okc_hdr_tbl (p_index).attribute10 := okc_api.g_miss_char;
698: x_okc_hdr_tbl (p_index).attribute11 := okc_api.g_miss_char;
699: x_okc_hdr_tbl (p_index).attribute12 := okc_api.g_miss_char;
700: x_okc_hdr_tbl (p_index).attribute13 := okc_api.g_miss_char;
701: x_okc_hdr_tbl (p_index).attribute14 := okc_api.g_miss_char;
702: x_okc_hdr_tbl (p_index).attribute15 := okc_api.g_miss_char;

Line 699: x_okc_hdr_tbl (p_index).attribute12 := okc_api.g_miss_char;

695: x_okc_hdr_tbl (p_index).attribute8 := okc_api.g_miss_char;
696: x_okc_hdr_tbl (p_index).attribute9 := okc_api.g_miss_char;
697: x_okc_hdr_tbl (p_index).attribute10 := okc_api.g_miss_char;
698: x_okc_hdr_tbl (p_index).attribute11 := okc_api.g_miss_char;
699: x_okc_hdr_tbl (p_index).attribute12 := okc_api.g_miss_char;
700: x_okc_hdr_tbl (p_index).attribute13 := okc_api.g_miss_char;
701: x_okc_hdr_tbl (p_index).attribute14 := okc_api.g_miss_char;
702: x_okc_hdr_tbl (p_index).attribute15 := okc_api.g_miss_char;
703: x_okc_hdr_tbl (p_index).created_by := okc_api.g_miss_num;

Line 700: x_okc_hdr_tbl (p_index).attribute13 := okc_api.g_miss_char;

696: x_okc_hdr_tbl (p_index).attribute9 := okc_api.g_miss_char;
697: x_okc_hdr_tbl (p_index).attribute10 := okc_api.g_miss_char;
698: x_okc_hdr_tbl (p_index).attribute11 := okc_api.g_miss_char;
699: x_okc_hdr_tbl (p_index).attribute12 := okc_api.g_miss_char;
700: x_okc_hdr_tbl (p_index).attribute13 := okc_api.g_miss_char;
701: x_okc_hdr_tbl (p_index).attribute14 := okc_api.g_miss_char;
702: x_okc_hdr_tbl (p_index).attribute15 := okc_api.g_miss_char;
703: x_okc_hdr_tbl (p_index).created_by := okc_api.g_miss_num;
704: x_okc_hdr_tbl (p_index).creation_date := okc_api.g_miss_date;

Line 701: x_okc_hdr_tbl (p_index).attribute14 := okc_api.g_miss_char;

697: x_okc_hdr_tbl (p_index).attribute10 := okc_api.g_miss_char;
698: x_okc_hdr_tbl (p_index).attribute11 := okc_api.g_miss_char;
699: x_okc_hdr_tbl (p_index).attribute12 := okc_api.g_miss_char;
700: x_okc_hdr_tbl (p_index).attribute13 := okc_api.g_miss_char;
701: x_okc_hdr_tbl (p_index).attribute14 := okc_api.g_miss_char;
702: x_okc_hdr_tbl (p_index).attribute15 := okc_api.g_miss_char;
703: x_okc_hdr_tbl (p_index).created_by := okc_api.g_miss_num;
704: x_okc_hdr_tbl (p_index).creation_date := okc_api.g_miss_date;
705: x_okc_hdr_tbl (p_index).last_updated_by := okc_api.g_miss_num;

Line 702: x_okc_hdr_tbl (p_index).attribute15 := okc_api.g_miss_char;

698: x_okc_hdr_tbl (p_index).attribute11 := okc_api.g_miss_char;
699: x_okc_hdr_tbl (p_index).attribute12 := okc_api.g_miss_char;
700: x_okc_hdr_tbl (p_index).attribute13 := okc_api.g_miss_char;
701: x_okc_hdr_tbl (p_index).attribute14 := okc_api.g_miss_char;
702: x_okc_hdr_tbl (p_index).attribute15 := okc_api.g_miss_char;
703: x_okc_hdr_tbl (p_index).created_by := okc_api.g_miss_num;
704: x_okc_hdr_tbl (p_index).creation_date := okc_api.g_miss_date;
705: x_okc_hdr_tbl (p_index).last_updated_by := okc_api.g_miss_num;
706: x_okc_hdr_tbl (p_index).last_update_date := okc_api.g_miss_date;

Line 703: x_okc_hdr_tbl (p_index).created_by := okc_api.g_miss_num;

699: x_okc_hdr_tbl (p_index).attribute12 := okc_api.g_miss_char;
700: x_okc_hdr_tbl (p_index).attribute13 := okc_api.g_miss_char;
701: x_okc_hdr_tbl (p_index).attribute14 := okc_api.g_miss_char;
702: x_okc_hdr_tbl (p_index).attribute15 := okc_api.g_miss_char;
703: x_okc_hdr_tbl (p_index).created_by := okc_api.g_miss_num;
704: x_okc_hdr_tbl (p_index).creation_date := okc_api.g_miss_date;
705: x_okc_hdr_tbl (p_index).last_updated_by := okc_api.g_miss_num;
706: x_okc_hdr_tbl (p_index).last_update_date := okc_api.g_miss_date;
707: x_okc_hdr_tbl (p_index).last_update_login := okc_api.g_miss_num;

Line 704: x_okc_hdr_tbl (p_index).creation_date := okc_api.g_miss_date;

700: x_okc_hdr_tbl (p_index).attribute13 := okc_api.g_miss_char;
701: x_okc_hdr_tbl (p_index).attribute14 := okc_api.g_miss_char;
702: x_okc_hdr_tbl (p_index).attribute15 := okc_api.g_miss_char;
703: x_okc_hdr_tbl (p_index).created_by := okc_api.g_miss_num;
704: x_okc_hdr_tbl (p_index).creation_date := okc_api.g_miss_date;
705: x_okc_hdr_tbl (p_index).last_updated_by := okc_api.g_miss_num;
706: x_okc_hdr_tbl (p_index).last_update_date := okc_api.g_miss_date;
707: x_okc_hdr_tbl (p_index).last_update_login := okc_api.g_miss_num;
708: x_okc_hdr_tbl (p_index).old_sts_code := okc_api.g_miss_char;

Line 705: x_okc_hdr_tbl (p_index).last_updated_by := okc_api.g_miss_num;

701: x_okc_hdr_tbl (p_index).attribute14 := okc_api.g_miss_char;
702: x_okc_hdr_tbl (p_index).attribute15 := okc_api.g_miss_char;
703: x_okc_hdr_tbl (p_index).created_by := okc_api.g_miss_num;
704: x_okc_hdr_tbl (p_index).creation_date := okc_api.g_miss_date;
705: x_okc_hdr_tbl (p_index).last_updated_by := okc_api.g_miss_num;
706: x_okc_hdr_tbl (p_index).last_update_date := okc_api.g_miss_date;
707: x_okc_hdr_tbl (p_index).last_update_login := okc_api.g_miss_num;
708: x_okc_hdr_tbl (p_index).old_sts_code := okc_api.g_miss_char;
709: x_okc_hdr_tbl (p_index).new_sts_code := okc_api.g_miss_char;

Line 706: x_okc_hdr_tbl (p_index).last_update_date := okc_api.g_miss_date;

702: x_okc_hdr_tbl (p_index).attribute15 := okc_api.g_miss_char;
703: x_okc_hdr_tbl (p_index).created_by := okc_api.g_miss_num;
704: x_okc_hdr_tbl (p_index).creation_date := okc_api.g_miss_date;
705: x_okc_hdr_tbl (p_index).last_updated_by := okc_api.g_miss_num;
706: x_okc_hdr_tbl (p_index).last_update_date := okc_api.g_miss_date;
707: x_okc_hdr_tbl (p_index).last_update_login := okc_api.g_miss_num;
708: x_okc_hdr_tbl (p_index).old_sts_code := okc_api.g_miss_char;
709: x_okc_hdr_tbl (p_index).new_sts_code := okc_api.g_miss_char;
710: x_okc_hdr_tbl (p_index).old_ste_code := okc_api.g_miss_char;

Line 707: x_okc_hdr_tbl (p_index).last_update_login := okc_api.g_miss_num;

703: x_okc_hdr_tbl (p_index).created_by := okc_api.g_miss_num;
704: x_okc_hdr_tbl (p_index).creation_date := okc_api.g_miss_date;
705: x_okc_hdr_tbl (p_index).last_updated_by := okc_api.g_miss_num;
706: x_okc_hdr_tbl (p_index).last_update_date := okc_api.g_miss_date;
707: x_okc_hdr_tbl (p_index).last_update_login := okc_api.g_miss_num;
708: x_okc_hdr_tbl (p_index).old_sts_code := okc_api.g_miss_char;
709: x_okc_hdr_tbl (p_index).new_sts_code := okc_api.g_miss_char;
710: x_okc_hdr_tbl (p_index).old_ste_code := okc_api.g_miss_char;
711: x_okc_hdr_tbl (p_index).new_ste_code := okc_api.g_miss_char;

Line 708: x_okc_hdr_tbl (p_index).old_sts_code := okc_api.g_miss_char;

704: x_okc_hdr_tbl (p_index).creation_date := okc_api.g_miss_date;
705: x_okc_hdr_tbl (p_index).last_updated_by := okc_api.g_miss_num;
706: x_okc_hdr_tbl (p_index).last_update_date := okc_api.g_miss_date;
707: x_okc_hdr_tbl (p_index).last_update_login := okc_api.g_miss_num;
708: x_okc_hdr_tbl (p_index).old_sts_code := okc_api.g_miss_char;
709: x_okc_hdr_tbl (p_index).new_sts_code := okc_api.g_miss_char;
710: x_okc_hdr_tbl (p_index).old_ste_code := okc_api.g_miss_char;
711: x_okc_hdr_tbl (p_index).new_ste_code := okc_api.g_miss_char;
712: --new columns to replace rules

Line 709: x_okc_hdr_tbl (p_index).new_sts_code := okc_api.g_miss_char;

705: x_okc_hdr_tbl (p_index).last_updated_by := okc_api.g_miss_num;
706: x_okc_hdr_tbl (p_index).last_update_date := okc_api.g_miss_date;
707: x_okc_hdr_tbl (p_index).last_update_login := okc_api.g_miss_num;
708: x_okc_hdr_tbl (p_index).old_sts_code := okc_api.g_miss_char;
709: x_okc_hdr_tbl (p_index).new_sts_code := okc_api.g_miss_char;
710: x_okc_hdr_tbl (p_index).old_ste_code := okc_api.g_miss_char;
711: x_okc_hdr_tbl (p_index).new_ste_code := okc_api.g_miss_char;
712: --new columns to replace rules
713: x_okc_hdr_tbl (p_index).conversion_type := okc_api.g_miss_char;

Line 710: x_okc_hdr_tbl (p_index).old_ste_code := okc_api.g_miss_char;

706: x_okc_hdr_tbl (p_index).last_update_date := okc_api.g_miss_date;
707: x_okc_hdr_tbl (p_index).last_update_login := okc_api.g_miss_num;
708: x_okc_hdr_tbl (p_index).old_sts_code := okc_api.g_miss_char;
709: x_okc_hdr_tbl (p_index).new_sts_code := okc_api.g_miss_char;
710: x_okc_hdr_tbl (p_index).old_ste_code := okc_api.g_miss_char;
711: x_okc_hdr_tbl (p_index).new_ste_code := okc_api.g_miss_char;
712: --new columns to replace rules
713: x_okc_hdr_tbl (p_index).conversion_type := okc_api.g_miss_char;
714: x_okc_hdr_tbl (p_index).payment_instruction_type := okc_api.g_miss_char;

Line 711: x_okc_hdr_tbl (p_index).new_ste_code := okc_api.g_miss_char;

707: x_okc_hdr_tbl (p_index).last_update_login := okc_api.g_miss_num;
708: x_okc_hdr_tbl (p_index).old_sts_code := okc_api.g_miss_char;
709: x_okc_hdr_tbl (p_index).new_sts_code := okc_api.g_miss_char;
710: x_okc_hdr_tbl (p_index).old_ste_code := okc_api.g_miss_char;
711: x_okc_hdr_tbl (p_index).new_ste_code := okc_api.g_miss_char;
712: --new columns to replace rules
713: x_okc_hdr_tbl (p_index).conversion_type := okc_api.g_miss_char;
714: x_okc_hdr_tbl (p_index).payment_instruction_type := okc_api.g_miss_char;
715:

Line 713: x_okc_hdr_tbl (p_index).conversion_type := okc_api.g_miss_char;

709: x_okc_hdr_tbl (p_index).new_sts_code := okc_api.g_miss_char;
710: x_okc_hdr_tbl (p_index).old_ste_code := okc_api.g_miss_char;
711: x_okc_hdr_tbl (p_index).new_ste_code := okc_api.g_miss_char;
712: --new columns to replace rules
713: x_okc_hdr_tbl (p_index).conversion_type := okc_api.g_miss_char;
714: x_okc_hdr_tbl (p_index).payment_instruction_type := okc_api.g_miss_char;
715:
716: x_okc_hdr_tbl (p_index).conversion_rate := okc_api.g_miss_num;
717: x_okc_hdr_tbl (p_index).conversion_rate_date := okc_api.g_miss_date;

Line 714: x_okc_hdr_tbl (p_index).payment_instruction_type := okc_api.g_miss_char;

710: x_okc_hdr_tbl (p_index).old_ste_code := okc_api.g_miss_char;
711: x_okc_hdr_tbl (p_index).new_ste_code := okc_api.g_miss_char;
712: --new columns to replace rules
713: x_okc_hdr_tbl (p_index).conversion_type := okc_api.g_miss_char;
714: x_okc_hdr_tbl (p_index).payment_instruction_type := okc_api.g_miss_char;
715:
716: x_okc_hdr_tbl (p_index).conversion_rate := okc_api.g_miss_num;
717: x_okc_hdr_tbl (p_index).conversion_rate_date := okc_api.g_miss_date;
718: x_okc_hdr_tbl (p_index).conversion_euro_rate := okc_api.g_miss_num;

Line 716: x_okc_hdr_tbl (p_index).conversion_rate := okc_api.g_miss_num;

712: --new columns to replace rules
713: x_okc_hdr_tbl (p_index).conversion_type := okc_api.g_miss_char;
714: x_okc_hdr_tbl (p_index).payment_instruction_type := okc_api.g_miss_char;
715:
716: x_okc_hdr_tbl (p_index).conversion_rate := okc_api.g_miss_num;
717: x_okc_hdr_tbl (p_index).conversion_rate_date := okc_api.g_miss_date;
718: x_okc_hdr_tbl (p_index).conversion_euro_rate := okc_api.g_miss_num;
719: x_okc_hdr_tbl (p_index).cust_acct_id := okc_api.g_miss_num;
720: x_okc_hdr_tbl (p_index).bill_to_site_use_id := okc_api.g_miss_num;

Line 717: x_okc_hdr_tbl (p_index).conversion_rate_date := okc_api.g_miss_date;

713: x_okc_hdr_tbl (p_index).conversion_type := okc_api.g_miss_char;
714: x_okc_hdr_tbl (p_index).payment_instruction_type := okc_api.g_miss_char;
715:
716: x_okc_hdr_tbl (p_index).conversion_rate := okc_api.g_miss_num;
717: x_okc_hdr_tbl (p_index).conversion_rate_date := okc_api.g_miss_date;
718: x_okc_hdr_tbl (p_index).conversion_euro_rate := okc_api.g_miss_num;
719: x_okc_hdr_tbl (p_index).cust_acct_id := okc_api.g_miss_num;
720: x_okc_hdr_tbl (p_index).bill_to_site_use_id := okc_api.g_miss_num;
721: x_okc_hdr_tbl (p_index).inv_rule_id := okc_api.g_miss_num;

Line 718: x_okc_hdr_tbl (p_index).conversion_euro_rate := okc_api.g_miss_num;

714: x_okc_hdr_tbl (p_index).payment_instruction_type := okc_api.g_miss_char;
715:
716: x_okc_hdr_tbl (p_index).conversion_rate := okc_api.g_miss_num;
717: x_okc_hdr_tbl (p_index).conversion_rate_date := okc_api.g_miss_date;
718: x_okc_hdr_tbl (p_index).conversion_euro_rate := okc_api.g_miss_num;
719: x_okc_hdr_tbl (p_index).cust_acct_id := okc_api.g_miss_num;
720: x_okc_hdr_tbl (p_index).bill_to_site_use_id := okc_api.g_miss_num;
721: x_okc_hdr_tbl (p_index).inv_rule_id := okc_api.g_miss_num;
722: x_okc_hdr_tbl (p_index).renewal_type_code := okc_api.g_miss_char;

Line 719: x_okc_hdr_tbl (p_index).cust_acct_id := okc_api.g_miss_num;

715:
716: x_okc_hdr_tbl (p_index).conversion_rate := okc_api.g_miss_num;
717: x_okc_hdr_tbl (p_index).conversion_rate_date := okc_api.g_miss_date;
718: x_okc_hdr_tbl (p_index).conversion_euro_rate := okc_api.g_miss_num;
719: x_okc_hdr_tbl (p_index).cust_acct_id := okc_api.g_miss_num;
720: x_okc_hdr_tbl (p_index).bill_to_site_use_id := okc_api.g_miss_num;
721: x_okc_hdr_tbl (p_index).inv_rule_id := okc_api.g_miss_num;
722: x_okc_hdr_tbl (p_index).renewal_type_code := okc_api.g_miss_char;
723: x_okc_hdr_tbl (p_index).renewal_notify_to := okc_api.g_miss_num;

Line 720: x_okc_hdr_tbl (p_index).bill_to_site_use_id := okc_api.g_miss_num;

716: x_okc_hdr_tbl (p_index).conversion_rate := okc_api.g_miss_num;
717: x_okc_hdr_tbl (p_index).conversion_rate_date := okc_api.g_miss_date;
718: x_okc_hdr_tbl (p_index).conversion_euro_rate := okc_api.g_miss_num;
719: x_okc_hdr_tbl (p_index).cust_acct_id := okc_api.g_miss_num;
720: x_okc_hdr_tbl (p_index).bill_to_site_use_id := okc_api.g_miss_num;
721: x_okc_hdr_tbl (p_index).inv_rule_id := okc_api.g_miss_num;
722: x_okc_hdr_tbl (p_index).renewal_type_code := okc_api.g_miss_char;
723: x_okc_hdr_tbl (p_index).renewal_notify_to := okc_api.g_miss_num;
724: x_okc_hdr_tbl (p_index).renewal_end_date := okc_api.g_miss_date;

Line 721: x_okc_hdr_tbl (p_index).inv_rule_id := okc_api.g_miss_num;

717: x_okc_hdr_tbl (p_index).conversion_rate_date := okc_api.g_miss_date;
718: x_okc_hdr_tbl (p_index).conversion_euro_rate := okc_api.g_miss_num;
719: x_okc_hdr_tbl (p_index).cust_acct_id := okc_api.g_miss_num;
720: x_okc_hdr_tbl (p_index).bill_to_site_use_id := okc_api.g_miss_num;
721: x_okc_hdr_tbl (p_index).inv_rule_id := okc_api.g_miss_num;
722: x_okc_hdr_tbl (p_index).renewal_type_code := okc_api.g_miss_char;
723: x_okc_hdr_tbl (p_index).renewal_notify_to := okc_api.g_miss_num;
724: x_okc_hdr_tbl (p_index).renewal_end_date := okc_api.g_miss_date;
725: x_okc_hdr_tbl (p_index).ship_to_site_use_id := okc_api.g_miss_num;

Line 722: x_okc_hdr_tbl (p_index).renewal_type_code := okc_api.g_miss_char;

718: x_okc_hdr_tbl (p_index).conversion_euro_rate := okc_api.g_miss_num;
719: x_okc_hdr_tbl (p_index).cust_acct_id := okc_api.g_miss_num;
720: x_okc_hdr_tbl (p_index).bill_to_site_use_id := okc_api.g_miss_num;
721: x_okc_hdr_tbl (p_index).inv_rule_id := okc_api.g_miss_num;
722: x_okc_hdr_tbl (p_index).renewal_type_code := okc_api.g_miss_char;
723: x_okc_hdr_tbl (p_index).renewal_notify_to := okc_api.g_miss_num;
724: x_okc_hdr_tbl (p_index).renewal_end_date := okc_api.g_miss_date;
725: x_okc_hdr_tbl (p_index).ship_to_site_use_id := okc_api.g_miss_num;
726: x_okc_hdr_tbl (p_index).payment_term_id := okc_api.g_miss_num;

Line 723: x_okc_hdr_tbl (p_index).renewal_notify_to := okc_api.g_miss_num;

719: x_okc_hdr_tbl (p_index).cust_acct_id := okc_api.g_miss_num;
720: x_okc_hdr_tbl (p_index).bill_to_site_use_id := okc_api.g_miss_num;
721: x_okc_hdr_tbl (p_index).inv_rule_id := okc_api.g_miss_num;
722: x_okc_hdr_tbl (p_index).renewal_type_code := okc_api.g_miss_char;
723: x_okc_hdr_tbl (p_index).renewal_notify_to := okc_api.g_miss_num;
724: x_okc_hdr_tbl (p_index).renewal_end_date := okc_api.g_miss_date;
725: x_okc_hdr_tbl (p_index).ship_to_site_use_id := okc_api.g_miss_num;
726: x_okc_hdr_tbl (p_index).payment_term_id := okc_api.g_miss_num;
727: END initialize_okc_hdr_tbl;

Line 724: x_okc_hdr_tbl (p_index).renewal_end_date := okc_api.g_miss_date;

720: x_okc_hdr_tbl (p_index).bill_to_site_use_id := okc_api.g_miss_num;
721: x_okc_hdr_tbl (p_index).inv_rule_id := okc_api.g_miss_num;
722: x_okc_hdr_tbl (p_index).renewal_type_code := okc_api.g_miss_char;
723: x_okc_hdr_tbl (p_index).renewal_notify_to := okc_api.g_miss_num;
724: x_okc_hdr_tbl (p_index).renewal_end_date := okc_api.g_miss_date;
725: x_okc_hdr_tbl (p_index).ship_to_site_use_id := okc_api.g_miss_num;
726: x_okc_hdr_tbl (p_index).payment_term_id := okc_api.g_miss_num;
727: END initialize_okc_hdr_tbl;
728:

Line 725: x_okc_hdr_tbl (p_index).ship_to_site_use_id := okc_api.g_miss_num;

721: x_okc_hdr_tbl (p_index).inv_rule_id := okc_api.g_miss_num;
722: x_okc_hdr_tbl (p_index).renewal_type_code := okc_api.g_miss_char;
723: x_okc_hdr_tbl (p_index).renewal_notify_to := okc_api.g_miss_num;
724: x_okc_hdr_tbl (p_index).renewal_end_date := okc_api.g_miss_date;
725: x_okc_hdr_tbl (p_index).ship_to_site_use_id := okc_api.g_miss_num;
726: x_okc_hdr_tbl (p_index).payment_term_id := okc_api.g_miss_num;
727: END initialize_okc_hdr_tbl;
728:
729: --------* Procedure initialize_oks_hdr_tbl *--------

Line 726: x_okc_hdr_tbl (p_index).payment_term_id := okc_api.g_miss_num;

722: x_okc_hdr_tbl (p_index).renewal_type_code := okc_api.g_miss_char;
723: x_okc_hdr_tbl (p_index).renewal_notify_to := okc_api.g_miss_num;
724: x_okc_hdr_tbl (p_index).renewal_end_date := okc_api.g_miss_date;
725: x_okc_hdr_tbl (p_index).ship_to_site_use_id := okc_api.g_miss_num;
726: x_okc_hdr_tbl (p_index).payment_term_id := okc_api.g_miss_num;
727: END initialize_okc_hdr_tbl;
728:
729: --------* Procedure initialize_oks_hdr_tbl *--------
730: -- Procedure to initialize oks_hdr plsql table before

Line 748: x_oks_hdr_tbl (p_index).ID := okc_api.g_miss_num;

744: 'Begin'
745: );
746: END IF;
747:
748: x_oks_hdr_tbl (p_index).ID := okc_api.g_miss_num;
749: x_oks_hdr_tbl (p_index).chr_id := okc_api.g_miss_num;
750: x_oks_hdr_tbl (p_index).acct_rule_id := okc_api.g_miss_num;
751: x_oks_hdr_tbl (p_index).payment_type := okc_api.g_miss_char;
752: x_oks_hdr_tbl (p_index).cc_no := okc_api.g_miss_char;

Line 749: x_oks_hdr_tbl (p_index).chr_id := okc_api.g_miss_num;

745: );
746: END IF;
747:
748: x_oks_hdr_tbl (p_index).ID := okc_api.g_miss_num;
749: x_oks_hdr_tbl (p_index).chr_id := okc_api.g_miss_num;
750: x_oks_hdr_tbl (p_index).acct_rule_id := okc_api.g_miss_num;
751: x_oks_hdr_tbl (p_index).payment_type := okc_api.g_miss_char;
752: x_oks_hdr_tbl (p_index).cc_no := okc_api.g_miss_char;
753: x_oks_hdr_tbl (p_index).cc_expiry_date := okc_api.g_miss_date;

Line 750: x_oks_hdr_tbl (p_index).acct_rule_id := okc_api.g_miss_num;

746: END IF;
747:
748: x_oks_hdr_tbl (p_index).ID := okc_api.g_miss_num;
749: x_oks_hdr_tbl (p_index).chr_id := okc_api.g_miss_num;
750: x_oks_hdr_tbl (p_index).acct_rule_id := okc_api.g_miss_num;
751: x_oks_hdr_tbl (p_index).payment_type := okc_api.g_miss_char;
752: x_oks_hdr_tbl (p_index).cc_no := okc_api.g_miss_char;
753: x_oks_hdr_tbl (p_index).cc_expiry_date := okc_api.g_miss_date;
754: x_oks_hdr_tbl (p_index).cc_bank_acct_id := okc_api.g_miss_num;

Line 751: x_oks_hdr_tbl (p_index).payment_type := okc_api.g_miss_char;

747:
748: x_oks_hdr_tbl (p_index).ID := okc_api.g_miss_num;
749: x_oks_hdr_tbl (p_index).chr_id := okc_api.g_miss_num;
750: x_oks_hdr_tbl (p_index).acct_rule_id := okc_api.g_miss_num;
751: x_oks_hdr_tbl (p_index).payment_type := okc_api.g_miss_char;
752: x_oks_hdr_tbl (p_index).cc_no := okc_api.g_miss_char;
753: x_oks_hdr_tbl (p_index).cc_expiry_date := okc_api.g_miss_date;
754: x_oks_hdr_tbl (p_index).cc_bank_acct_id := okc_api.g_miss_num;
755: x_oks_hdr_tbl (p_index).cc_auth_code := okc_api.g_miss_char;

Line 752: x_oks_hdr_tbl (p_index).cc_no := okc_api.g_miss_char;

748: x_oks_hdr_tbl (p_index).ID := okc_api.g_miss_num;
749: x_oks_hdr_tbl (p_index).chr_id := okc_api.g_miss_num;
750: x_oks_hdr_tbl (p_index).acct_rule_id := okc_api.g_miss_num;
751: x_oks_hdr_tbl (p_index).payment_type := okc_api.g_miss_char;
752: x_oks_hdr_tbl (p_index).cc_no := okc_api.g_miss_char;
753: x_oks_hdr_tbl (p_index).cc_expiry_date := okc_api.g_miss_date;
754: x_oks_hdr_tbl (p_index).cc_bank_acct_id := okc_api.g_miss_num;
755: x_oks_hdr_tbl (p_index).cc_auth_code := okc_api.g_miss_char;
756: x_oks_hdr_tbl (p_index).commitment_id := okc_api.g_miss_num;

Line 753: x_oks_hdr_tbl (p_index).cc_expiry_date := okc_api.g_miss_date;

749: x_oks_hdr_tbl (p_index).chr_id := okc_api.g_miss_num;
750: x_oks_hdr_tbl (p_index).acct_rule_id := okc_api.g_miss_num;
751: x_oks_hdr_tbl (p_index).payment_type := okc_api.g_miss_char;
752: x_oks_hdr_tbl (p_index).cc_no := okc_api.g_miss_char;
753: x_oks_hdr_tbl (p_index).cc_expiry_date := okc_api.g_miss_date;
754: x_oks_hdr_tbl (p_index).cc_bank_acct_id := okc_api.g_miss_num;
755: x_oks_hdr_tbl (p_index).cc_auth_code := okc_api.g_miss_char;
756: x_oks_hdr_tbl (p_index).commitment_id := okc_api.g_miss_num;
757: x_oks_hdr_tbl (p_index).grace_duration := okc_api.g_miss_num;

Line 754: x_oks_hdr_tbl (p_index).cc_bank_acct_id := okc_api.g_miss_num;

750: x_oks_hdr_tbl (p_index).acct_rule_id := okc_api.g_miss_num;
751: x_oks_hdr_tbl (p_index).payment_type := okc_api.g_miss_char;
752: x_oks_hdr_tbl (p_index).cc_no := okc_api.g_miss_char;
753: x_oks_hdr_tbl (p_index).cc_expiry_date := okc_api.g_miss_date;
754: x_oks_hdr_tbl (p_index).cc_bank_acct_id := okc_api.g_miss_num;
755: x_oks_hdr_tbl (p_index).cc_auth_code := okc_api.g_miss_char;
756: x_oks_hdr_tbl (p_index).commitment_id := okc_api.g_miss_num;
757: x_oks_hdr_tbl (p_index).grace_duration := okc_api.g_miss_num;
758: x_oks_hdr_tbl (p_index).grace_period := okc_api.g_miss_char;

Line 755: x_oks_hdr_tbl (p_index).cc_auth_code := okc_api.g_miss_char;

751: x_oks_hdr_tbl (p_index).payment_type := okc_api.g_miss_char;
752: x_oks_hdr_tbl (p_index).cc_no := okc_api.g_miss_char;
753: x_oks_hdr_tbl (p_index).cc_expiry_date := okc_api.g_miss_date;
754: x_oks_hdr_tbl (p_index).cc_bank_acct_id := okc_api.g_miss_num;
755: x_oks_hdr_tbl (p_index).cc_auth_code := okc_api.g_miss_char;
756: x_oks_hdr_tbl (p_index).commitment_id := okc_api.g_miss_num;
757: x_oks_hdr_tbl (p_index).grace_duration := okc_api.g_miss_num;
758: x_oks_hdr_tbl (p_index).grace_period := okc_api.g_miss_char;
759: x_oks_hdr_tbl (p_index).est_rev_percent := okc_api.g_miss_num;

Line 756: x_oks_hdr_tbl (p_index).commitment_id := okc_api.g_miss_num;

752: x_oks_hdr_tbl (p_index).cc_no := okc_api.g_miss_char;
753: x_oks_hdr_tbl (p_index).cc_expiry_date := okc_api.g_miss_date;
754: x_oks_hdr_tbl (p_index).cc_bank_acct_id := okc_api.g_miss_num;
755: x_oks_hdr_tbl (p_index).cc_auth_code := okc_api.g_miss_char;
756: x_oks_hdr_tbl (p_index).commitment_id := okc_api.g_miss_num;
757: x_oks_hdr_tbl (p_index).grace_duration := okc_api.g_miss_num;
758: x_oks_hdr_tbl (p_index).grace_period := okc_api.g_miss_char;
759: x_oks_hdr_tbl (p_index).est_rev_percent := okc_api.g_miss_num;
760: x_oks_hdr_tbl (p_index).est_rev_date := okc_api.g_miss_date;

Line 757: x_oks_hdr_tbl (p_index).grace_duration := okc_api.g_miss_num;

753: x_oks_hdr_tbl (p_index).cc_expiry_date := okc_api.g_miss_date;
754: x_oks_hdr_tbl (p_index).cc_bank_acct_id := okc_api.g_miss_num;
755: x_oks_hdr_tbl (p_index).cc_auth_code := okc_api.g_miss_char;
756: x_oks_hdr_tbl (p_index).commitment_id := okc_api.g_miss_num;
757: x_oks_hdr_tbl (p_index).grace_duration := okc_api.g_miss_num;
758: x_oks_hdr_tbl (p_index).grace_period := okc_api.g_miss_char;
759: x_oks_hdr_tbl (p_index).est_rev_percent := okc_api.g_miss_num;
760: x_oks_hdr_tbl (p_index).est_rev_date := okc_api.g_miss_date;
761: x_oks_hdr_tbl (p_index).tax_amount := okc_api.g_miss_num;

Line 758: x_oks_hdr_tbl (p_index).grace_period := okc_api.g_miss_char;

754: x_oks_hdr_tbl (p_index).cc_bank_acct_id := okc_api.g_miss_num;
755: x_oks_hdr_tbl (p_index).cc_auth_code := okc_api.g_miss_char;
756: x_oks_hdr_tbl (p_index).commitment_id := okc_api.g_miss_num;
757: x_oks_hdr_tbl (p_index).grace_duration := okc_api.g_miss_num;
758: x_oks_hdr_tbl (p_index).grace_period := okc_api.g_miss_char;
759: x_oks_hdr_tbl (p_index).est_rev_percent := okc_api.g_miss_num;
760: x_oks_hdr_tbl (p_index).est_rev_date := okc_api.g_miss_date;
761: x_oks_hdr_tbl (p_index).tax_amount := okc_api.g_miss_num;
762: x_oks_hdr_tbl (p_index).tax_status := okc_api.g_miss_char;

Line 759: x_oks_hdr_tbl (p_index).est_rev_percent := okc_api.g_miss_num;

755: x_oks_hdr_tbl (p_index).cc_auth_code := okc_api.g_miss_char;
756: x_oks_hdr_tbl (p_index).commitment_id := okc_api.g_miss_num;
757: x_oks_hdr_tbl (p_index).grace_duration := okc_api.g_miss_num;
758: x_oks_hdr_tbl (p_index).grace_period := okc_api.g_miss_char;
759: x_oks_hdr_tbl (p_index).est_rev_percent := okc_api.g_miss_num;
760: x_oks_hdr_tbl (p_index).est_rev_date := okc_api.g_miss_date;
761: x_oks_hdr_tbl (p_index).tax_amount := okc_api.g_miss_num;
762: x_oks_hdr_tbl (p_index).tax_status := okc_api.g_miss_char;
763: x_oks_hdr_tbl (p_index).tax_code := okc_api.g_miss_num;

Line 760: x_oks_hdr_tbl (p_index).est_rev_date := okc_api.g_miss_date;

756: x_oks_hdr_tbl (p_index).commitment_id := okc_api.g_miss_num;
757: x_oks_hdr_tbl (p_index).grace_duration := okc_api.g_miss_num;
758: x_oks_hdr_tbl (p_index).grace_period := okc_api.g_miss_char;
759: x_oks_hdr_tbl (p_index).est_rev_percent := okc_api.g_miss_num;
760: x_oks_hdr_tbl (p_index).est_rev_date := okc_api.g_miss_date;
761: x_oks_hdr_tbl (p_index).tax_amount := okc_api.g_miss_num;
762: x_oks_hdr_tbl (p_index).tax_status := okc_api.g_miss_char;
763: x_oks_hdr_tbl (p_index).tax_code := okc_api.g_miss_num;
764: x_oks_hdr_tbl (p_index).tax_exemption_id := okc_api.g_miss_num;

Line 761: x_oks_hdr_tbl (p_index).tax_amount := okc_api.g_miss_num;

757: x_oks_hdr_tbl (p_index).grace_duration := okc_api.g_miss_num;
758: x_oks_hdr_tbl (p_index).grace_period := okc_api.g_miss_char;
759: x_oks_hdr_tbl (p_index).est_rev_percent := okc_api.g_miss_num;
760: x_oks_hdr_tbl (p_index).est_rev_date := okc_api.g_miss_date;
761: x_oks_hdr_tbl (p_index).tax_amount := okc_api.g_miss_num;
762: x_oks_hdr_tbl (p_index).tax_status := okc_api.g_miss_char;
763: x_oks_hdr_tbl (p_index).tax_code := okc_api.g_miss_num;
764: x_oks_hdr_tbl (p_index).tax_exemption_id := okc_api.g_miss_num;
765: x_oks_hdr_tbl (p_index).billing_profile_id := okc_api.g_miss_num;

Line 762: x_oks_hdr_tbl (p_index).tax_status := okc_api.g_miss_char;

758: x_oks_hdr_tbl (p_index).grace_period := okc_api.g_miss_char;
759: x_oks_hdr_tbl (p_index).est_rev_percent := okc_api.g_miss_num;
760: x_oks_hdr_tbl (p_index).est_rev_date := okc_api.g_miss_date;
761: x_oks_hdr_tbl (p_index).tax_amount := okc_api.g_miss_num;
762: x_oks_hdr_tbl (p_index).tax_status := okc_api.g_miss_char;
763: x_oks_hdr_tbl (p_index).tax_code := okc_api.g_miss_num;
764: x_oks_hdr_tbl (p_index).tax_exemption_id := okc_api.g_miss_num;
765: x_oks_hdr_tbl (p_index).billing_profile_id := okc_api.g_miss_num;
766: x_oks_hdr_tbl (p_index).renewal_status := okc_api.g_miss_char;

Line 763: x_oks_hdr_tbl (p_index).tax_code := okc_api.g_miss_num;

759: x_oks_hdr_tbl (p_index).est_rev_percent := okc_api.g_miss_num;
760: x_oks_hdr_tbl (p_index).est_rev_date := okc_api.g_miss_date;
761: x_oks_hdr_tbl (p_index).tax_amount := okc_api.g_miss_num;
762: x_oks_hdr_tbl (p_index).tax_status := okc_api.g_miss_char;
763: x_oks_hdr_tbl (p_index).tax_code := okc_api.g_miss_num;
764: x_oks_hdr_tbl (p_index).tax_exemption_id := okc_api.g_miss_num;
765: x_oks_hdr_tbl (p_index).billing_profile_id := okc_api.g_miss_num;
766: x_oks_hdr_tbl (p_index).renewal_status := okc_api.g_miss_char;
767: x_oks_hdr_tbl (p_index).electronic_renewal_flag := okc_api.g_miss_char;

Line 764: x_oks_hdr_tbl (p_index).tax_exemption_id := okc_api.g_miss_num;

760: x_oks_hdr_tbl (p_index).est_rev_date := okc_api.g_miss_date;
761: x_oks_hdr_tbl (p_index).tax_amount := okc_api.g_miss_num;
762: x_oks_hdr_tbl (p_index).tax_status := okc_api.g_miss_char;
763: x_oks_hdr_tbl (p_index).tax_code := okc_api.g_miss_num;
764: x_oks_hdr_tbl (p_index).tax_exemption_id := okc_api.g_miss_num;
765: x_oks_hdr_tbl (p_index).billing_profile_id := okc_api.g_miss_num;
766: x_oks_hdr_tbl (p_index).renewal_status := okc_api.g_miss_char;
767: x_oks_hdr_tbl (p_index).electronic_renewal_flag := okc_api.g_miss_char;
768: x_oks_hdr_tbl (p_index).quote_to_contact_id := okc_api.g_miss_num;

Line 765: x_oks_hdr_tbl (p_index).billing_profile_id := okc_api.g_miss_num;

761: x_oks_hdr_tbl (p_index).tax_amount := okc_api.g_miss_num;
762: x_oks_hdr_tbl (p_index).tax_status := okc_api.g_miss_char;
763: x_oks_hdr_tbl (p_index).tax_code := okc_api.g_miss_num;
764: x_oks_hdr_tbl (p_index).tax_exemption_id := okc_api.g_miss_num;
765: x_oks_hdr_tbl (p_index).billing_profile_id := okc_api.g_miss_num;
766: x_oks_hdr_tbl (p_index).renewal_status := okc_api.g_miss_char;
767: x_oks_hdr_tbl (p_index).electronic_renewal_flag := okc_api.g_miss_char;
768: x_oks_hdr_tbl (p_index).quote_to_contact_id := okc_api.g_miss_num;
769: x_oks_hdr_tbl (p_index).quote_to_site_id := okc_api.g_miss_num;

Line 766: x_oks_hdr_tbl (p_index).renewal_status := okc_api.g_miss_char;

762: x_oks_hdr_tbl (p_index).tax_status := okc_api.g_miss_char;
763: x_oks_hdr_tbl (p_index).tax_code := okc_api.g_miss_num;
764: x_oks_hdr_tbl (p_index).tax_exemption_id := okc_api.g_miss_num;
765: x_oks_hdr_tbl (p_index).billing_profile_id := okc_api.g_miss_num;
766: x_oks_hdr_tbl (p_index).renewal_status := okc_api.g_miss_char;
767: x_oks_hdr_tbl (p_index).electronic_renewal_flag := okc_api.g_miss_char;
768: x_oks_hdr_tbl (p_index).quote_to_contact_id := okc_api.g_miss_num;
769: x_oks_hdr_tbl (p_index).quote_to_site_id := okc_api.g_miss_num;
770: x_oks_hdr_tbl (p_index).quote_to_email_id := okc_api.g_miss_num;

Line 767: x_oks_hdr_tbl (p_index).electronic_renewal_flag := okc_api.g_miss_char;

763: x_oks_hdr_tbl (p_index).tax_code := okc_api.g_miss_num;
764: x_oks_hdr_tbl (p_index).tax_exemption_id := okc_api.g_miss_num;
765: x_oks_hdr_tbl (p_index).billing_profile_id := okc_api.g_miss_num;
766: x_oks_hdr_tbl (p_index).renewal_status := okc_api.g_miss_char;
767: x_oks_hdr_tbl (p_index).electronic_renewal_flag := okc_api.g_miss_char;
768: x_oks_hdr_tbl (p_index).quote_to_contact_id := okc_api.g_miss_num;
769: x_oks_hdr_tbl (p_index).quote_to_site_id := okc_api.g_miss_num;
770: x_oks_hdr_tbl (p_index).quote_to_email_id := okc_api.g_miss_num;
771: x_oks_hdr_tbl (p_index).quote_to_phone_id := okc_api.g_miss_num;

Line 768: x_oks_hdr_tbl (p_index).quote_to_contact_id := okc_api.g_miss_num;

764: x_oks_hdr_tbl (p_index).tax_exemption_id := okc_api.g_miss_num;
765: x_oks_hdr_tbl (p_index).billing_profile_id := okc_api.g_miss_num;
766: x_oks_hdr_tbl (p_index).renewal_status := okc_api.g_miss_char;
767: x_oks_hdr_tbl (p_index).electronic_renewal_flag := okc_api.g_miss_char;
768: x_oks_hdr_tbl (p_index).quote_to_contact_id := okc_api.g_miss_num;
769: x_oks_hdr_tbl (p_index).quote_to_site_id := okc_api.g_miss_num;
770: x_oks_hdr_tbl (p_index).quote_to_email_id := okc_api.g_miss_num;
771: x_oks_hdr_tbl (p_index).quote_to_phone_id := okc_api.g_miss_num;
772: x_oks_hdr_tbl (p_index).quote_to_fax_id := okc_api.g_miss_num;

Line 769: x_oks_hdr_tbl (p_index).quote_to_site_id := okc_api.g_miss_num;

765: x_oks_hdr_tbl (p_index).billing_profile_id := okc_api.g_miss_num;
766: x_oks_hdr_tbl (p_index).renewal_status := okc_api.g_miss_char;
767: x_oks_hdr_tbl (p_index).electronic_renewal_flag := okc_api.g_miss_char;
768: x_oks_hdr_tbl (p_index).quote_to_contact_id := okc_api.g_miss_num;
769: x_oks_hdr_tbl (p_index).quote_to_site_id := okc_api.g_miss_num;
770: x_oks_hdr_tbl (p_index).quote_to_email_id := okc_api.g_miss_num;
771: x_oks_hdr_tbl (p_index).quote_to_phone_id := okc_api.g_miss_num;
772: x_oks_hdr_tbl (p_index).quote_to_fax_id := okc_api.g_miss_num;
773: x_oks_hdr_tbl (p_index).renewal_po_required := okc_api.g_miss_char;

Line 770: x_oks_hdr_tbl (p_index).quote_to_email_id := okc_api.g_miss_num;

766: x_oks_hdr_tbl (p_index).renewal_status := okc_api.g_miss_char;
767: x_oks_hdr_tbl (p_index).electronic_renewal_flag := okc_api.g_miss_char;
768: x_oks_hdr_tbl (p_index).quote_to_contact_id := okc_api.g_miss_num;
769: x_oks_hdr_tbl (p_index).quote_to_site_id := okc_api.g_miss_num;
770: x_oks_hdr_tbl (p_index).quote_to_email_id := okc_api.g_miss_num;
771: x_oks_hdr_tbl (p_index).quote_to_phone_id := okc_api.g_miss_num;
772: x_oks_hdr_tbl (p_index).quote_to_fax_id := okc_api.g_miss_num;
773: x_oks_hdr_tbl (p_index).renewal_po_required := okc_api.g_miss_char;
774: x_oks_hdr_tbl (p_index).renewal_po_number := okc_api.g_miss_char;

Line 771: x_oks_hdr_tbl (p_index).quote_to_phone_id := okc_api.g_miss_num;

767: x_oks_hdr_tbl (p_index).electronic_renewal_flag := okc_api.g_miss_char;
768: x_oks_hdr_tbl (p_index).quote_to_contact_id := okc_api.g_miss_num;
769: x_oks_hdr_tbl (p_index).quote_to_site_id := okc_api.g_miss_num;
770: x_oks_hdr_tbl (p_index).quote_to_email_id := okc_api.g_miss_num;
771: x_oks_hdr_tbl (p_index).quote_to_phone_id := okc_api.g_miss_num;
772: x_oks_hdr_tbl (p_index).quote_to_fax_id := okc_api.g_miss_num;
773: x_oks_hdr_tbl (p_index).renewal_po_required := okc_api.g_miss_char;
774: x_oks_hdr_tbl (p_index).renewal_po_number := okc_api.g_miss_char;
775: x_oks_hdr_tbl (p_index).renewal_price_list := okc_api.g_miss_num;

Line 772: x_oks_hdr_tbl (p_index).quote_to_fax_id := okc_api.g_miss_num;

768: x_oks_hdr_tbl (p_index).quote_to_contact_id := okc_api.g_miss_num;
769: x_oks_hdr_tbl (p_index).quote_to_site_id := okc_api.g_miss_num;
770: x_oks_hdr_tbl (p_index).quote_to_email_id := okc_api.g_miss_num;
771: x_oks_hdr_tbl (p_index).quote_to_phone_id := okc_api.g_miss_num;
772: x_oks_hdr_tbl (p_index).quote_to_fax_id := okc_api.g_miss_num;
773: x_oks_hdr_tbl (p_index).renewal_po_required := okc_api.g_miss_char;
774: x_oks_hdr_tbl (p_index).renewal_po_number := okc_api.g_miss_char;
775: x_oks_hdr_tbl (p_index).renewal_price_list := okc_api.g_miss_num;
776: x_oks_hdr_tbl (p_index).renewal_pricing_type := okc_api.g_miss_char;

Line 773: x_oks_hdr_tbl (p_index).renewal_po_required := okc_api.g_miss_char;

769: x_oks_hdr_tbl (p_index).quote_to_site_id := okc_api.g_miss_num;
770: x_oks_hdr_tbl (p_index).quote_to_email_id := okc_api.g_miss_num;
771: x_oks_hdr_tbl (p_index).quote_to_phone_id := okc_api.g_miss_num;
772: x_oks_hdr_tbl (p_index).quote_to_fax_id := okc_api.g_miss_num;
773: x_oks_hdr_tbl (p_index).renewal_po_required := okc_api.g_miss_char;
774: x_oks_hdr_tbl (p_index).renewal_po_number := okc_api.g_miss_char;
775: x_oks_hdr_tbl (p_index).renewal_price_list := okc_api.g_miss_num;
776: x_oks_hdr_tbl (p_index).renewal_pricing_type := okc_api.g_miss_char;
777: x_oks_hdr_tbl (p_index).renewal_markup_percent := okc_api.g_miss_num;

Line 774: x_oks_hdr_tbl (p_index).renewal_po_number := okc_api.g_miss_char;

770: x_oks_hdr_tbl (p_index).quote_to_email_id := okc_api.g_miss_num;
771: x_oks_hdr_tbl (p_index).quote_to_phone_id := okc_api.g_miss_num;
772: x_oks_hdr_tbl (p_index).quote_to_fax_id := okc_api.g_miss_num;
773: x_oks_hdr_tbl (p_index).renewal_po_required := okc_api.g_miss_char;
774: x_oks_hdr_tbl (p_index).renewal_po_number := okc_api.g_miss_char;
775: x_oks_hdr_tbl (p_index).renewal_price_list := okc_api.g_miss_num;
776: x_oks_hdr_tbl (p_index).renewal_pricing_type := okc_api.g_miss_char;
777: x_oks_hdr_tbl (p_index).renewal_markup_percent := okc_api.g_miss_num;
778: x_oks_hdr_tbl (p_index).renewal_grace_duration := okc_api.g_miss_num;

Line 775: x_oks_hdr_tbl (p_index).renewal_price_list := okc_api.g_miss_num;

771: x_oks_hdr_tbl (p_index).quote_to_phone_id := okc_api.g_miss_num;
772: x_oks_hdr_tbl (p_index).quote_to_fax_id := okc_api.g_miss_num;
773: x_oks_hdr_tbl (p_index).renewal_po_required := okc_api.g_miss_char;
774: x_oks_hdr_tbl (p_index).renewal_po_number := okc_api.g_miss_char;
775: x_oks_hdr_tbl (p_index).renewal_price_list := okc_api.g_miss_num;
776: x_oks_hdr_tbl (p_index).renewal_pricing_type := okc_api.g_miss_char;
777: x_oks_hdr_tbl (p_index).renewal_markup_percent := okc_api.g_miss_num;
778: x_oks_hdr_tbl (p_index).renewal_grace_duration := okc_api.g_miss_num;
779: x_oks_hdr_tbl (p_index).renewal_grace_period := okc_api.g_miss_char;

Line 776: x_oks_hdr_tbl (p_index).renewal_pricing_type := okc_api.g_miss_char;

772: x_oks_hdr_tbl (p_index).quote_to_fax_id := okc_api.g_miss_num;
773: x_oks_hdr_tbl (p_index).renewal_po_required := okc_api.g_miss_char;
774: x_oks_hdr_tbl (p_index).renewal_po_number := okc_api.g_miss_char;
775: x_oks_hdr_tbl (p_index).renewal_price_list := okc_api.g_miss_num;
776: x_oks_hdr_tbl (p_index).renewal_pricing_type := okc_api.g_miss_char;
777: x_oks_hdr_tbl (p_index).renewal_markup_percent := okc_api.g_miss_num;
778: x_oks_hdr_tbl (p_index).renewal_grace_duration := okc_api.g_miss_num;
779: x_oks_hdr_tbl (p_index).renewal_grace_period := okc_api.g_miss_char;
780: x_oks_hdr_tbl (p_index).renewal_est_rev_percent := okc_api.g_miss_num;

Line 777: x_oks_hdr_tbl (p_index).renewal_markup_percent := okc_api.g_miss_num;

773: x_oks_hdr_tbl (p_index).renewal_po_required := okc_api.g_miss_char;
774: x_oks_hdr_tbl (p_index).renewal_po_number := okc_api.g_miss_char;
775: x_oks_hdr_tbl (p_index).renewal_price_list := okc_api.g_miss_num;
776: x_oks_hdr_tbl (p_index).renewal_pricing_type := okc_api.g_miss_char;
777: x_oks_hdr_tbl (p_index).renewal_markup_percent := okc_api.g_miss_num;
778: x_oks_hdr_tbl (p_index).renewal_grace_duration := okc_api.g_miss_num;
779: x_oks_hdr_tbl (p_index).renewal_grace_period := okc_api.g_miss_char;
780: x_oks_hdr_tbl (p_index).renewal_est_rev_percent := okc_api.g_miss_num;
781: x_oks_hdr_tbl (p_index).renewal_est_rev_duration

Line 778: x_oks_hdr_tbl (p_index).renewal_grace_duration := okc_api.g_miss_num;

774: x_oks_hdr_tbl (p_index).renewal_po_number := okc_api.g_miss_char;
775: x_oks_hdr_tbl (p_index).renewal_price_list := okc_api.g_miss_num;
776: x_oks_hdr_tbl (p_index).renewal_pricing_type := okc_api.g_miss_char;
777: x_oks_hdr_tbl (p_index).renewal_markup_percent := okc_api.g_miss_num;
778: x_oks_hdr_tbl (p_index).renewal_grace_duration := okc_api.g_miss_num;
779: x_oks_hdr_tbl (p_index).renewal_grace_period := okc_api.g_miss_char;
780: x_oks_hdr_tbl (p_index).renewal_est_rev_percent := okc_api.g_miss_num;
781: x_oks_hdr_tbl (p_index).renewal_est_rev_duration
782: := okc_api.g_miss_num;

Line 779: x_oks_hdr_tbl (p_index).renewal_grace_period := okc_api.g_miss_char;

775: x_oks_hdr_tbl (p_index).renewal_price_list := okc_api.g_miss_num;
776: x_oks_hdr_tbl (p_index).renewal_pricing_type := okc_api.g_miss_char;
777: x_oks_hdr_tbl (p_index).renewal_markup_percent := okc_api.g_miss_num;
778: x_oks_hdr_tbl (p_index).renewal_grace_duration := okc_api.g_miss_num;
779: x_oks_hdr_tbl (p_index).renewal_grace_period := okc_api.g_miss_char;
780: x_oks_hdr_tbl (p_index).renewal_est_rev_percent := okc_api.g_miss_num;
781: x_oks_hdr_tbl (p_index).renewal_est_rev_duration
782: := okc_api.g_miss_num;
783: x_oks_hdr_tbl (p_index).renewal_est_rev_period := okc_api.g_miss_char;

Line 780: x_oks_hdr_tbl (p_index).renewal_est_rev_percent := okc_api.g_miss_num;

776: x_oks_hdr_tbl (p_index).renewal_pricing_type := okc_api.g_miss_char;
777: x_oks_hdr_tbl (p_index).renewal_markup_percent := okc_api.g_miss_num;
778: x_oks_hdr_tbl (p_index).renewal_grace_duration := okc_api.g_miss_num;
779: x_oks_hdr_tbl (p_index).renewal_grace_period := okc_api.g_miss_char;
780: x_oks_hdr_tbl (p_index).renewal_est_rev_percent := okc_api.g_miss_num;
781: x_oks_hdr_tbl (p_index).renewal_est_rev_duration
782: := okc_api.g_miss_num;
783: x_oks_hdr_tbl (p_index).renewal_est_rev_period := okc_api.g_miss_char;
784: x_oks_hdr_tbl (p_index).renewal_price_list_used := okc_api.g_miss_num;

Line 782: := okc_api.g_miss_num;

778: x_oks_hdr_tbl (p_index).renewal_grace_duration := okc_api.g_miss_num;
779: x_oks_hdr_tbl (p_index).renewal_grace_period := okc_api.g_miss_char;
780: x_oks_hdr_tbl (p_index).renewal_est_rev_percent := okc_api.g_miss_num;
781: x_oks_hdr_tbl (p_index).renewal_est_rev_duration
782: := okc_api.g_miss_num;
783: x_oks_hdr_tbl (p_index).renewal_est_rev_period := okc_api.g_miss_char;
784: x_oks_hdr_tbl (p_index).renewal_price_list_used := okc_api.g_miss_num;
785: x_oks_hdr_tbl (p_index).renewal_type_used := okc_api.g_miss_char;
786: x_oks_hdr_tbl (p_index).renewal_notification_to := okc_api.g_miss_num;

Line 783: x_oks_hdr_tbl (p_index).renewal_est_rev_period := okc_api.g_miss_char;

779: x_oks_hdr_tbl (p_index).renewal_grace_period := okc_api.g_miss_char;
780: x_oks_hdr_tbl (p_index).renewal_est_rev_percent := okc_api.g_miss_num;
781: x_oks_hdr_tbl (p_index).renewal_est_rev_duration
782: := okc_api.g_miss_num;
783: x_oks_hdr_tbl (p_index).renewal_est_rev_period := okc_api.g_miss_char;
784: x_oks_hdr_tbl (p_index).renewal_price_list_used := okc_api.g_miss_num;
785: x_oks_hdr_tbl (p_index).renewal_type_used := okc_api.g_miss_char;
786: x_oks_hdr_tbl (p_index).renewal_notification_to := okc_api.g_miss_num;
787: x_oks_hdr_tbl (p_index).renewal_po_used := okc_api.g_miss_char;

Line 784: x_oks_hdr_tbl (p_index).renewal_price_list_used := okc_api.g_miss_num;

780: x_oks_hdr_tbl (p_index).renewal_est_rev_percent := okc_api.g_miss_num;
781: x_oks_hdr_tbl (p_index).renewal_est_rev_duration
782: := okc_api.g_miss_num;
783: x_oks_hdr_tbl (p_index).renewal_est_rev_period := okc_api.g_miss_char;
784: x_oks_hdr_tbl (p_index).renewal_price_list_used := okc_api.g_miss_num;
785: x_oks_hdr_tbl (p_index).renewal_type_used := okc_api.g_miss_char;
786: x_oks_hdr_tbl (p_index).renewal_notification_to := okc_api.g_miss_num;
787: x_oks_hdr_tbl (p_index).renewal_po_used := okc_api.g_miss_char;
788: x_oks_hdr_tbl (p_index).renewal_pricing_type_used

Line 785: x_oks_hdr_tbl (p_index).renewal_type_used := okc_api.g_miss_char;

781: x_oks_hdr_tbl (p_index).renewal_est_rev_duration
782: := okc_api.g_miss_num;
783: x_oks_hdr_tbl (p_index).renewal_est_rev_period := okc_api.g_miss_char;
784: x_oks_hdr_tbl (p_index).renewal_price_list_used := okc_api.g_miss_num;
785: x_oks_hdr_tbl (p_index).renewal_type_used := okc_api.g_miss_char;
786: x_oks_hdr_tbl (p_index).renewal_notification_to := okc_api.g_miss_num;
787: x_oks_hdr_tbl (p_index).renewal_po_used := okc_api.g_miss_char;
788: x_oks_hdr_tbl (p_index).renewal_pricing_type_used
789: := okc_api.g_miss_char;

Line 786: x_oks_hdr_tbl (p_index).renewal_notification_to := okc_api.g_miss_num;

782: := okc_api.g_miss_num;
783: x_oks_hdr_tbl (p_index).renewal_est_rev_period := okc_api.g_miss_char;
784: x_oks_hdr_tbl (p_index).renewal_price_list_used := okc_api.g_miss_num;
785: x_oks_hdr_tbl (p_index).renewal_type_used := okc_api.g_miss_char;
786: x_oks_hdr_tbl (p_index).renewal_notification_to := okc_api.g_miss_num;
787: x_oks_hdr_tbl (p_index).renewal_po_used := okc_api.g_miss_char;
788: x_oks_hdr_tbl (p_index).renewal_pricing_type_used
789: := okc_api.g_miss_char;
790: x_oks_hdr_tbl (p_index).renewal_markup_percent_used

Line 787: x_oks_hdr_tbl (p_index).renewal_po_used := okc_api.g_miss_char;

783: x_oks_hdr_tbl (p_index).renewal_est_rev_period := okc_api.g_miss_char;
784: x_oks_hdr_tbl (p_index).renewal_price_list_used := okc_api.g_miss_num;
785: x_oks_hdr_tbl (p_index).renewal_type_used := okc_api.g_miss_char;
786: x_oks_hdr_tbl (p_index).renewal_notification_to := okc_api.g_miss_num;
787: x_oks_hdr_tbl (p_index).renewal_po_used := okc_api.g_miss_char;
788: x_oks_hdr_tbl (p_index).renewal_pricing_type_used
789: := okc_api.g_miss_char;
790: x_oks_hdr_tbl (p_index).renewal_markup_percent_used
791: := okc_api.g_miss_num;

Line 789: := okc_api.g_miss_char;

785: x_oks_hdr_tbl (p_index).renewal_type_used := okc_api.g_miss_char;
786: x_oks_hdr_tbl (p_index).renewal_notification_to := okc_api.g_miss_num;
787: x_oks_hdr_tbl (p_index).renewal_po_used := okc_api.g_miss_char;
788: x_oks_hdr_tbl (p_index).renewal_pricing_type_used
789: := okc_api.g_miss_char;
790: x_oks_hdr_tbl (p_index).renewal_markup_percent_used
791: := okc_api.g_miss_num;
792: x_oks_hdr_tbl (p_index).rev_est_percent_used := okc_api.g_miss_num;
793: x_oks_hdr_tbl (p_index).rev_est_duration_used := okc_api.g_miss_num;

Line 791: := okc_api.g_miss_num;

787: x_oks_hdr_tbl (p_index).renewal_po_used := okc_api.g_miss_char;
788: x_oks_hdr_tbl (p_index).renewal_pricing_type_used
789: := okc_api.g_miss_char;
790: x_oks_hdr_tbl (p_index).renewal_markup_percent_used
791: := okc_api.g_miss_num;
792: x_oks_hdr_tbl (p_index).rev_est_percent_used := okc_api.g_miss_num;
793: x_oks_hdr_tbl (p_index).rev_est_duration_used := okc_api.g_miss_num;
794: x_oks_hdr_tbl (p_index).rev_est_period_used := okc_api.g_miss_char;
795: x_oks_hdr_tbl (p_index).billing_profile_used := okc_api.g_miss_num;

Line 792: x_oks_hdr_tbl (p_index).rev_est_percent_used := okc_api.g_miss_num;

788: x_oks_hdr_tbl (p_index).renewal_pricing_type_used
789: := okc_api.g_miss_char;
790: x_oks_hdr_tbl (p_index).renewal_markup_percent_used
791: := okc_api.g_miss_num;
792: x_oks_hdr_tbl (p_index).rev_est_percent_used := okc_api.g_miss_num;
793: x_oks_hdr_tbl (p_index).rev_est_duration_used := okc_api.g_miss_num;
794: x_oks_hdr_tbl (p_index).rev_est_period_used := okc_api.g_miss_char;
795: x_oks_hdr_tbl (p_index).billing_profile_used := okc_api.g_miss_num;
796: x_oks_hdr_tbl (p_index).ern_flag_used_yn := okc_api.g_miss_char;

Line 793: x_oks_hdr_tbl (p_index).rev_est_duration_used := okc_api.g_miss_num;

789: := okc_api.g_miss_char;
790: x_oks_hdr_tbl (p_index).renewal_markup_percent_used
791: := okc_api.g_miss_num;
792: x_oks_hdr_tbl (p_index).rev_est_percent_used := okc_api.g_miss_num;
793: x_oks_hdr_tbl (p_index).rev_est_duration_used := okc_api.g_miss_num;
794: x_oks_hdr_tbl (p_index).rev_est_period_used := okc_api.g_miss_char;
795: x_oks_hdr_tbl (p_index).billing_profile_used := okc_api.g_miss_num;
796: x_oks_hdr_tbl (p_index).ern_flag_used_yn := okc_api.g_miss_char;
797: x_oks_hdr_tbl (p_index).evn_threshold_amt := okc_api.g_miss_num;

Line 794: x_oks_hdr_tbl (p_index).rev_est_period_used := okc_api.g_miss_char;

790: x_oks_hdr_tbl (p_index).renewal_markup_percent_used
791: := okc_api.g_miss_num;
792: x_oks_hdr_tbl (p_index).rev_est_percent_used := okc_api.g_miss_num;
793: x_oks_hdr_tbl (p_index).rev_est_duration_used := okc_api.g_miss_num;
794: x_oks_hdr_tbl (p_index).rev_est_period_used := okc_api.g_miss_char;
795: x_oks_hdr_tbl (p_index).billing_profile_used := okc_api.g_miss_num;
796: x_oks_hdr_tbl (p_index).ern_flag_used_yn := okc_api.g_miss_char;
797: x_oks_hdr_tbl (p_index).evn_threshold_amt := okc_api.g_miss_num;
798: x_oks_hdr_tbl (p_index).evn_threshold_cur := okc_api.g_miss_char;

Line 795: x_oks_hdr_tbl (p_index).billing_profile_used := okc_api.g_miss_num;

791: := okc_api.g_miss_num;
792: x_oks_hdr_tbl (p_index).rev_est_percent_used := okc_api.g_miss_num;
793: x_oks_hdr_tbl (p_index).rev_est_duration_used := okc_api.g_miss_num;
794: x_oks_hdr_tbl (p_index).rev_est_period_used := okc_api.g_miss_char;
795: x_oks_hdr_tbl (p_index).billing_profile_used := okc_api.g_miss_num;
796: x_oks_hdr_tbl (p_index).ern_flag_used_yn := okc_api.g_miss_char;
797: x_oks_hdr_tbl (p_index).evn_threshold_amt := okc_api.g_miss_num;
798: x_oks_hdr_tbl (p_index).evn_threshold_cur := okc_api.g_miss_char;
799: x_oks_hdr_tbl (p_index).ern_threshold_amt := okc_api.g_miss_num;

Line 796: x_oks_hdr_tbl (p_index).ern_flag_used_yn := okc_api.g_miss_char;

792: x_oks_hdr_tbl (p_index).rev_est_percent_used := okc_api.g_miss_num;
793: x_oks_hdr_tbl (p_index).rev_est_duration_used := okc_api.g_miss_num;
794: x_oks_hdr_tbl (p_index).rev_est_period_used := okc_api.g_miss_char;
795: x_oks_hdr_tbl (p_index).billing_profile_used := okc_api.g_miss_num;
796: x_oks_hdr_tbl (p_index).ern_flag_used_yn := okc_api.g_miss_char;
797: x_oks_hdr_tbl (p_index).evn_threshold_amt := okc_api.g_miss_num;
798: x_oks_hdr_tbl (p_index).evn_threshold_cur := okc_api.g_miss_char;
799: x_oks_hdr_tbl (p_index).ern_threshold_amt := okc_api.g_miss_num;
800: x_oks_hdr_tbl (p_index).ern_threshold_cur := okc_api.g_miss_char;

Line 797: x_oks_hdr_tbl (p_index).evn_threshold_amt := okc_api.g_miss_num;

793: x_oks_hdr_tbl (p_index).rev_est_duration_used := okc_api.g_miss_num;
794: x_oks_hdr_tbl (p_index).rev_est_period_used := okc_api.g_miss_char;
795: x_oks_hdr_tbl (p_index).billing_profile_used := okc_api.g_miss_num;
796: x_oks_hdr_tbl (p_index).ern_flag_used_yn := okc_api.g_miss_char;
797: x_oks_hdr_tbl (p_index).evn_threshold_amt := okc_api.g_miss_num;
798: x_oks_hdr_tbl (p_index).evn_threshold_cur := okc_api.g_miss_char;
799: x_oks_hdr_tbl (p_index).ern_threshold_amt := okc_api.g_miss_num;
800: x_oks_hdr_tbl (p_index).ern_threshold_cur := okc_api.g_miss_char;
801: x_oks_hdr_tbl (p_index).renewal_grace_duration_used

Line 798: x_oks_hdr_tbl (p_index).evn_threshold_cur := okc_api.g_miss_char;

794: x_oks_hdr_tbl (p_index).rev_est_period_used := okc_api.g_miss_char;
795: x_oks_hdr_tbl (p_index).billing_profile_used := okc_api.g_miss_num;
796: x_oks_hdr_tbl (p_index).ern_flag_used_yn := okc_api.g_miss_char;
797: x_oks_hdr_tbl (p_index).evn_threshold_amt := okc_api.g_miss_num;
798: x_oks_hdr_tbl (p_index).evn_threshold_cur := okc_api.g_miss_char;
799: x_oks_hdr_tbl (p_index).ern_threshold_amt := okc_api.g_miss_num;
800: x_oks_hdr_tbl (p_index).ern_threshold_cur := okc_api.g_miss_char;
801: x_oks_hdr_tbl (p_index).renewal_grace_duration_used
802: := okc_api.g_miss_num;

Line 799: x_oks_hdr_tbl (p_index).ern_threshold_amt := okc_api.g_miss_num;

795: x_oks_hdr_tbl (p_index).billing_profile_used := okc_api.g_miss_num;
796: x_oks_hdr_tbl (p_index).ern_flag_used_yn := okc_api.g_miss_char;
797: x_oks_hdr_tbl (p_index).evn_threshold_amt := okc_api.g_miss_num;
798: x_oks_hdr_tbl (p_index).evn_threshold_cur := okc_api.g_miss_char;
799: x_oks_hdr_tbl (p_index).ern_threshold_amt := okc_api.g_miss_num;
800: x_oks_hdr_tbl (p_index).ern_threshold_cur := okc_api.g_miss_char;
801: x_oks_hdr_tbl (p_index).renewal_grace_duration_used
802: := okc_api.g_miss_num;
803: x_oks_hdr_tbl (p_index).renewal_grace_period_used

Line 800: x_oks_hdr_tbl (p_index).ern_threshold_cur := okc_api.g_miss_char;

796: x_oks_hdr_tbl (p_index).ern_flag_used_yn := okc_api.g_miss_char;
797: x_oks_hdr_tbl (p_index).evn_threshold_amt := okc_api.g_miss_num;
798: x_oks_hdr_tbl (p_index).evn_threshold_cur := okc_api.g_miss_char;
799: x_oks_hdr_tbl (p_index).ern_threshold_amt := okc_api.g_miss_num;
800: x_oks_hdr_tbl (p_index).ern_threshold_cur := okc_api.g_miss_char;
801: x_oks_hdr_tbl (p_index).renewal_grace_duration_used
802: := okc_api.g_miss_num;
803: x_oks_hdr_tbl (p_index).renewal_grace_period_used
804: := okc_api.g_miss_char;

Line 802: := okc_api.g_miss_num;

798: x_oks_hdr_tbl (p_index).evn_threshold_cur := okc_api.g_miss_char;
799: x_oks_hdr_tbl (p_index).ern_threshold_amt := okc_api.g_miss_num;
800: x_oks_hdr_tbl (p_index).ern_threshold_cur := okc_api.g_miss_char;
801: x_oks_hdr_tbl (p_index).renewal_grace_duration_used
802: := okc_api.g_miss_num;
803: x_oks_hdr_tbl (p_index).renewal_grace_period_used
804: := okc_api.g_miss_char;
805: x_oks_hdr_tbl (p_index).inv_trx_type := okc_api.g_miss_char;
806: x_oks_hdr_tbl (p_index).inv_print_profile := okc_api.g_miss_char;

Line 804: := okc_api.g_miss_char;

800: x_oks_hdr_tbl (p_index).ern_threshold_cur := okc_api.g_miss_char;
801: x_oks_hdr_tbl (p_index).renewal_grace_duration_used
802: := okc_api.g_miss_num;
803: x_oks_hdr_tbl (p_index).renewal_grace_period_used
804: := okc_api.g_miss_char;
805: x_oks_hdr_tbl (p_index).inv_trx_type := okc_api.g_miss_char;
806: x_oks_hdr_tbl (p_index).inv_print_profile := okc_api.g_miss_char;
807: x_oks_hdr_tbl (p_index).ar_interface_yn := okc_api.g_miss_char;
808: x_oks_hdr_tbl (p_index).hold_billing := okc_api.g_miss_char;

Line 805: x_oks_hdr_tbl (p_index).inv_trx_type := okc_api.g_miss_char;

801: x_oks_hdr_tbl (p_index).renewal_grace_duration_used
802: := okc_api.g_miss_num;
803: x_oks_hdr_tbl (p_index).renewal_grace_period_used
804: := okc_api.g_miss_char;
805: x_oks_hdr_tbl (p_index).inv_trx_type := okc_api.g_miss_char;
806: x_oks_hdr_tbl (p_index).inv_print_profile := okc_api.g_miss_char;
807: x_oks_hdr_tbl (p_index).ar_interface_yn := okc_api.g_miss_char;
808: x_oks_hdr_tbl (p_index).hold_billing := okc_api.g_miss_char;
809: x_oks_hdr_tbl (p_index).summary_trx_yn := okc_api.g_miss_char;

Line 806: x_oks_hdr_tbl (p_index).inv_print_profile := okc_api.g_miss_char;

802: := okc_api.g_miss_num;
803: x_oks_hdr_tbl (p_index).renewal_grace_period_used
804: := okc_api.g_miss_char;
805: x_oks_hdr_tbl (p_index).inv_trx_type := okc_api.g_miss_char;
806: x_oks_hdr_tbl (p_index).inv_print_profile := okc_api.g_miss_char;
807: x_oks_hdr_tbl (p_index).ar_interface_yn := okc_api.g_miss_char;
808: x_oks_hdr_tbl (p_index).hold_billing := okc_api.g_miss_char;
809: x_oks_hdr_tbl (p_index).summary_trx_yn := okc_api.g_miss_char;
810: x_oks_hdr_tbl (p_index).service_po_number := okc_api.g_miss_char;

Line 807: x_oks_hdr_tbl (p_index).ar_interface_yn := okc_api.g_miss_char;

803: x_oks_hdr_tbl (p_index).renewal_grace_period_used
804: := okc_api.g_miss_char;
805: x_oks_hdr_tbl (p_index).inv_trx_type := okc_api.g_miss_char;
806: x_oks_hdr_tbl (p_index).inv_print_profile := okc_api.g_miss_char;
807: x_oks_hdr_tbl (p_index).ar_interface_yn := okc_api.g_miss_char;
808: x_oks_hdr_tbl (p_index).hold_billing := okc_api.g_miss_char;
809: x_oks_hdr_tbl (p_index).summary_trx_yn := okc_api.g_miss_char;
810: x_oks_hdr_tbl (p_index).service_po_number := okc_api.g_miss_char;
811: x_oks_hdr_tbl (p_index).service_po_required := okc_api.g_miss_char;

Line 808: x_oks_hdr_tbl (p_index).hold_billing := okc_api.g_miss_char;

804: := okc_api.g_miss_char;
805: x_oks_hdr_tbl (p_index).inv_trx_type := okc_api.g_miss_char;
806: x_oks_hdr_tbl (p_index).inv_print_profile := okc_api.g_miss_char;
807: x_oks_hdr_tbl (p_index).ar_interface_yn := okc_api.g_miss_char;
808: x_oks_hdr_tbl (p_index).hold_billing := okc_api.g_miss_char;
809: x_oks_hdr_tbl (p_index).summary_trx_yn := okc_api.g_miss_char;
810: x_oks_hdr_tbl (p_index).service_po_number := okc_api.g_miss_char;
811: x_oks_hdr_tbl (p_index).service_po_required := okc_api.g_miss_char;
812: x_oks_hdr_tbl (p_index).object_version_number := okc_api.g_miss_num;

Line 809: x_oks_hdr_tbl (p_index).summary_trx_yn := okc_api.g_miss_char;

805: x_oks_hdr_tbl (p_index).inv_trx_type := okc_api.g_miss_char;
806: x_oks_hdr_tbl (p_index).inv_print_profile := okc_api.g_miss_char;
807: x_oks_hdr_tbl (p_index).ar_interface_yn := okc_api.g_miss_char;
808: x_oks_hdr_tbl (p_index).hold_billing := okc_api.g_miss_char;
809: x_oks_hdr_tbl (p_index).summary_trx_yn := okc_api.g_miss_char;
810: x_oks_hdr_tbl (p_index).service_po_number := okc_api.g_miss_char;
811: x_oks_hdr_tbl (p_index).service_po_required := okc_api.g_miss_char;
812: x_oks_hdr_tbl (p_index).object_version_number := okc_api.g_miss_num;
813: x_oks_hdr_tbl (p_index).security_group_id := okc_api.g_miss_num;

Line 810: x_oks_hdr_tbl (p_index).service_po_number := okc_api.g_miss_char;

806: x_oks_hdr_tbl (p_index).inv_print_profile := okc_api.g_miss_char;
807: x_oks_hdr_tbl (p_index).ar_interface_yn := okc_api.g_miss_char;
808: x_oks_hdr_tbl (p_index).hold_billing := okc_api.g_miss_char;
809: x_oks_hdr_tbl (p_index).summary_trx_yn := okc_api.g_miss_char;
810: x_oks_hdr_tbl (p_index).service_po_number := okc_api.g_miss_char;
811: x_oks_hdr_tbl (p_index).service_po_required := okc_api.g_miss_char;
812: x_oks_hdr_tbl (p_index).object_version_number := okc_api.g_miss_num;
813: x_oks_hdr_tbl (p_index).security_group_id := okc_api.g_miss_num;
814: x_oks_hdr_tbl (p_index).request_id := okc_api.g_miss_num;

Line 811: x_oks_hdr_tbl (p_index).service_po_required := okc_api.g_miss_char;

807: x_oks_hdr_tbl (p_index).ar_interface_yn := okc_api.g_miss_char;
808: x_oks_hdr_tbl (p_index).hold_billing := okc_api.g_miss_char;
809: x_oks_hdr_tbl (p_index).summary_trx_yn := okc_api.g_miss_char;
810: x_oks_hdr_tbl (p_index).service_po_number := okc_api.g_miss_char;
811: x_oks_hdr_tbl (p_index).service_po_required := okc_api.g_miss_char;
812: x_oks_hdr_tbl (p_index).object_version_number := okc_api.g_miss_num;
813: x_oks_hdr_tbl (p_index).security_group_id := okc_api.g_miss_num;
814: x_oks_hdr_tbl (p_index).request_id := okc_api.g_miss_num;
815: x_oks_hdr_tbl (p_index).created_by := okc_api.g_miss_num;

Line 812: x_oks_hdr_tbl (p_index).object_version_number := okc_api.g_miss_num;

808: x_oks_hdr_tbl (p_index).hold_billing := okc_api.g_miss_char;
809: x_oks_hdr_tbl (p_index).summary_trx_yn := okc_api.g_miss_char;
810: x_oks_hdr_tbl (p_index).service_po_number := okc_api.g_miss_char;
811: x_oks_hdr_tbl (p_index).service_po_required := okc_api.g_miss_char;
812: x_oks_hdr_tbl (p_index).object_version_number := okc_api.g_miss_num;
813: x_oks_hdr_tbl (p_index).security_group_id := okc_api.g_miss_num;
814: x_oks_hdr_tbl (p_index).request_id := okc_api.g_miss_num;
815: x_oks_hdr_tbl (p_index).created_by := okc_api.g_miss_num;
816: x_oks_hdr_tbl (p_index).creation_date := okc_api.g_miss_date;

Line 813: x_oks_hdr_tbl (p_index).security_group_id := okc_api.g_miss_num;

809: x_oks_hdr_tbl (p_index).summary_trx_yn := okc_api.g_miss_char;
810: x_oks_hdr_tbl (p_index).service_po_number := okc_api.g_miss_char;
811: x_oks_hdr_tbl (p_index).service_po_required := okc_api.g_miss_char;
812: x_oks_hdr_tbl (p_index).object_version_number := okc_api.g_miss_num;
813: x_oks_hdr_tbl (p_index).security_group_id := okc_api.g_miss_num;
814: x_oks_hdr_tbl (p_index).request_id := okc_api.g_miss_num;
815: x_oks_hdr_tbl (p_index).created_by := okc_api.g_miss_num;
816: x_oks_hdr_tbl (p_index).creation_date := okc_api.g_miss_date;
817: x_oks_hdr_tbl (p_index).last_updated_by := okc_api.g_miss_num;

Line 814: x_oks_hdr_tbl (p_index).request_id := okc_api.g_miss_num;

810: x_oks_hdr_tbl (p_index).service_po_number := okc_api.g_miss_char;
811: x_oks_hdr_tbl (p_index).service_po_required := okc_api.g_miss_char;
812: x_oks_hdr_tbl (p_index).object_version_number := okc_api.g_miss_num;
813: x_oks_hdr_tbl (p_index).security_group_id := okc_api.g_miss_num;
814: x_oks_hdr_tbl (p_index).request_id := okc_api.g_miss_num;
815: x_oks_hdr_tbl (p_index).created_by := okc_api.g_miss_num;
816: x_oks_hdr_tbl (p_index).creation_date := okc_api.g_miss_date;
817: x_oks_hdr_tbl (p_index).last_updated_by := okc_api.g_miss_num;
818: x_oks_hdr_tbl (p_index).last_update_date := okc_api.g_miss_date;

Line 815: x_oks_hdr_tbl (p_index).created_by := okc_api.g_miss_num;

811: x_oks_hdr_tbl (p_index).service_po_required := okc_api.g_miss_char;
812: x_oks_hdr_tbl (p_index).object_version_number := okc_api.g_miss_num;
813: x_oks_hdr_tbl (p_index).security_group_id := okc_api.g_miss_num;
814: x_oks_hdr_tbl (p_index).request_id := okc_api.g_miss_num;
815: x_oks_hdr_tbl (p_index).created_by := okc_api.g_miss_num;
816: x_oks_hdr_tbl (p_index).creation_date := okc_api.g_miss_date;
817: x_oks_hdr_tbl (p_index).last_updated_by := okc_api.g_miss_num;
818: x_oks_hdr_tbl (p_index).last_update_date := okc_api.g_miss_date;
819: x_oks_hdr_tbl (p_index).last_update_login := okc_api.g_miss_num;

Line 816: x_oks_hdr_tbl (p_index).creation_date := okc_api.g_miss_date;

812: x_oks_hdr_tbl (p_index).object_version_number := okc_api.g_miss_num;
813: x_oks_hdr_tbl (p_index).security_group_id := okc_api.g_miss_num;
814: x_oks_hdr_tbl (p_index).request_id := okc_api.g_miss_num;
815: x_oks_hdr_tbl (p_index).created_by := okc_api.g_miss_num;
816: x_oks_hdr_tbl (p_index).creation_date := okc_api.g_miss_date;
817: x_oks_hdr_tbl (p_index).last_updated_by := okc_api.g_miss_num;
818: x_oks_hdr_tbl (p_index).last_update_date := okc_api.g_miss_date;
819: x_oks_hdr_tbl (p_index).last_update_login := okc_api.g_miss_num;
820: /*Email Quote Added for ER 13869562 spingali*/

Line 817: x_oks_hdr_tbl (p_index).last_updated_by := okc_api.g_miss_num;

813: x_oks_hdr_tbl (p_index).security_group_id := okc_api.g_miss_num;
814: x_oks_hdr_tbl (p_index).request_id := okc_api.g_miss_num;
815: x_oks_hdr_tbl (p_index).created_by := okc_api.g_miss_num;
816: x_oks_hdr_tbl (p_index).creation_date := okc_api.g_miss_date;
817: x_oks_hdr_tbl (p_index).last_updated_by := okc_api.g_miss_num;
818: x_oks_hdr_tbl (p_index).last_update_date := okc_api.g_miss_date;
819: x_oks_hdr_tbl (p_index).last_update_login := okc_api.g_miss_num;
820: /*Email Quote Added for ER 13869562 spingali*/
821: x_oks_hdr_tbl (p_index).cc_email_address := okc_api.g_miss_char;

Line 818: x_oks_hdr_tbl (p_index).last_update_date := okc_api.g_miss_date;

814: x_oks_hdr_tbl (p_index).request_id := okc_api.g_miss_num;
815: x_oks_hdr_tbl (p_index).created_by := okc_api.g_miss_num;
816: x_oks_hdr_tbl (p_index).creation_date := okc_api.g_miss_date;
817: x_oks_hdr_tbl (p_index).last_updated_by := okc_api.g_miss_num;
818: x_oks_hdr_tbl (p_index).last_update_date := okc_api.g_miss_date;
819: x_oks_hdr_tbl (p_index).last_update_login := okc_api.g_miss_num;
820: /*Email Quote Added for ER 13869562 spingali*/
821: x_oks_hdr_tbl (p_index).cc_email_address := okc_api.g_miss_char;
822: /*Email Quote Added for ER 13869562 spingali*/

Line 819: x_oks_hdr_tbl (p_index).last_update_login := okc_api.g_miss_num;

815: x_oks_hdr_tbl (p_index).created_by := okc_api.g_miss_num;
816: x_oks_hdr_tbl (p_index).creation_date := okc_api.g_miss_date;
817: x_oks_hdr_tbl (p_index).last_updated_by := okc_api.g_miss_num;
818: x_oks_hdr_tbl (p_index).last_update_date := okc_api.g_miss_date;
819: x_oks_hdr_tbl (p_index).last_update_login := okc_api.g_miss_num;
820: /*Email Quote Added for ER 13869562 spingali*/
821: x_oks_hdr_tbl (p_index).cc_email_address := okc_api.g_miss_char;
822: /*Email Quote Added for ER 13869562 spingali*/
823:

Line 821: x_oks_hdr_tbl (p_index).cc_email_address := okc_api.g_miss_char;

817: x_oks_hdr_tbl (p_index).last_updated_by := okc_api.g_miss_num;
818: x_oks_hdr_tbl (p_index).last_update_date := okc_api.g_miss_date;
819: x_oks_hdr_tbl (p_index).last_update_login := okc_api.g_miss_num;
820: /*Email Quote Added for ER 13869562 spingali*/
821: x_oks_hdr_tbl (p_index).cc_email_address := okc_api.g_miss_char;
822: /*Email Quote Added for ER 13869562 spingali*/
823:
824: END initialize_oks_hdr_tbl;
825:

Line 1062: RETURN okc_api.g_ret_sts_unexp_error;

1058: RETURN x_from_version;
1059: EXCEPTION
1060: WHEN OTHERS
1061: THEN
1062: RETURN okc_api.g_ret_sts_unexp_error;
1063: okc_api.set_message (g_app_name,
1064: g_unexpected_error,
1065: g_sqlcode_token,
1066: SQLCODE,

Line 1063: okc_api.set_message (g_app_name,

1059: EXCEPTION
1060: WHEN OTHERS
1061: THEN
1062: RETURN okc_api.g_ret_sts_unexp_error;
1063: okc_api.set_message (g_app_name,
1064: g_unexpected_error,
1065: g_sqlcode_token,
1066: SQLCODE,
1067: g_sqlerrm_token,

Line 1135: x_return_status := okc_api.g_ret_sts_success;

1131: l_jtf_note_id NUMBER;
1132: l_jtf_note_contexts_tab jtf_notes_pub.jtf_note_contexts_tbl_type;
1133:
1134: BEGIN
1135: x_return_status := okc_api.g_ret_sts_success;
1136: IF (fnd_log.level_event >= fnd_log.g_current_runtime_level)
1137: THEN
1138: fnd_log.STRING (fnd_log.level_event,
1139: g_module_current || '.create_csi_note',

Line 1193: IF NOT x_return_status = okc_api.g_ret_sts_success

1189: 'status = ( ' || x_return_status || ' )'
1190: );
1191: END IF;
1192:
1193: IF NOT x_return_status = okc_api.g_ret_sts_success
1194: THEN
1195: okc_api.set_message (g_app_name,
1196: 'OKS_CSI_NOTES_ERROR');
1197:

Line 1195: okc_api.set_message (g_app_name,

1191: END IF;
1192:
1193: IF NOT x_return_status = okc_api.g_ret_sts_success
1194: THEN
1195: okc_api.set_message (g_app_name,
1196: 'OKS_CSI_NOTES_ERROR');
1197:
1198: RAISE g_exception_halt_validation;
1199: END IF;

Line 1214: okc_api.set_message (g_app_name,

1210: THEN
1211: x_return_status := 'U';
1212: fnd_file.put_line(fnd_file.log,' Error while creating the csi note: '
1213: || SQLCODE||':'|| SQLERRM );
1214: okc_api.set_message (g_app_name,
1215: g_unexpected_error,
1216: g_sqlcode_token,
1217: SQLCODE,
1218: g_sqlerrm_token,

Line 1280: okc_api.set_message (g_app_name,

1276: THEN
1277: x_return_status := 'U';
1278: fnd_file.put_line(fnd_file.log,' Error while getting the notes details: '
1279: || SQLCODE||':'|| SQLERRM );
1280: okc_api.set_message (g_app_name,
1281: g_unexpected_error,
1282: g_sqlcode_token,
1283: SQLCODE,
1284: g_sqlerrm_token,

Line 1354: okc_api.set_message (g_app_name,

1350: THEN
1351:
1352: fnd_file.put_line(fnd_file.log,' Error while checking the related accounts : '
1353: || SQLCODE||':'|| SQLERRM );
1354: okc_api.set_message (g_app_name,
1355: g_unexpected_error,
1356: g_sqlcode_token,
1357: SQLCODE,
1358: g_sqlerrm_token,

Line 1432: x_return_status := okc_api.g_ret_sts_success;

1428: AND contract_number_modifier = p_contract_number_modifier;
1429:
1430: l_found BOOLEAN := FALSE;
1431: BEGIN
1432: x_return_status := okc_api.g_ret_sts_success;
1433:
1434: IF ( p_contract_number_modifier IS NOT NULL
1435: AND p_contract_number IS NOT NULL
1436: )

Line 1450: x_return_status := okc_api.g_ret_sts_error;

1446: END IF;
1447:
1448: IF (l_found)
1449: THEN
1450: x_return_status := okc_api.g_ret_sts_error;
1451: okc_api.set_message (g_app_name,
1452: 'OKS_CONTRACT_EXISTS',
1453: 'CONTRACT_NUMBER',
1454: p_contract_number,

Line 1451: okc_api.set_message (g_app_name,

1447:
1448: IF (l_found)
1449: THEN
1450: x_return_status := okc_api.g_ret_sts_error;
1451: okc_api.set_message (g_app_name,
1452: 'OKS_CONTRACT_EXISTS',
1453: 'CONTRACT_NUMBER',
1454: p_contract_number,
1455: 'CONTRACT_NUMBER_MODIFIER',

Line 1480: x_return_status := okc_api.g_ret_sts_success;

1476: WHERE ID = p_group_id
1477: AND public_yn = 'Y'
1478: OR user_id = fnd_global.user_id;
1479: BEGIN
1480: x_return_status := okc_api.g_ret_sts_success;
1481:
1482: IF ( p_group_id <> okc_api.g_miss_num
1483: OR p_group_id IS NOT NULL)
1484: THEN

Line 1482: IF ( p_group_id <> okc_api.g_miss_num

1478: OR user_id = fnd_global.user_id;
1479: BEGIN
1480: x_return_status := okc_api.g_ret_sts_success;
1481:
1482: IF ( p_group_id <> okc_api.g_miss_num
1483: OR p_group_id IS NOT NULL)
1484: THEN
1485: OPEN l_grpid_csr;
1486:

Line 1492: x_return_status := okc_api.g_ret_sts_error;

1488: INTO l_dummy_var;
1489:
1490: IF l_grpid_csr%NOTFOUND
1491: THEN
1492: x_return_status := okc_api.g_ret_sts_error;
1493: okc_api.set_message (g_app_name,
1494: 'OKS_INV_GROUP',
1495: 'GROUP_ID',
1496: p_group_id

Line 1493: okc_api.set_message (g_app_name,

1489:
1490: IF l_grpid_csr%NOTFOUND
1491: THEN
1492: x_return_status := okc_api.g_ret_sts_error;
1493: okc_api.set_message (g_app_name,
1494: 'OKS_INV_GROUP',
1495: 'GROUP_ID',
1496: p_group_id
1497: );

Line 1530: x_return_status := okc_api.g_ret_sts_success;

1526: WHERE party.party_id = acct.party_id
1527: AND acct.status = 'A')
1528: AND party.party_id = p_party_id;
1529: BEGIN
1530: x_return_status := okc_api.g_ret_sts_success;
1531:
1532: IF ( p_party_id = okc_api.g_miss_num
1533: OR p_party_id IS NULL)
1534: THEN

Line 1532: IF ( p_party_id = okc_api.g_miss_num

1528: AND party.party_id = p_party_id;
1529: BEGIN
1530: x_return_status := okc_api.g_ret_sts_success;
1531:
1532: IF ( p_party_id = okc_api.g_miss_num
1533: OR p_party_id IS NULL)
1534: THEN
1535: x_return_status := okc_api.g_ret_sts_error;
1536: okc_api.set_message (g_app_name, 'OKS_REQ_PARTY');

Line 1535: x_return_status := okc_api.g_ret_sts_error;

1531:
1532: IF ( p_party_id = okc_api.g_miss_num
1533: OR p_party_id IS NULL)
1534: THEN
1535: x_return_status := okc_api.g_ret_sts_error;
1536: okc_api.set_message (g_app_name, 'OKS_REQ_PARTY');
1537: ELSE
1538: OPEN l_party_csr;
1539:

Line 1536: okc_api.set_message (g_app_name, 'OKS_REQ_PARTY');

1532: IF ( p_party_id = okc_api.g_miss_num
1533: OR p_party_id IS NULL)
1534: THEN
1535: x_return_status := okc_api.g_ret_sts_error;
1536: okc_api.set_message (g_app_name, 'OKS_REQ_PARTY');
1537: ELSE
1538: OPEN l_party_csr;
1539:
1540: FETCH l_party_csr

Line 1545: x_return_status := okc_api.g_ret_sts_error;

1541: INTO l_dummy_var;
1542:
1543: IF l_party_csr%NOTFOUND
1544: THEN
1545: x_return_status := okc_api.g_ret_sts_error;
1546: okc_api.set_message (g_app_name,
1547: 'OKS_INV_PARTY',
1548: 'PARTY_ID',
1549: p_party_id

Line 1546: okc_api.set_message (g_app_name,

1542:
1543: IF l_party_csr%NOTFOUND
1544: THEN
1545: x_return_status := okc_api.g_ret_sts_error;
1546: okc_api.set_message (g_app_name,
1547: 'OKS_INV_PARTY',
1548: 'PARTY_ID',
1549: p_party_id
1550: );

Line 1593: x_return_status := okc_api.g_ret_sts_success;

1589: AND NVL (r.end_date, SYSDATE)
1590: AND r.status = 'A'
1591: AND r.party_id = p_contact_id;
1592: BEGIN
1593: x_return_status := okc_api.g_ret_sts_success;
1594:
1595: OPEN l_cust_ctc_csr;
1596: FETCH l_cust_ctc_csr INTO l_dummy_var;
1597:

Line 1600: x_return_status := okc_api.g_ret_sts_error;

1596: FETCH l_cust_ctc_csr INTO l_dummy_var;
1597:
1598: IF l_cust_ctc_csr%NOTFOUND
1599: THEN
1600: x_return_status := okc_api.g_ret_sts_error;
1601: okc_api.set_message (g_app_name,
1602: 'OKS_INV_CONTACT',
1603: 'CONTACT_ID',
1604: p_contact_id,

Line 1601: okc_api.set_message (g_app_name,

1597:
1598: IF l_cust_ctc_csr%NOTFOUND
1599: THEN
1600: x_return_status := okc_api.g_ret_sts_error;
1601: okc_api.set_message (g_app_name,
1602: 'OKS_INV_CONTACT',
1603: 'CONTACT_ID',
1604: p_contact_id,
1605: 'PARTY_ID',

Line 2025: l_return_status := okc_api.g_ret_sts_success;

2021:
2022: -- Main
2023: BEGIN
2024:
2025: l_return_status := okc_api.g_ret_sts_success;
2026: IF (fnd_log.level_event >= fnd_log.g_current_runtime_level)
2027: THEN
2028: fnd_log.STRING (fnd_log.level_event,
2029: g_module_current || 'oks_mass_update.creat_contract_header',

Line 2105: IF NOT l_return_status = okc_api.g_ret_sts_success THEN

2101: x_msg_data => x_msg_data
2102: );
2103:
2104:
2105: IF NOT l_return_status = okc_api.g_ret_sts_success THEN
2106:
2107: Raise G_EXCEPTION_HALT_VALIDATION;
2108: End if;
2109:

Line 2192: IF NOT l_return_status = okc_api.g_ret_sts_success THEN

2188: x_return_status => l_return_status,
2189: x_contract_number => l_chrv_tbl_in (i).contract_number
2190: );
2191:
2192: IF NOT l_return_status = okc_api.g_ret_sts_success THEN
2193: Raise G_EXCEPTION_HALT_VALIDATION;
2194: End if;
2195: IF (fnd_log.level_event >= fnd_log.g_current_runtime_level)
2196: THEN

Line 2582: IF (l_return_status <> OKC_API.G_RET_STS_SUCCESS) THEN

2578: x_msg_data => x_msg_data,
2579: x_return_status => l_return_status
2580: );
2581: fnd_file.put_line(fnd_file.log,'GET_JTF_RESOURCE ret status'||l_return_status);
2582: IF (l_return_status <> OKC_API.G_RET_STS_SUCCESS) THEN
2583: -- Setup error
2584: fnd_file.put_line(fnd_file.log,'SEND_NOTIFICATION');
2585:
2586: OKS_EXTWARPRGM_PVT.SEND_NOTIFICATION(null, hdr_id (i),'SER');

Line 2637: OKC_API.SET_MESSAGE(

2633: OPEN object_code_csr( fnd_profile.VALUE('OKS_VENDOR_CONTACT_ROLE' ));
2634: FETCH object_code_csr INTO l_temp;
2635: IF object_code_csr%NOTFOUND THEN
2636: CLOSE object_code_csr;
2637: OKC_API.SET_MESSAGE(
2638: g_app_name,
2639: g_unexpected_error,
2640: g_sqlcode_token,
2641: SQLCODE,

Line 2646: l_return_status := okc_api.g_ret_sts_error;

2642: g_sqlerrm_token,
2643: 'Wrong vendor contact role assigned'
2644: );
2645:
2646: l_return_status := okc_api.g_ret_sts_error;
2647: RAISE G_EXCEPTION_HALT_VALIDATION;
2648: END IF;
2649: CLOSE object_code_csr;
2650:

Line 2917: IF l_return_status <> okc_api.g_ret_sts_success

2913: 'okc_chr_pvt.insert_row_upg, status = ('
2914: || l_return_status || ')');
2915: END IF;
2916:
2917: IF l_return_status <> okc_api.g_ret_sts_success
2918: THEN
2919:
2920: RAISE g_exception_halt_validation;
2921: END IF;

Line 3000: IF l_return_status <> okc_api.g_ret_sts_success

2996: g_module_current || 'oks_mass_update.create_contract_header',
2997: 'okc_cpl_pvt.insert_row_upg, status = ('
2998: || l_return_status || ')');
2999: END IF;
3000: IF l_return_status <> okc_api.g_ret_sts_success
3001: THEN
3002:
3003: RAISE g_exception_halt_validation;
3004: END IF;

Line 3024: IF l_return_status <> okc_api.g_ret_sts_success

3020: g_module_current || 'oks_mass_update.create_contract_header',
3021: 'okc_ctc_pvt.insert_row_upg, status = ('
3022: || l_return_status || ')');
3023: END IF;
3024: IF l_return_status <> okc_api.g_ret_sts_success
3025: THEN
3026:
3027: RAISE g_exception_halt_validation;
3028: END IF;

Line 3048: IF x_return_status <> okc_api.g_ret_sts_success

3044: g_module_current || 'oks_mass_update.create_contract_header',
3045: 'okc_gve_pvt.insert_row_upg, status = ('
3046: || l_return_status || ')');
3047: END IF;
3048: IF x_return_status <> okc_api.g_ret_sts_success
3049: THEN
3050: RAISE g_exception_halt_validation;
3051: END IF;
3052: END IF;

Line 3071: IF l_return_status <> okc_api.g_ret_sts_success

3067: g_module_current || 'oks_mass_update.create_contract_header',
3068: 'okc_cps_pvt.insert_row_upg, status = ('
3069: || l_return_status || ')');
3070: END IF;
3071: IF l_return_status <> okc_api.g_ret_sts_success
3072: THEN
3073: RAISE g_exception_halt_validation;
3074: END IF;
3075: END IF;

Line 3094: IF l_return_status <> okc_api.g_ret_sts_success

3090: g_module_current || 'oks_mass_update.create_contract_header',
3091: 'okc_cgc_pvt.insert_row_upg, status = ('
3092: || l_return_status || ')');
3093: END IF;
3094: IF l_return_status <> okc_api.g_ret_sts_success
3095: THEN
3096:
3097: RAISE g_exception_halt_validation;
3098: END IF;

Line 3214: x_return_status := okc_api.g_ret_sts_unexp_error;

3210: || SQLCODE||':'|| SQLERRM );
3211: NULL;
3212: WHEN OTHERS
3213: THEN
3214: x_return_status := okc_api.g_ret_sts_unexp_error;
3215: fnd_file.put_line(fnd_file.log,' Error while creating the contract header : '
3216: || SQLCODE||':'|| SQLERRM );
3217: okc_api.set_message (g_app_name,
3218: g_unexpected_error,

Line 3217: okc_api.set_message (g_app_name,

3213: THEN
3214: x_return_status := okc_api.g_ret_sts_unexp_error;
3215: fnd_file.put_line(fnd_file.log,' Error while creating the contract header : '
3216: || SQLCODE||':'|| SQLERRM );
3217: okc_api.set_message (g_app_name,
3218: g_unexpected_error,
3219: g_sqlcode_token,
3220: SQLCODE,
3221: g_sqlerrm_token,

Line 3367: l_return_status := okc_api.g_ret_sts_success;

3363: l_inp_rec okc_inst_cnd_pub.instcnd_inp_rec;
3364:
3365: -- Main Begin
3366: BEGIN
3367: l_return_status := okc_api.g_ret_sts_success;
3368:
3369: l_Tlineno_new := 0;
3370: IF (fnd_log.level_event >= fnd_log.g_current_runtime_level)
3371: THEN

Line 3753: x_return_status := okc_api.g_ret_sts_unexp_error;

3749: || SQLCODE||':'|| SQLERRM );
3750: NULL;
3751: WHEN OTHERS
3752: THEN
3753: x_return_status := okc_api.g_ret_sts_unexp_error;
3754: fnd_file.put_line(fnd_file.log,' Error while creating the service lines : '
3755: || SQLCODE||':'|| SQLERRM );
3756: okc_api.set_message (g_app_name,
3757: g_unexpected_error,

Line 3756: okc_api.set_message (g_app_name,

3752: THEN
3753: x_return_status := okc_api.g_ret_sts_unexp_error;
3754: fnd_file.put_line(fnd_file.log,' Error while creating the service lines : '
3755: || SQLCODE||':'|| SQLERRM );
3756: okc_api.set_message (g_app_name,
3757: g_unexpected_error,
3758: g_sqlcode_token,
3759: SQLCODE,
3760: g_sqlerrm_token,

Line 3880: l_return_status := okc_api.g_ret_sts_success;

3876: l_msg_count NUMBER;
3877: l_msg_data VARCHAR2 (2000);
3878: l_return_status VARCHAR2 (1) := 'S';
3879: BEGIN
3880: l_return_status := okc_api.g_ret_sts_success;
3881:
3882: l_lineno_new := 0;
3883: IF (fnd_log.level_event >= fnd_log.g_current_runtime_level)
3884: THEN

Line 4186: x_return_status := okc_api.g_ret_sts_unexp_error;

4182: || SQLCODE||':'|| SQLERRM );
4183: NULL;
4184: WHEN OTHERS
4185: THEN
4186: x_return_status := okc_api.g_ret_sts_unexp_error;
4187: fnd_file.put_line(fnd_file.log,' Error while creating the sublines : '
4188: || SQLCODE||':'|| SQLERRM );
4189: okc_api.set_message (g_app_name,
4190: g_unexpected_error,

Line 4189: okc_api.set_message (g_app_name,

4185: THEN
4186: x_return_status := okc_api.g_ret_sts_unexp_error;
4187: fnd_file.put_line(fnd_file.log,' Error while creating the sublines : '
4188: || SQLCODE||':'|| SQLERRM );
4189: okc_api.set_message (g_app_name,
4190: g_unexpected_error,
4191: g_sqlcode_token,
4192: SQLCODE,
4193: g_sqlerrm_token,

Line 4223: l_return_status := okc_api.g_ret_sts_success;

4219: l_term_date Date;
4220: l_return_status Varchar2(1);
4221:
4222: Begin
4223: l_return_status := okc_api.g_ret_sts_success;
4224:
4225: l_chrv_tbl_in.DELETE;
4226:
4227: IF get_ste_code(p_Contract_Status) = 'ENTERED'

Line 4259: IF NOT l_return_status = okc_api.g_ret_sts_success

4255:
4256: fnd_file.put_line(fnd_file.log,'(OKS) -> Update contract Header status = ( '
4257: || l_return_status || ' )');
4258:
4259: IF NOT l_return_status = okc_api.g_ret_sts_success
4260: THEN
4261: RAISE g_exception_halt_validation;
4262: END IF;
4263:

Line 4291: p_restricted_update => okc_api.g_true,

4287:
4288: okc_contract_pub.update_contract_header
4289: (p_api_version => l_api_version,
4290: p_init_msg_list => l_init_msg_list,
4291: p_restricted_update => okc_api.g_true,
4292: x_return_status => l_return_status,
4293: x_msg_count => x_msg_count,
4294: x_msg_data => x_msg_data,
4295: p_chrv_tbl => l_chrv_tbl_in,

Line 4301: IF NOT l_return_status = okc_api.g_ret_sts_success

4297: );
4298: fnd_file.put_line(fnd_file.log,'(OKS) -> Update contract Header status = ( '
4299: || l_return_status || ' )');
4300:
4301: IF NOT l_return_status = okc_api.g_ret_sts_success
4302: THEN
4303: RAISE g_exception_halt_validation;
4304: END IF;
4305:

Line 4318: x_return_status := okc_api.g_ret_sts_unexp_error;

4314: || SQLCODE||':'|| SQLERRM );
4315: NULL;
4316: WHEN OTHERS
4317: THEN
4318: x_return_status := okc_api.g_ret_sts_unexp_error;
4319: fnd_file.put_line(fnd_file.log,' Error in Teminate_Cancel_Header: '
4320: || SQLCODE||':'|| SQLERRM );
4321: okc_api.set_message (g_app_name,
4322: g_unexpected_error,

Line 4321: okc_api.set_message (g_app_name,

4317: THEN
4318: x_return_status := okc_api.g_ret_sts_unexp_error;
4319: fnd_file.put_line(fnd_file.log,' Error in Teminate_Cancel_Header: '
4320: || SQLCODE||':'|| SQLERRM );
4321: okc_api.set_message (g_app_name,
4322: g_unexpected_error,
4323: g_sqlcode_token,
4324: SQLCODE,
4325: g_sqlerrm_token,

Line 4395: IF NOT l_return_status = OKC_API.G_RET_STS_SUCCESS Then

4391: p_date_cancelled => l_cancel_date,
4392: p_comments => NULL,
4393: p_validate_status => 'N') ;
4394:
4395: IF NOT l_return_status = OKC_API.G_RET_STS_SUCCESS Then
4396: Raise G_EXCEPTION_HALT_VALIDATION;
4397: End if;
4398:
4399: END IF;

Line 4427: p_restricted_update => okc_api.g_true,

4423:
4424: okc_contract_pub.update_contract_line
4425: (p_api_version => l_api_version,
4426: p_init_msg_list => l_init_msg_list,
4427: p_restricted_update => okc_api.g_true,
4428: x_return_status => l_return_status,
4429: x_msg_count => x_msg_count,
4430: x_msg_data => x_msg_data,
4431: p_clev_tbl => l_clev_tbl_in,

Line 4437: IF NOT l_return_status = okc_api.g_ret_sts_success

4433: );
4434: fnd_file.put_line(fnd_file.log,'(OKS) -> Update contract Line status = ( '
4435: || l_return_status ||' )' );
4436:
4437: IF NOT l_return_status = okc_api.g_ret_sts_success
4438: THEN
4439:
4440: RAISE g_exception_halt_validation;
4441: END IF;

Line 4456: x_return_status := okc_api.g_ret_sts_unexp_error;

4452: || SQLCODE||':'|| SQLERRM );
4453: NULL;
4454: WHEN OTHERS
4455: THEN
4456: x_return_status := okc_api.g_ret_sts_unexp_error;
4457: fnd_file.put_line(fnd_file.log,' Error in Teminate_Cancel_Topline: '
4458: || SQLCODE||':'|| SQLERRM );
4459: okc_api.set_message (g_app_name,
4460: g_unexpected_error,

Line 4459: okc_api.set_message (g_app_name,

4455: THEN
4456: x_return_status := okc_api.g_ret_sts_unexp_error;
4457: fnd_file.put_line(fnd_file.log,' Error in Teminate_Cancel_Topline: '
4458: || SQLCODE||':'|| SQLERRM );
4459: okc_api.set_message (g_app_name,
4460: g_unexpected_error,
4461: g_sqlcode_token,
4462: SQLCODE,
4463: g_sqlerrm_token,

Line 4678: p_init_msg_list => okc_api.g_false,

4674:
4675:
4676: Oks_coverages_pub.create_adjusted_coverage(
4677: p_api_version => 1.0,
4678: p_init_msg_list => okc_api.g_false,
4679: x_return_status => l_return_status,
4680: x_msg_count => x_msg_count,
4681: x_msg_data => x_msg_data,
4682: p_source_contract_line_id => old_srvline_id (Line_ctr),

Line 4696: IF NOT l_return_status = okc_api.g_ret_sts_success

4692: fnd_log.STRING (fnd_log.level_event,
4693: g_module_current || 'oks_mass_update.create_contract_Line',
4694: 'create coverage status = ('|| x_return_status || ')');
4695: END IF;
4696: IF NOT l_return_status = okc_api.g_ret_sts_success
4697: THEN
4698:
4699: RAISE g_exception_halt_validation;
4700: Else

Line 4710: p_init_msg_list => okc_api.g_false,

4706: END IF;
4707:
4708: oks_coverages_pvt.create_k_coverage_ext
4709: (p_api_version => 1.0,
4710: p_init_msg_list => okc_api.g_false,
4711: p_src_line_id => old_srvline_id (Line_ctr),
4712: p_tgt_line_id => srvline_id (Line_ctr),
4713: x_return_status => l_return_status,
4714: x_msg_count => x_msg_count,

Line 4727: IF NOT l_return_status = okc_api.g_ret_sts_success

4723: g_module_current || 'oks_mass_update.create_contract_Line',
4724: 'create coverage extension status = ('|| x_return_status || ')');
4725: END IF;
4726:
4727: IF NOT l_return_status = okc_api.g_ret_sts_success
4728: THEN
4729:
4730: RAISE g_exception_halt_validation;
4731: END IF;

Line 4747: p_init_msg_list => okc_api.g_false,

4743: THEN
4744:
4745: cs_counters_pub.autoinstantiate_counters
4746: (p_api_version => 1.0,
4747: p_init_msg_list => okc_api.g_false,
4748: p_commit => 'F',
4749: x_return_status => l_return_status,
4750: x_msg_count => x_msg_count,
4751: x_msg_data => x_msg_data,

Line 4770: IF NOT l_return_status = okc_api.g_ret_sts_success

4766: END IF;
4767:
4768: END IF;
4769:
4770: IF NOT l_return_status = okc_api.g_ret_sts_success
4771: THEN
4772: okc_api.set_message (g_app_name,
4773: g_required_value,
4774: g_col_name_token,

Line 4772: okc_api.set_message (g_app_name,

4768: END IF;
4769:
4770: IF NOT l_return_status = okc_api.g_ret_sts_success
4771: THEN
4772: okc_api.set_message (g_app_name,
4773: g_required_value,
4774: g_col_name_token,
4775: 'Counter Instantiate (LINE)'
4776: );

Line 4806: IF NOT l_return_status = okc_api.g_ret_sts_success

4802: g_module_current || 'oks_mass_update.create_contract_Line',
4803: 'create events status = ('|| l_return_status || ')');
4804: END IF;
4805:
4806: IF NOT l_return_status = okc_api.g_ret_sts_success
4807: THEN
4808: okc_api.set_message (g_app_name,
4809: g_required_value,
4810: g_col_name_token,

Line 4808: okc_api.set_message (g_app_name,

4804: END IF;
4805:
4806: IF NOT l_return_status = okc_api.g_ret_sts_success
4807: THEN
4808: okc_api.set_message (g_app_name,
4809: g_required_value,
4810: g_col_name_token,
4811: 'Event Instantiate (LINE)'
4812: );

Line 4970: p_init_msg_list => OKC_API.G_TRUE,

4966: G_Rail_rec.Amount := null;
4967: OKS_TAX_UTIL_PVT.Get_Tax
4968: (
4969: p_api_version => 1.0,
4970: p_init_msg_list => OKC_API.G_TRUE,
4971: p_chr_id => contract_id(k),
4972: p_cle_id => subline_id(subline_ctr),
4973: px_rail_rec => G_RAIL_REC,
4974: x_msg_count => x_msg_count,

Line 5027: p_init_msg_list => okc_api.g_false,

5023: || contract_id (k)|| ' ) qcl id = ( '|| qcl_id(k) || ' )');
5024:
5025: okc_qa_check_pub.execute_qa_check_list
5026: (p_api_version => 1.0,
5027: p_init_msg_list => okc_api.g_false,
5028: x_return_status => l_return_status,
5029: x_msg_count => x_msg_count,
5030: x_msg_data => x_msg_data,
5031: p_qcl_id => qcl_id(k),

Line 5039: IF l_return_status <> okc_api.g_ret_sts_success

5035:
5036: fnd_file.put_line(fnd_file.log,'(OKS) -> Qa check status = ( '
5037: || l_return_status || ' ) qa message count = ( ' || l_msg_tbl.COUNT || ' )');
5038:
5039: IF l_return_status <> okc_api.g_ret_sts_success
5040: THEN
5041: x_return_status := l_return_status;
5042: RAISE g_exception_halt_validation;
5043: END IF;

Line 5108: IF l_return_status <> OKC_API.G_RET_STS_SUCCESS THEN

5104: /*update status in okc_contacts table*/
5105: OKC_CTC_PVT.update_contact_stecode(p_chr_id => qa_contract_id,
5106: x_return_status=>l_return_status);
5107:
5108: IF l_return_status <> OKC_API.G_RET_STS_SUCCESS THEN
5109: RAISE g_exception_halt_validation;
5110: END IF;
5111:
5112:

Line 5143: p_init_msg_list => okc_api.g_false,

5139:
5140:
5141: oks_wf_k_process_pvt.launch_k_process_wf
5142: (p_api_version => 1.0,
5143: p_init_msg_list => okc_api.g_false,
5144: p_wf_attributes => l_wf_attributes,
5145: x_return_status => l_return_status,
5146: x_msg_count => x_msg_count,
5147: x_msg_data => x_msg_data

Line 5152: IF l_return_status <> okc_api.g_ret_sts_success

5148: );
5149: fnd_file.put_line(fnd_file.log,'(OKS) -> Lauch workflow process status = ( '
5150: || l_return_status|| ' )');
5151:
5152: IF l_return_status <> okc_api.g_ret_sts_success
5153: THEN
5154: x_return_status := l_return_status;
5155: RAISE g_exception_halt_validation;
5156: END IF;

Line 5178: p_init_msg_list => okc_api.g_false,

5174:
5175:
5176: oks_wf_k_process_pvt.launch_k_process_wf
5177: (p_api_version => 1.0,
5178: p_init_msg_list => okc_api.g_false,
5179: p_wf_attributes => l_wf_attributes,
5180: x_return_status => l_return_status,
5181: x_msg_count => x_msg_count,
5182: x_msg_data => x_msg_data

Line 5188: IF l_return_status <> okc_api.g_ret_sts_success

5184:
5185: fnd_file.put_line(fnd_file.log,'(OKS) -> Lauch workflow process status = ( '
5186: || k||' )'||l_return_status);
5187:
5188: IF l_return_status <> okc_api.g_ret_sts_success
5189: THEN
5190: x_return_status := l_return_status;
5191: RAISE g_exception_halt_validation;
5192: END IF;

Line 5246: IF NOT l_return_status = okc_api.g_ret_sts_success

5242: x_msg_count => x_msg_count,
5243: x_msg_data => x_msg_data
5244: );
5245: fnd_file.put_line(fnd_file.log,'(OKS) -> Create IB Note status = ( ' || l_return_status || ' )');
5246: IF NOT l_return_status = okc_api.g_ret_sts_success
5247: THEN
5248: x_return_status := l_return_status;
5249:
5250: RAISE g_exception_halt_validation;

Line 5270: IF NOT l_return_status = okc_api.g_ret_sts_success

5266: fnd_file.put_line(fnd_file.log,'(OKS) -> For Contract = ( '||old_contract_id(k)
5267: ||' ) Get Notes details Status = ( ' || l_return_status || ' ) Number of Notes = ( '
5268: ||l_notes_tbl.COUNT || ' )');
5269:
5270: IF NOT l_return_status = okc_api.g_ret_sts_success
5271: THEN
5272: x_return_status := l_return_status;
5273: RAISE g_exception_halt_validation;
5274: END IF;

Line 5327: IF NOT l_return_status = okc_api.g_ret_sts_success

5323:
5324: fnd_file.put_line(fnd_file.log,'(OKS) -> Create Notes ( '||m ||' )'|| 'Status = ( '
5325: || l_return_status || ' )');
5326:
5327: IF NOT l_return_status = okc_api.g_ret_sts_success
5328: THEN
5329: x_return_status := l_return_status;
5330: RAISE g_exception_halt_validation;
5331: END IF;

Line 5361: x_return_status := okc_api.g_ret_sts_unexp_error;

5357: || SQLCODE||':'|| SQLERRM );
5358: NULL;
5359: WHEN OTHERS
5360: THEN
5361: x_return_status := okc_api.g_ret_sts_unexp_error;
5362: fnd_file.put_line(fnd_file.log,' Error while creating the cov,billing schd, tax : '
5363: || SQLCODE||':'|| SQLERRM );
5364: okc_api.set_message (g_app_name,
5365: g_unexpected_error,

Line 5364: okc_api.set_message (g_app_name,

5360: THEN
5361: x_return_status := okc_api.g_ret_sts_unexp_error;
5362: fnd_file.put_line(fnd_file.log,' Error while creating the cov,billing schd, tax : '
5363: || SQLCODE||':'|| SQLERRM );
5364: okc_api.set_message (g_app_name,
5365: g_unexpected_error,
5366: g_sqlcode_token,
5367: SQLCODE,
5368: g_sqlerrm_token,

Line 5433: If not l_return_status = OKC_API.G_RET_STS_SUCCESS Then

5429: p_date_cancelled => p_cancellation_date,
5430: p_comments => NULL,
5431: p_validate_status => 'N') ;
5432:
5433: If not l_return_status = OKC_API.G_RET_STS_SUCCESS Then
5434: x_return_status := l_return_status;
5435: Raise G_EXCEPTION_HALT_VALIDATION;
5436: End if;
5437:

Line 5458: IF NOT l_return_status = okc_api.g_ret_sts_success

5454: P_Term_Cancel_source => P_termination_source,
5455: x_return_status => l_return_status
5456: );
5457:
5458: IF NOT l_return_status = okc_api.g_ret_sts_success
5459: THEN
5460: x_return_status := l_return_status;
5461: RAISE g_exception_halt_validation;
5462: END IF;

Line 5468: x_return_status := okc_api.g_ret_sts_error;

5464: x_return_status := l_return_status;
5465: EXCEPTION
5466: WHEN g_exception_halt_validation
5467: THEN
5468: x_return_status := okc_api.g_ret_sts_error;
5469: NULL;
5470: WHEN OTHERS
5471: THEN
5472: x_return_status := okc_api.g_ret_sts_unexp_error;

Line 5472: x_return_status := okc_api.g_ret_sts_unexp_error;

5468: x_return_status := okc_api.g_ret_sts_error;
5469: NULL;
5470: WHEN OTHERS
5471: THEN
5472: x_return_status := okc_api.g_ret_sts_unexp_error;
5473: okc_api.set_message (g_app_name,
5474: g_unexpected_error,
5475: g_sqlcode_token,
5476: SQLCODE,

Line 5473: okc_api.set_message (g_app_name,

5469: NULL;
5470: WHEN OTHERS
5471: THEN
5472: x_return_status := okc_api.g_ret_sts_unexp_error;
5473: okc_api.set_message (g_app_name,
5474: g_unexpected_error,
5475: g_sqlcode_token,
5476: SQLCODE,
5477: g_sqlerrm_token,

Line 5656: okc_api.set_message (g_app_name,

5652: WHEN OTHERS
5653: THEN
5654: fnd_file.put_line(fnd_file.log,' Error while getting the object line id: '
5655: || SQLCODE||':'|| SQLERRM );
5656: okc_api.set_message (g_app_name,
5657: g_unexpected_error,
5658: g_sqlcode_token,
5659: SQLCODE,
5660: g_sqlerrm_token,

Line 5825: IF NOT l_return_status = okc_api.g_ret_sts_success

5821:
5822: fnd_file.put_line(fnd_file.log,'(OKS) -> Create contract header, status = ( '
5823: || l_return_status || ' )');
5824:
5825: IF NOT l_return_status = okc_api.g_ret_sts_success
5826: THEN
5827: x_return_status := l_return_status;
5828: RAISE g_exception_halt_validation;
5829: END IF;

Line 5842: IF NOT l_return_status = okc_api.g_ret_sts_success

5838:
5839: fnd_file.put_line(fnd_file.log,'(OKS) -> Create contract Line, status = ( '
5840: || l_return_status || ' )');
5841:
5842: IF NOT l_return_status = okc_api.g_ret_sts_success
5843: THEN
5844: x_return_status := l_return_status;
5845: RAISE g_exception_halt_validation;
5846: END IF;

Line 5859: IF NOT l_return_status = okc_api.g_ret_sts_success

5855:
5856: fnd_file.put_line(fnd_file.log,'(OKS) -> Create contract subline, status = ( '
5857: || l_return_status || ' )');
5858:
5859: IF NOT l_return_status = okc_api.g_ret_sts_success
5860: THEN
5861: x_return_status := l_return_status;
5862: RAISE g_exception_halt_validation;
5863: END IF;

Line 5886: IF NOT l_return_status = okc_api.g_ret_sts_success

5882:
5883:
5884: fnd_file.put_line(fnd_file.log,'(OKS) -> CREATE_COV_BILLSCHD, status = ( '
5885: || l_return_status || ' )');
5886: IF NOT l_return_status = okc_api.g_ret_sts_success
5887: THEN
5888: x_return_status := l_return_status;
5889: RAISE g_exception_halt_validation;
5890: END IF;

Line 5902: x_return_status := okc_api.g_ret_sts_unexp_error;

5898: || SQLCODE||':'|| SQLERRM );
5899: NULL;
5900: WHEN OTHERS
5901: THEN
5902: x_return_status := okc_api.g_ret_sts_unexp_error;
5903: fnd_file.put_line(fnd_file.log,' Error while creating the contract : '
5904: || SQLCODE||':'|| SQLERRM );
5905: okc_api.set_message (g_app_name,
5906: g_unexpected_error,

Line 5905: okc_api.set_message (g_app_name,

5901: THEN
5902: x_return_status := okc_api.g_ret_sts_unexp_error;
5903: fnd_file.put_line(fnd_file.log,' Error while creating the contract : '
5904: || SQLCODE||':'|| SQLERRM );
5905: okc_api.set_message (g_app_name,
5906: g_unexpected_error,
5907: g_sqlcode_token,
5908: SQLCODE,
5909: g_sqlerrm_token,

Line 6055: x_return_status := okc_api.g_ret_sts_unexp_error;

6051: || SQLCODE||':'|| SQLERRM );
6052: NULL;
6053: WHEN OTHERS
6054: THEN
6055: x_return_status := okc_api.g_ret_sts_unexp_error;
6056: fnd_file.put_line(fnd_file.log,' Error while terminating/Canceling line/hdr: '
6057: || SQLCODE||':'|| SQLERRM );
6058: okc_api.set_message (g_app_name,
6059: g_unexpected_error,

Line 6058: okc_api.set_message (g_app_name,

6054: THEN
6055: x_return_status := okc_api.g_ret_sts_unexp_error;
6056: fnd_file.put_line(fnd_file.log,' Error while terminating/Canceling line/hdr: '
6057: || SQLCODE||':'|| SQLERRM );
6058: okc_api.set_message (g_app_name,
6059: g_unexpected_error,
6060: g_sqlcode_token,
6061: SQLCODE,
6062: g_sqlerrm_token,

Line 6857: Okc_api.set_message

6853:
6854: fnd_file.put_line(fnd_file.log,'(OKS) -> Forms Batch Rules status = ( '||l_return_status||' )');
6855: IF l_return_status <> 'S'
6856: THEN
6857: Okc_api.set_message
6858: (g_app_name,
6859: 'OKS_BATCH_ERROR'
6860: );
6861:

Line 6878: Okc_api.set_message

6874:
6875: IF get_batch_rules_csr%NOTFOUND
6876: THEN
6877:
6878: Okc_api.set_message
6879: (g_app_name,
6880: 'OKS_NO_BATCH_RULES_EXIST' ,
6881: 'BATCHID',
6882: P_batch_id

Line 6903: Okc_api.set_message

6899: FETCH get_batch_rules_trm_csr INTO batch_rules_trm_rec;
6900:
6901: IF get_batch_rules_trm_csr%NOTFOUND
6902: THEN
6903: Okc_api.set_message
6904: (g_app_name,
6905: 'OKS_NO_BATCH_RULES_EXIST',
6906: 'BATCHID',
6907: P_batch_id

Line 6938: okc_api.set_message

6934:
6935: IF P_new_acct_id IS NULL
6936: THEN
6937: fnd_file.put_line(fnd_file.log,'(OKS) -> New Account id is not passed to Contracts.');
6938: okc_api.set_message
6939: (
6940: g_app_name,
6941: 'OKS_NULL_ACCOUNT_ID',
6942: 'BATCHID',

Line 7019: OKC_API.SET_MESSAGE(

7015: fnd_log.string(FND_LOG.LEVEL_ERROR,G_MODULE_CURRENT||'.oks_mass_update.Update_contracts',
7016: ' Contract '||contract_number(i) ||' in QA_HOLD status' );
7017: END IF;
7018:
7019: OKC_API.SET_MESSAGE(
7020: g_app_name,
7021: 'OKS_CONTRACT_HOLD',
7022: 'CONTRACTNUMBER',
7023: CONTRACT_NUMBER(i)||' '||CONTRACT_NUMBER_MODIFIER(i)

Line 7031: l_return_status := OKC_API.G_RET_STS_ERROR;

7027: END LOOP;
7028:
7029: IF l_found
7030: THEN
7031: l_return_status := OKC_API.G_RET_STS_ERROR;
7032: RAISE G_EXCEPTION_HALT_VALIDATION;
7033: END IF;
7034: FORALL i IN contract_id.FIRST .. contract_id.LAST
7035: INSERT INTO oks_instance_k_dtls_temp

Line 7132: IF NOT l_return_status = okc_api.g_ret_sts_success

7128: END IF;
7129:
7130: fnd_file.put_line(fnd_file.log,'(OKS) -> Terminate_subline status = ( '|| l_return_status|| ' )');
7131:
7132: IF NOT l_return_status = okc_api.g_ret_sts_success
7133: THEN
7134: x_return_status := l_return_status;
7135: OKC_API.SET_MESSAGE
7136: (

Line 7135: OKC_API.SET_MESSAGE

7131:
7132: IF NOT l_return_status = okc_api.g_ret_sts_success
7133: THEN
7134: x_return_status := l_return_status;
7135: OKC_API.SET_MESSAGE
7136: (
7137: g_app_name,
7138: 'OKS_TERMINATE_ERROR',
7139: 'CONTRACTNUMBER',

Line 7163: IF NOT l_return_status = okc_api.g_ret_sts_success

7159:
7160:
7161: fnd_file.put_line(fnd_file.log,'(OKS) -> Terminate/cancel Line/Hdr status = ( '|| l_return_status|| ' )');
7162:
7163: IF NOT l_return_status = okc_api.g_ret_sts_success
7164: THEN
7165: x_return_status := l_return_status;
7166: OKC_API.SET_MESSAGE
7167: (

Line 7166: OKC_API.SET_MESSAGE

7162:
7163: IF NOT l_return_status = okc_api.g_ret_sts_success
7164: THEN
7165: x_return_status := l_return_status;
7166: OKC_API.SET_MESSAGE
7167: (
7168: g_app_name,
7169: 'OKS_TERMINATE_CANCEL_ERROR'
7170: );

Line 7374: OKC_API.SET_MESSAGE(

7370: ' Contract '||contract_number(i) ||' in QA_HOLD status' );
7371: END IF;
7372:
7373:
7374: OKC_API.SET_MESSAGE(
7375: g_app_name,
7376: 'OKS_CONTRACT_HOLD',
7377: 'CONTRACTNUMBER',
7378: CONTRACT_NUMBER(i)||' '||CONTRACT_NUMBER_MODIFIER(i)

Line 7386: l_return_status := OKC_API.G_RET_STS_ERROR;

7382: END LOOP;
7383:
7384: IF l_found
7385: THEN
7386: l_return_status := OKC_API.G_RET_STS_ERROR;
7387: RAISE G_EXCEPTION_HALT_VALIDATION;
7388: END IF;
7389:
7390: Delete Oks_Instance_k_dtls_temp where parent_id = p_batch_id;

Line 7500: IF NOT l_return_status = okc_api.g_ret_sts_success

7496: g_module_current || 'oks_mass_update.Update_contracts',
7497: 'Terminate_subline status = ( '|| l_return_status);
7498: END IF;
7499:
7500: IF NOT l_return_status = okc_api.g_ret_sts_success
7501: THEN
7502: x_return_status := l_return_status;
7503: OKC_API.SET_MESSAGE
7504: (

Line 7503: OKC_API.SET_MESSAGE

7499:
7500: IF NOT l_return_status = okc_api.g_ret_sts_success
7501: THEN
7502: x_return_status := l_return_status;
7503: OKC_API.SET_MESSAGE
7504: (
7505: g_app_name,
7506: 'OKS_TERMINATE_ERROR',
7507: 'CONTRACTNUMBER',

Line 7540: IF NOT l_return_status = okc_api.g_ret_sts_success

7536: END IF;
7537:
7538: fnd_file.put_line(fnd_file.log,'(OKS) -> Create contracts Status = ( '|| l_return_status|| ' )');
7539:
7540: IF NOT l_return_status = okc_api.g_ret_sts_success
7541: THEN
7542: x_return_status := l_return_status;
7543:
7544: RAISE g_exception_halt_validation;

Line 7582: IF NOT l_return_status = okc_api.g_ret_sts_success

7578: X_msg_data => x_msg_data);
7579:
7580: fnd_file.put_line(fnd_file.log,'(OKS) -> Terminate/cancel Line/Hdr status = ( '|| l_return_status|| ' )');
7581:
7582: IF NOT l_return_status = okc_api.g_ret_sts_success
7583: THEN
7584: x_return_status := l_return_status;
7585: OKC_API.SET_MESSAGE
7586: (

Line 7585: OKC_API.SET_MESSAGE

7581:
7582: IF NOT l_return_status = okc_api.g_ret_sts_success
7583: THEN
7584: x_return_status := l_return_status;
7585: OKC_API.SET_MESSAGE
7586: (
7587: g_app_name,
7588: 'OKS_TERMINATE_CANCEL_ERROR'
7589: );

Line 7625: IF NOT l_return_status = okc_api.g_ret_sts_success

7621:
7622: fnd_file.put_line(fnd_file.log,'(OKS) -> Create transfer transaction source ( '
7623: ||i||' )' || 'status = ( ' || l_return_status ||' )');
7624:
7625: IF NOT l_return_status = okc_api.g_ret_sts_success
7626: THEN
7627: x_return_status := l_return_status;
7628: RAISE g_exception_halt_validation;
7629: END IF;

Line 7670: IF NOT l_return_status = okc_api.g_ret_sts_success

7666:
7667: fnd_file.put_line(fnd_file.log,'(OKS) -> Create renewal transaction source ( '
7668: ||i||' )' || 'status = ( '|| l_return_status || ' )');
7669:
7670: IF NOT l_return_status = okc_api.g_ret_sts_success
7671: THEN
7672: x_return_status := l_return_status;
7673:
7674: RAISE g_exception_halt_validation;

Line 7941: l_return_status := OKC_API.G_RET_STS_SUCCESS;

7937:
7938: -- General Batch
7939: IF p_batch_type in ('GEN','MOVE') --'CSI_MU_GENERAL'
7940: THEN
7941: l_return_status := OKC_API.G_RET_STS_SUCCESS;
7942: fnd_file.put_line(fnd_file.log,'(OKS) -> General Batch Processing');
7943:
7944: OPEN get_k_for_idc_csr;
7945:

Line 8002: l_return_status := OKC_API.G_RET_STS_WARNING;

7998: FOR i IN 1..subline_id.count
7999: LOOP
8000: IF idc_date(i) IS NULL
8001: THEN
8002: l_return_status := OKC_API.G_RET_STS_WARNING;
8003: IF FND_LOG.LEVEL_ERROR >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
8004: fnd_log.string(FND_LOG.LEVEL_ERROR,G_MODULE_CURRENT||'.IB_INTERFACE',
8005: 'Installation date changed to null ' );
8006: End If;

Line 8007: OKC_API.set_message(G_APP_NAME,'OKS_NULL_INSTALLATION_DATE');

8003: IF FND_LOG.LEVEL_ERROR >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
8004: fnd_log.string(FND_LOG.LEVEL_ERROR,G_MODULE_CURRENT||'.IB_INTERFACE',
8005: 'Installation date changed to null ' );
8006: End If;
8007: OKC_API.set_message(G_APP_NAME,'OKS_NULL_INSTALLATION_DATE');
8008: Raise G_EXCEPTION_HALT_VALIDATION;
8009:
8010: END IF;
8011: If sr_date(i) Is Not Null Then

Line 8015: l_Warn_return_status := OKC_API.G_RET_STS_WARNING;

8011: If sr_date(i) Is Not Null Then
8012: IF (trunc(sr_date(i)) <= trunc(idc_date(i))
8013: OR TRUNC(sr_date(i)) >= TRUNC(new_edt(i)))
8014: THEN
8015: l_Warn_return_status := OKC_API.G_RET_STS_WARNING;
8016: OKC_API.set_message(G_APP_NAME,'OKS_SR_EXISTS_FOR_CONTRACT'
8017: ,'CONTRACTNUMBER',COntractnumber_modifier(i)
8018: ,'CONTRACTLINE',line_number(i)
8019: ,'INSTANCE',custprod_id (i)

Line 8016: OKC_API.set_message(G_APP_NAME,'OKS_SR_EXISTS_FOR_CONTRACT'

8012: IF (trunc(sr_date(i)) <= trunc(idc_date(i))
8013: OR TRUNC(sr_date(i)) >= TRUNC(new_edt(i)))
8014: THEN
8015: l_Warn_return_status := OKC_API.G_RET_STS_WARNING;
8016: OKC_API.set_message(G_APP_NAME,'OKS_SR_EXISTS_FOR_CONTRACT'
8017: ,'CONTRACTNUMBER',COntractnumber_modifier(i)
8018: ,'CONTRACTLINE',line_number(i)
8019: ,'INSTANCE',custprod_id (i)
8020: );

Line 8186: OKC_API.SET_MESSAGE(

8182:
8183:
8184: x_return_status := l_return_status;
8185:
8186: OKC_API.SET_MESSAGE(
8187: g_app_name,
8188: g_required_value,
8189: g_col_name_token,
8190: 'Adjust PM Program Schedule(SUB LINE)'

Line 8406: OKC_API.SET_MESSAGE(

8402: fnd_log.string(FND_LOG.LEVEL_ERROR,G_MODULE_CURRENT||'.oks_mass_update.Update_contracts',
8403: ' Contract '||contract_number(i) ||' in QA_HOLD status' );
8404: END IF;
8405:
8406: OKC_API.SET_MESSAGE(
8407: g_app_name,
8408: 'OKS_CONTRACT_HOLD',
8409: 'CONTRACTNUMBER',
8410: CONTRACT_NUMBER(i)||' '||CONTRACT_NUMBER_MODIFIER(i)

Line 8418: l_return_status := OKC_API.G_RET_STS_ERROR;

8414: END LOOP;
8415:
8416: IF l_found
8417: THEN
8418: l_return_status := OKC_API.G_RET_STS_ERROR;
8419: RAISE G_EXCEPTION_HALT_VALIDATION;
8420: END IF;
8421:
8422:

Line 8496: IF NOT l_return_status = okc_api.g_ret_sts_success

8492: );
8493:
8494: fnd_file.put_line(fnd_file.log,'(OKS) -> Terminate_subline status = ( '|| l_return_status|| ' )');
8495:
8496: IF NOT l_return_status = okc_api.g_ret_sts_success
8497: THEN
8498: x_return_status := l_return_status;
8499: OKC_API.SET_MESSAGE
8500: (

Line 8499: OKC_API.SET_MESSAGE

8495:
8496: IF NOT l_return_status = okc_api.g_ret_sts_success
8497: THEN
8498: x_return_status := l_return_status;
8499: OKC_API.SET_MESSAGE
8500: (
8501: g_app_name,
8502: 'OKS_TERMINATE_ERROR',
8503: 'CONTRACTNUMBER',

Line 8524: IF NOT l_return_status = okc_api.g_ret_sts_success

8520: X_msg_data => x_msg_data);
8521:
8522: fnd_file.put_line(fnd_file.log,'(OKS) -> Terminate/cancel Line/Hdr status = ( '|| l_return_status|| ' )');
8523:
8524: IF NOT l_return_status = okc_api.g_ret_sts_success
8525: THEN
8526: x_return_status := l_return_status;
8527: OKC_API.SET_MESSAGE
8528: (

Line 8527: OKC_API.SET_MESSAGE

8523:
8524: IF NOT l_return_status = okc_api.g_ret_sts_success
8525: THEN
8526: x_return_status := l_return_status;
8527: OKC_API.SET_MESSAGE
8528: (
8529: g_app_name,
8530: 'OKS_TERMINATE_CANCEL_ERROR'
8531: );

Line 8680: x_return_status := okc_api.g_ret_sts_error;

8676: End If;
8677: EXCEPTION
8678: WHEN g_exception_halt_validation
8679: THEN
8680: x_return_status := okc_api.g_ret_sts_error;
8681: fnd_file.put_line(fnd_file.log,' Error while updating the contract ' );
8682: FND_MSG_PUB.Count_And_Get
8683: (
8684: p_count => x_msg_count,

Line 8691: x_return_status := okc_api.g_ret_sts_unexp_error;

8687:
8688: NULL;
8689: WHEN OTHERS
8690: THEN
8691: x_return_status := okc_api.g_ret_sts_unexp_error;
8692: fnd_file.put_line(fnd_file.log,' Error while updating the contract : '
8693: || SQLCODE||':'|| SQLERRM );
8694: okc_api.set_message (g_app_name,
8695: g_unexpected_error,

Line 8694: okc_api.set_message (g_app_name,

8690: THEN
8691: x_return_status := okc_api.g_ret_sts_unexp_error;
8692: fnd_file.put_line(fnd_file.log,' Error while updating the contract : '
8693: || SQLCODE||':'|| SQLERRM );
8694: okc_api.set_message (g_app_name,
8695: g_unexpected_error,
8696: g_sqlcode_token,
8697: SQLCODE,
8698: g_sqlerrm_token,