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: END initialize_oks_hdr_tbl;

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: END initialize_oks_hdr_tbl;
821:

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: END initialize_oks_hdr_tbl;
821:
822: ----------* Function check_strmlvl_exists *---------

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: END initialize_oks_hdr_tbl;
821:
822: ----------* Function check_strmlvl_exists *---------
823: -- function to check if billing schedule exists for a

Line 1058: RETURN okc_api.g_ret_sts_unexp_error;

1054: RETURN x_from_version;
1055: EXCEPTION
1056: WHEN OTHERS
1057: THEN
1058: RETURN okc_api.g_ret_sts_unexp_error;
1059: okc_api.set_message (g_app_name,
1060: g_unexpected_error,
1061: g_sqlcode_token,
1062: SQLCODE,

Line 1059: okc_api.set_message (g_app_name,

1055: EXCEPTION
1056: WHEN OTHERS
1057: THEN
1058: RETURN okc_api.g_ret_sts_unexp_error;
1059: okc_api.set_message (g_app_name,
1060: g_unexpected_error,
1061: g_sqlcode_token,
1062: SQLCODE,
1063: g_sqlerrm_token,

Line 1131: x_return_status := okc_api.g_ret_sts_success;

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

Line 1189: IF NOT x_return_status = okc_api.g_ret_sts_success

1185: 'status = ( ' || x_return_status || ' )'
1186: );
1187: END IF;
1188:
1189: IF NOT x_return_status = okc_api.g_ret_sts_success
1190: THEN
1191: okc_api.set_message (g_app_name,
1192: 'OKS_CSI_NOTES_ERROR');
1193:

Line 1191: okc_api.set_message (g_app_name,

1187: END IF;
1188:
1189: IF NOT x_return_status = okc_api.g_ret_sts_success
1190: THEN
1191: okc_api.set_message (g_app_name,
1192: 'OKS_CSI_NOTES_ERROR');
1193:
1194: RAISE g_exception_halt_validation;
1195: END IF;

Line 1210: okc_api.set_message (g_app_name,

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

Line 1276: okc_api.set_message (g_app_name,

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

Line 1350: okc_api.set_message (g_app_name,

1346: THEN
1347:
1348: fnd_file.put_line(fnd_file.log,' Error while checking the related accounts : '
1349: || SQLCODE||':'|| SQLERRM );
1350: okc_api.set_message (g_app_name,
1351: g_unexpected_error,
1352: g_sqlcode_token,
1353: SQLCODE,
1354: g_sqlerrm_token,

Line 1428: x_return_status := okc_api.g_ret_sts_success;

1424: AND contract_number_modifier = p_contract_number_modifier;
1425:
1426: l_found BOOLEAN := FALSE;
1427: BEGIN
1428: x_return_status := okc_api.g_ret_sts_success;
1429:
1430: IF ( p_contract_number_modifier IS NOT NULL
1431: AND p_contract_number IS NOT NULL
1432: )

Line 1446: x_return_status := okc_api.g_ret_sts_error;

1442: END IF;
1443:
1444: IF (l_found)
1445: THEN
1446: x_return_status := okc_api.g_ret_sts_error;
1447: okc_api.set_message (g_app_name,
1448: 'OKS_CONTRACT_EXISTS',
1449: 'CONTRACT_NUMBER',
1450: p_contract_number,

Line 1447: okc_api.set_message (g_app_name,

1443:
1444: IF (l_found)
1445: THEN
1446: x_return_status := okc_api.g_ret_sts_error;
1447: okc_api.set_message (g_app_name,
1448: 'OKS_CONTRACT_EXISTS',
1449: 'CONTRACT_NUMBER',
1450: p_contract_number,
1451: 'CONTRACT_NUMBER_MODIFIER',

Line 1476: x_return_status := okc_api.g_ret_sts_success;

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

Line 1478: IF ( p_group_id <> okc_api.g_miss_num

1474: OR user_id = fnd_global.user_id;
1475: BEGIN
1476: x_return_status := okc_api.g_ret_sts_success;
1477:
1478: IF ( p_group_id <> okc_api.g_miss_num
1479: OR p_group_id IS NOT NULL)
1480: THEN
1481: OPEN l_grpid_csr;
1482:

Line 1488: x_return_status := okc_api.g_ret_sts_error;

1484: INTO l_dummy_var;
1485:
1486: IF l_grpid_csr%NOTFOUND
1487: THEN
1488: x_return_status := okc_api.g_ret_sts_error;
1489: okc_api.set_message (g_app_name,
1490: 'OKS_INV_GROUP',
1491: 'GROUP_ID',
1492: p_group_id

Line 1489: okc_api.set_message (g_app_name,

1485:
1486: IF l_grpid_csr%NOTFOUND
1487: THEN
1488: x_return_status := okc_api.g_ret_sts_error;
1489: okc_api.set_message (g_app_name,
1490: 'OKS_INV_GROUP',
1491: 'GROUP_ID',
1492: p_group_id
1493: );

Line 1526: x_return_status := okc_api.g_ret_sts_success;

1522: WHERE party.party_id = acct.party_id
1523: AND acct.status = 'A')
1524: AND party.party_id = p_party_id;
1525: BEGIN
1526: x_return_status := okc_api.g_ret_sts_success;
1527:
1528: IF ( p_party_id = okc_api.g_miss_num
1529: OR p_party_id IS NULL)
1530: THEN

Line 1528: IF ( p_party_id = okc_api.g_miss_num

1524: AND party.party_id = p_party_id;
1525: BEGIN
1526: x_return_status := okc_api.g_ret_sts_success;
1527:
1528: IF ( p_party_id = okc_api.g_miss_num
1529: OR p_party_id IS NULL)
1530: THEN
1531: x_return_status := okc_api.g_ret_sts_error;
1532: okc_api.set_message (g_app_name, 'OKS_REQ_PARTY');

Line 1531: x_return_status := okc_api.g_ret_sts_error;

1527:
1528: IF ( p_party_id = okc_api.g_miss_num
1529: OR p_party_id IS NULL)
1530: THEN
1531: x_return_status := okc_api.g_ret_sts_error;
1532: okc_api.set_message (g_app_name, 'OKS_REQ_PARTY');
1533: ELSE
1534: OPEN l_party_csr;
1535:

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

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

Line 1541: x_return_status := okc_api.g_ret_sts_error;

1537: INTO l_dummy_var;
1538:
1539: IF l_party_csr%NOTFOUND
1540: THEN
1541: x_return_status := okc_api.g_ret_sts_error;
1542: okc_api.set_message (g_app_name,
1543: 'OKS_INV_PARTY',
1544: 'PARTY_ID',
1545: p_party_id

Line 1542: okc_api.set_message (g_app_name,

1538:
1539: IF l_party_csr%NOTFOUND
1540: THEN
1541: x_return_status := okc_api.g_ret_sts_error;
1542: okc_api.set_message (g_app_name,
1543: 'OKS_INV_PARTY',
1544: 'PARTY_ID',
1545: p_party_id
1546: );

Line 1589: x_return_status := okc_api.g_ret_sts_success;

1585: AND NVL (r.end_date, SYSDATE)
1586: AND r.status = 'A'
1587: AND r.party_id = p_contact_id;
1588: BEGIN
1589: x_return_status := okc_api.g_ret_sts_success;
1590:
1591: OPEN l_cust_ctc_csr;
1592: FETCH l_cust_ctc_csr INTO l_dummy_var;
1593:

Line 1596: x_return_status := okc_api.g_ret_sts_error;

1592: FETCH l_cust_ctc_csr INTO l_dummy_var;
1593:
1594: IF l_cust_ctc_csr%NOTFOUND
1595: THEN
1596: x_return_status := okc_api.g_ret_sts_error;
1597: okc_api.set_message (g_app_name,
1598: 'OKS_INV_CONTACT',
1599: 'CONTACT_ID',
1600: p_contact_id,

Line 1597: okc_api.set_message (g_app_name,

1593:
1594: IF l_cust_ctc_csr%NOTFOUND
1595: THEN
1596: x_return_status := okc_api.g_ret_sts_error;
1597: okc_api.set_message (g_app_name,
1598: 'OKS_INV_CONTACT',
1599: 'CONTACT_ID',
1600: p_contact_id,
1601: 'PARTY_ID',

Line 2020: l_return_status := okc_api.g_ret_sts_success;

2016:
2017: -- Main
2018: BEGIN
2019:
2020: l_return_status := okc_api.g_ret_sts_success;
2021: IF (fnd_log.level_event >= fnd_log.g_current_runtime_level)
2022: THEN
2023: fnd_log.STRING (fnd_log.level_event,
2024: g_module_current || 'oks_mass_update.creat_contract_header',

Line 2100: IF NOT l_return_status = okc_api.g_ret_sts_success THEN

2096: x_msg_data => x_msg_data
2097: );
2098:
2099:
2100: IF NOT l_return_status = okc_api.g_ret_sts_success THEN
2101:
2102: Raise G_EXCEPTION_HALT_VALIDATION;
2103: End if;
2104:

Line 2187: IF NOT l_return_status = okc_api.g_ret_sts_success THEN

2183: x_return_status => l_return_status,
2184: x_contract_number => l_chrv_tbl_in (i).contract_number
2185: );
2186:
2187: IF NOT l_return_status = okc_api.g_ret_sts_success THEN
2188: Raise G_EXCEPTION_HALT_VALIDATION;
2189: End if;
2190: IF (fnd_log.level_event >= fnd_log.g_current_runtime_level)
2191: THEN

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

2573: x_msg_data => x_msg_data,
2574: x_return_status => l_return_status
2575: );
2576: fnd_file.put_line(fnd_file.log,'GET_JTF_RESOURCE ret status'||l_return_status);
2577: IF (l_return_status <> OKC_API.G_RET_STS_SUCCESS) THEN
2578: -- Setup error
2579: fnd_file.put_line(fnd_file.log,'SEND_NOTIFICATION');
2580:
2581: OKS_EXTWARPRGM_PVT.SEND_NOTIFICATION(null, hdr_id (i),'SER');

Line 2632: OKC_API.SET_MESSAGE(

2628: OPEN object_code_csr( fnd_profile.VALUE('OKS_VENDOR_CONTACT_ROLE' ));
2629: FETCH object_code_csr INTO l_temp;
2630: IF object_code_csr%NOTFOUND THEN
2631: CLOSE object_code_csr;
2632: OKC_API.SET_MESSAGE(
2633: g_app_name,
2634: g_unexpected_error,
2635: g_sqlcode_token,
2636: SQLCODE,

Line 2641: l_return_status := okc_api.g_ret_sts_error;

2637: g_sqlerrm_token,
2638: 'Wrong vendor contact role assigned'
2639: );
2640:
2641: l_return_status := okc_api.g_ret_sts_error;
2642: RAISE G_EXCEPTION_HALT_VALIDATION;
2643: END IF;
2644: CLOSE object_code_csr;
2645:

Line 2912: IF l_return_status <> okc_api.g_ret_sts_success

2908: 'okc_chr_pvt.insert_row_upg, status = ('
2909: || l_return_status || ')');
2910: END IF;
2911:
2912: IF l_return_status <> okc_api.g_ret_sts_success
2913: THEN
2914:
2915: RAISE g_exception_halt_validation;
2916: END IF;

Line 2995: IF l_return_status <> okc_api.g_ret_sts_success

2991: g_module_current || 'oks_mass_update.create_contract_header',
2992: 'okc_cpl_pvt.insert_row_upg, status = ('
2993: || l_return_status || ')');
2994: END IF;
2995: IF l_return_status <> okc_api.g_ret_sts_success
2996: THEN
2997:
2998: RAISE g_exception_halt_validation;
2999: END IF;

Line 3019: IF l_return_status <> okc_api.g_ret_sts_success

3015: g_module_current || 'oks_mass_update.create_contract_header',
3016: 'okc_ctc_pvt.insert_row_upg, status = ('
3017: || l_return_status || ')');
3018: END IF;
3019: IF l_return_status <> okc_api.g_ret_sts_success
3020: THEN
3021:
3022: RAISE g_exception_halt_validation;
3023: END IF;

Line 3043: IF x_return_status <> okc_api.g_ret_sts_success

3039: g_module_current || 'oks_mass_update.create_contract_header',
3040: 'okc_gve_pvt.insert_row_upg, status = ('
3041: || l_return_status || ')');
3042: END IF;
3043: IF x_return_status <> okc_api.g_ret_sts_success
3044: THEN
3045: RAISE g_exception_halt_validation;
3046: END IF;
3047: END IF;

Line 3066: IF l_return_status <> okc_api.g_ret_sts_success

3062: g_module_current || 'oks_mass_update.create_contract_header',
3063: 'okc_cps_pvt.insert_row_upg, status = ('
3064: || l_return_status || ')');
3065: END IF;
3066: IF l_return_status <> okc_api.g_ret_sts_success
3067: THEN
3068: RAISE g_exception_halt_validation;
3069: END IF;
3070: END IF;

Line 3089: IF l_return_status <> okc_api.g_ret_sts_success

3085: g_module_current || 'oks_mass_update.create_contract_header',
3086: 'okc_cgc_pvt.insert_row_upg, status = ('
3087: || l_return_status || ')');
3088: END IF;
3089: IF l_return_status <> okc_api.g_ret_sts_success
3090: THEN
3091:
3092: RAISE g_exception_halt_validation;
3093: END IF;

Line 3209: x_return_status := okc_api.g_ret_sts_unexp_error;

3205: || SQLCODE||':'|| SQLERRM );
3206: NULL;
3207: WHEN OTHERS
3208: THEN
3209: x_return_status := okc_api.g_ret_sts_unexp_error;
3210: fnd_file.put_line(fnd_file.log,' Error while creating the contract header : '
3211: || SQLCODE||':'|| SQLERRM );
3212: okc_api.set_message (g_app_name,
3213: g_unexpected_error,

Line 3212: okc_api.set_message (g_app_name,

3208: THEN
3209: x_return_status := okc_api.g_ret_sts_unexp_error;
3210: fnd_file.put_line(fnd_file.log,' Error while creating the contract header : '
3211: || SQLCODE||':'|| SQLERRM );
3212: okc_api.set_message (g_app_name,
3213: g_unexpected_error,
3214: g_sqlcode_token,
3215: SQLCODE,
3216: g_sqlerrm_token,

Line 3362: l_return_status := okc_api.g_ret_sts_success;

3358: l_inp_rec okc_inst_cnd_pub.instcnd_inp_rec;
3359:
3360: -- Main Begin
3361: BEGIN
3362: l_return_status := okc_api.g_ret_sts_success;
3363:
3364: l_Tlineno_new := 0;
3365: IF (fnd_log.level_event >= fnd_log.g_current_runtime_level)
3366: THEN

Line 3748: x_return_status := okc_api.g_ret_sts_unexp_error;

3744: || SQLCODE||':'|| SQLERRM );
3745: NULL;
3746: WHEN OTHERS
3747: THEN
3748: x_return_status := okc_api.g_ret_sts_unexp_error;
3749: fnd_file.put_line(fnd_file.log,' Error while creating the service lines : '
3750: || SQLCODE||':'|| SQLERRM );
3751: okc_api.set_message (g_app_name,
3752: g_unexpected_error,

Line 3751: okc_api.set_message (g_app_name,

3747: THEN
3748: x_return_status := okc_api.g_ret_sts_unexp_error;
3749: fnd_file.put_line(fnd_file.log,' Error while creating the service lines : '
3750: || SQLCODE||':'|| SQLERRM );
3751: okc_api.set_message (g_app_name,
3752: g_unexpected_error,
3753: g_sqlcode_token,
3754: SQLCODE,
3755: g_sqlerrm_token,

Line 3875: l_return_status := okc_api.g_ret_sts_success;

3871: l_msg_count NUMBER;
3872: l_msg_data VARCHAR2 (2000);
3873: l_return_status VARCHAR2 (1) := 'S';
3874: BEGIN
3875: l_return_status := okc_api.g_ret_sts_success;
3876:
3877: l_lineno_new := 0;
3878: IF (fnd_log.level_event >= fnd_log.g_current_runtime_level)
3879: THEN

Line 4181: x_return_status := okc_api.g_ret_sts_unexp_error;

4177: || SQLCODE||':'|| SQLERRM );
4178: NULL;
4179: WHEN OTHERS
4180: THEN
4181: x_return_status := okc_api.g_ret_sts_unexp_error;
4182: fnd_file.put_line(fnd_file.log,' Error while creating the sublines : '
4183: || SQLCODE||':'|| SQLERRM );
4184: okc_api.set_message (g_app_name,
4185: g_unexpected_error,

Line 4184: okc_api.set_message (g_app_name,

4180: THEN
4181: x_return_status := okc_api.g_ret_sts_unexp_error;
4182: fnd_file.put_line(fnd_file.log,' Error while creating the sublines : '
4183: || SQLCODE||':'|| SQLERRM );
4184: okc_api.set_message (g_app_name,
4185: g_unexpected_error,
4186: g_sqlcode_token,
4187: SQLCODE,
4188: g_sqlerrm_token,

Line 4218: l_return_status := okc_api.g_ret_sts_success;

4214: l_term_date Date;
4215: l_return_status Varchar2(1);
4216:
4217: Begin
4218: l_return_status := okc_api.g_ret_sts_success;
4219:
4220: l_chrv_tbl_in.DELETE;
4221:
4222: IF get_ste_code(p_Contract_Status) = 'ENTERED'

Line 4254: IF NOT l_return_status = okc_api.g_ret_sts_success

4250:
4251: fnd_file.put_line(fnd_file.log,'(OKS) -> Update contract Header status = ( '
4252: || l_return_status || ' )');
4253:
4254: IF NOT l_return_status = okc_api.g_ret_sts_success
4255: THEN
4256: RAISE g_exception_halt_validation;
4257: END IF;
4258:

Line 4286: p_restricted_update => okc_api.g_true,

4282:
4283: okc_contract_pub.update_contract_header
4284: (p_api_version => l_api_version,
4285: p_init_msg_list => l_init_msg_list,
4286: p_restricted_update => okc_api.g_true,
4287: x_return_status => l_return_status,
4288: x_msg_count => x_msg_count,
4289: x_msg_data => x_msg_data,
4290: p_chrv_tbl => l_chrv_tbl_in,

Line 4296: IF NOT l_return_status = okc_api.g_ret_sts_success

4292: );
4293: fnd_file.put_line(fnd_file.log,'(OKS) -> Update contract Header status = ( '
4294: || l_return_status || ' )');
4295:
4296: IF NOT l_return_status = okc_api.g_ret_sts_success
4297: THEN
4298: RAISE g_exception_halt_validation;
4299: END IF;
4300:

Line 4313: x_return_status := okc_api.g_ret_sts_unexp_error;

4309: || SQLCODE||':'|| SQLERRM );
4310: NULL;
4311: WHEN OTHERS
4312: THEN
4313: x_return_status := okc_api.g_ret_sts_unexp_error;
4314: fnd_file.put_line(fnd_file.log,' Error in Teminate_Cancel_Header: '
4315: || SQLCODE||':'|| SQLERRM );
4316: okc_api.set_message (g_app_name,
4317: g_unexpected_error,

Line 4316: okc_api.set_message (g_app_name,

4312: THEN
4313: x_return_status := okc_api.g_ret_sts_unexp_error;
4314: fnd_file.put_line(fnd_file.log,' Error in Teminate_Cancel_Header: '
4315: || SQLCODE||':'|| SQLERRM );
4316: okc_api.set_message (g_app_name,
4317: g_unexpected_error,
4318: g_sqlcode_token,
4319: SQLCODE,
4320: g_sqlerrm_token,

Line 4390: IF NOT l_return_status = OKC_API.G_RET_STS_SUCCESS Then

4386: p_date_cancelled => l_cancel_date,
4387: p_comments => NULL,
4388: p_validate_status => 'N') ;
4389:
4390: IF NOT l_return_status = OKC_API.G_RET_STS_SUCCESS Then
4391: Raise G_EXCEPTION_HALT_VALIDATION;
4392: End if;
4393:
4394: END IF;

Line 4422: p_restricted_update => okc_api.g_true,

4418:
4419: okc_contract_pub.update_contract_line
4420: (p_api_version => l_api_version,
4421: p_init_msg_list => l_init_msg_list,
4422: p_restricted_update => okc_api.g_true,
4423: x_return_status => l_return_status,
4424: x_msg_count => x_msg_count,
4425: x_msg_data => x_msg_data,
4426: p_clev_tbl => l_clev_tbl_in,

Line 4432: IF NOT l_return_status = okc_api.g_ret_sts_success

4428: );
4429: fnd_file.put_line(fnd_file.log,'(OKS) -> Update contract Line status = ( '
4430: || l_return_status ||' )' );
4431:
4432: IF NOT l_return_status = okc_api.g_ret_sts_success
4433: THEN
4434:
4435: RAISE g_exception_halt_validation;
4436: END IF;

Line 4451: x_return_status := okc_api.g_ret_sts_unexp_error;

4447: || SQLCODE||':'|| SQLERRM );
4448: NULL;
4449: WHEN OTHERS
4450: THEN
4451: x_return_status := okc_api.g_ret_sts_unexp_error;
4452: fnd_file.put_line(fnd_file.log,' Error in Teminate_Cancel_Topline: '
4453: || SQLCODE||':'|| SQLERRM );
4454: okc_api.set_message (g_app_name,
4455: g_unexpected_error,

Line 4454: okc_api.set_message (g_app_name,

4450: THEN
4451: x_return_status := okc_api.g_ret_sts_unexp_error;
4452: fnd_file.put_line(fnd_file.log,' Error in Teminate_Cancel_Topline: '
4453: || SQLCODE||':'|| SQLERRM );
4454: okc_api.set_message (g_app_name,
4455: g_unexpected_error,
4456: g_sqlcode_token,
4457: SQLCODE,
4458: g_sqlerrm_token,

Line 4673: p_init_msg_list => okc_api.g_false,

4669:
4670:
4671: Oks_coverages_pub.create_adjusted_coverage(
4672: p_api_version => 1.0,
4673: p_init_msg_list => okc_api.g_false,
4674: x_return_status => l_return_status,
4675: x_msg_count => x_msg_count,
4676: x_msg_data => x_msg_data,
4677: p_source_contract_line_id => old_srvline_id (Line_ctr),

Line 4691: IF NOT l_return_status = okc_api.g_ret_sts_success

4687: fnd_log.STRING (fnd_log.level_event,
4688: g_module_current || 'oks_mass_update.create_contract_Line',
4689: 'create coverage status = ('|| x_return_status || ')');
4690: END IF;
4691: IF NOT l_return_status = okc_api.g_ret_sts_success
4692: THEN
4693:
4694: RAISE g_exception_halt_validation;
4695: Else

Line 4705: p_init_msg_list => okc_api.g_false,

4701: END IF;
4702:
4703: oks_coverages_pvt.create_k_coverage_ext
4704: (p_api_version => 1.0,
4705: p_init_msg_list => okc_api.g_false,
4706: p_src_line_id => old_srvline_id (Line_ctr),
4707: p_tgt_line_id => srvline_id (Line_ctr),
4708: x_return_status => l_return_status,
4709: x_msg_count => x_msg_count,

Line 4722: IF NOT l_return_status = okc_api.g_ret_sts_success

4718: g_module_current || 'oks_mass_update.create_contract_Line',
4719: 'create coverage extension status = ('|| x_return_status || ')');
4720: END IF;
4721:
4722: IF NOT l_return_status = okc_api.g_ret_sts_success
4723: THEN
4724:
4725: RAISE g_exception_halt_validation;
4726: END IF;

Line 4742: p_init_msg_list => okc_api.g_false,

4738: THEN
4739:
4740: cs_counters_pub.autoinstantiate_counters
4741: (p_api_version => 1.0,
4742: p_init_msg_list => okc_api.g_false,
4743: p_commit => 'F',
4744: x_return_status => l_return_status,
4745: x_msg_count => x_msg_count,
4746: x_msg_data => x_msg_data,

Line 4765: IF NOT l_return_status = okc_api.g_ret_sts_success

4761: END IF;
4762:
4763: END IF;
4764:
4765: IF NOT l_return_status = okc_api.g_ret_sts_success
4766: THEN
4767: okc_api.set_message (g_app_name,
4768: g_required_value,
4769: g_col_name_token,

Line 4767: okc_api.set_message (g_app_name,

4763: END IF;
4764:
4765: IF NOT l_return_status = okc_api.g_ret_sts_success
4766: THEN
4767: okc_api.set_message (g_app_name,
4768: g_required_value,
4769: g_col_name_token,
4770: 'Counter Instantiate (LINE)'
4771: );

Line 4801: IF NOT l_return_status = okc_api.g_ret_sts_success

4797: g_module_current || 'oks_mass_update.create_contract_Line',
4798: 'create events status = ('|| l_return_status || ')');
4799: END IF;
4800:
4801: IF NOT l_return_status = okc_api.g_ret_sts_success
4802: THEN
4803: okc_api.set_message (g_app_name,
4804: g_required_value,
4805: g_col_name_token,

Line 4803: okc_api.set_message (g_app_name,

4799: END IF;
4800:
4801: IF NOT l_return_status = okc_api.g_ret_sts_success
4802: THEN
4803: okc_api.set_message (g_app_name,
4804: g_required_value,
4805: g_col_name_token,
4806: 'Event Instantiate (LINE)'
4807: );

Line 4965: p_init_msg_list => OKC_API.G_TRUE,

4961: G_Rail_rec.Amount := null;
4962: OKS_TAX_UTIL_PVT.Get_Tax
4963: (
4964: p_api_version => 1.0,
4965: p_init_msg_list => OKC_API.G_TRUE,
4966: p_chr_id => contract_id(k),
4967: p_cle_id => subline_id(subline_ctr),
4968: px_rail_rec => G_RAIL_REC,
4969: x_msg_count => x_msg_count,

Line 5022: p_init_msg_list => okc_api.g_false,

5018: || contract_id (k)|| ' ) qcl id = ( '|| qcl_id(k) || ' )');
5019:
5020: okc_qa_check_pub.execute_qa_check_list
5021: (p_api_version => 1.0,
5022: p_init_msg_list => okc_api.g_false,
5023: x_return_status => l_return_status,
5024: x_msg_count => x_msg_count,
5025: x_msg_data => x_msg_data,
5026: p_qcl_id => qcl_id(k),

Line 5034: IF l_return_status <> okc_api.g_ret_sts_success

5030:
5031: fnd_file.put_line(fnd_file.log,'(OKS) -> Qa check status = ( '
5032: || l_return_status || ' ) qa message count = ( ' || l_msg_tbl.COUNT || ' )');
5033:
5034: IF l_return_status <> okc_api.g_ret_sts_success
5035: THEN
5036: x_return_status := l_return_status;
5037: RAISE g_exception_halt_validation;
5038: END IF;

Line 5128: p_init_msg_list => okc_api.g_false,

5124:
5125:
5126: oks_wf_k_process_pvt.launch_k_process_wf
5127: (p_api_version => 1.0,
5128: p_init_msg_list => okc_api.g_false,
5129: p_wf_attributes => l_wf_attributes,
5130: x_return_status => l_return_status,
5131: x_msg_count => x_msg_count,
5132: x_msg_data => x_msg_data

Line 5137: IF l_return_status <> okc_api.g_ret_sts_success

5133: );
5134: fnd_file.put_line(fnd_file.log,'(OKS) -> Lauch workflow process status = ( '
5135: || l_return_status|| ' )');
5136:
5137: IF l_return_status <> okc_api.g_ret_sts_success
5138: THEN
5139: x_return_status := l_return_status;
5140: RAISE g_exception_halt_validation;
5141: END IF;

Line 5163: p_init_msg_list => okc_api.g_false,

5159:
5160:
5161: oks_wf_k_process_pvt.launch_k_process_wf
5162: (p_api_version => 1.0,
5163: p_init_msg_list => okc_api.g_false,
5164: p_wf_attributes => l_wf_attributes,
5165: x_return_status => l_return_status,
5166: x_msg_count => x_msg_count,
5167: x_msg_data => x_msg_data

Line 5173: IF l_return_status <> okc_api.g_ret_sts_success

5169:
5170: fnd_file.put_line(fnd_file.log,'(OKS) -> Lauch workflow process status = ( '
5171: || k||' )'||l_return_status);
5172:
5173: IF l_return_status <> okc_api.g_ret_sts_success
5174: THEN
5175: x_return_status := l_return_status;
5176: RAISE g_exception_halt_validation;
5177: END IF;

Line 5231: IF NOT l_return_status = okc_api.g_ret_sts_success

5227: x_msg_count => x_msg_count,
5228: x_msg_data => x_msg_data
5229: );
5230: fnd_file.put_line(fnd_file.log,'(OKS) -> Create IB Note status = ( ' || l_return_status || ' )');
5231: IF NOT l_return_status = okc_api.g_ret_sts_success
5232: THEN
5233: x_return_status := l_return_status;
5234:
5235: RAISE g_exception_halt_validation;

Line 5255: IF NOT l_return_status = okc_api.g_ret_sts_success

5251: fnd_file.put_line(fnd_file.log,'(OKS) -> For Contract = ( '||old_contract_id(k)
5252: ||' ) Get Notes details Status = ( ' || l_return_status || ' ) Number of Notes = ( '
5253: ||l_notes_tbl.COUNT || ' )');
5254:
5255: IF NOT l_return_status = okc_api.g_ret_sts_success
5256: THEN
5257: x_return_status := l_return_status;
5258: RAISE g_exception_halt_validation;
5259: END IF;

Line 5312: IF NOT l_return_status = okc_api.g_ret_sts_success

5308:
5309: fnd_file.put_line(fnd_file.log,'(OKS) -> Create Notes ( '||m ||' )'|| 'Status = ( '
5310: || l_return_status || ' )');
5311:
5312: IF NOT l_return_status = okc_api.g_ret_sts_success
5313: THEN
5314: x_return_status := l_return_status;
5315: RAISE g_exception_halt_validation;
5316: END IF;

Line 5344: x_return_status := okc_api.g_ret_sts_unexp_error;

5340: || SQLCODE||':'|| SQLERRM );
5341: NULL;
5342: WHEN OTHERS
5343: THEN
5344: x_return_status := okc_api.g_ret_sts_unexp_error;
5345: fnd_file.put_line(fnd_file.log,' Error while creating the cov,billing schd, tax : '
5346: || SQLCODE||':'|| SQLERRM );
5347: okc_api.set_message (g_app_name,
5348: g_unexpected_error,

Line 5347: okc_api.set_message (g_app_name,

5343: THEN
5344: x_return_status := okc_api.g_ret_sts_unexp_error;
5345: fnd_file.put_line(fnd_file.log,' Error while creating the cov,billing schd, tax : '
5346: || SQLCODE||':'|| SQLERRM );
5347: okc_api.set_message (g_app_name,
5348: g_unexpected_error,
5349: g_sqlcode_token,
5350: SQLCODE,
5351: g_sqlerrm_token,

Line 5416: If not l_return_status = OKC_API.G_RET_STS_SUCCESS Then

5412: p_date_cancelled => p_cancellation_date,
5413: p_comments => NULL,
5414: p_validate_status => 'N') ;
5415:
5416: If not l_return_status = OKC_API.G_RET_STS_SUCCESS Then
5417: x_return_status := l_return_status;
5418: Raise G_EXCEPTION_HALT_VALIDATION;
5419: End if;
5420:

Line 5441: IF NOT l_return_status = okc_api.g_ret_sts_success

5437: P_Term_Cancel_source => P_termination_source,
5438: x_return_status => l_return_status
5439: );
5440:
5441: IF NOT l_return_status = okc_api.g_ret_sts_success
5442: THEN
5443: x_return_status := l_return_status;
5444: RAISE g_exception_halt_validation;
5445: END IF;

Line 5451: x_return_status := okc_api.g_ret_sts_error;

5447: x_return_status := l_return_status;
5448: EXCEPTION
5449: WHEN g_exception_halt_validation
5450: THEN
5451: x_return_status := okc_api.g_ret_sts_error;
5452: NULL;
5453: WHEN OTHERS
5454: THEN
5455: x_return_status := okc_api.g_ret_sts_unexp_error;

Line 5455: x_return_status := okc_api.g_ret_sts_unexp_error;

5451: x_return_status := okc_api.g_ret_sts_error;
5452: NULL;
5453: WHEN OTHERS
5454: THEN
5455: x_return_status := okc_api.g_ret_sts_unexp_error;
5456: okc_api.set_message (g_app_name,
5457: g_unexpected_error,
5458: g_sqlcode_token,
5459: SQLCODE,

Line 5456: okc_api.set_message (g_app_name,

5452: NULL;
5453: WHEN OTHERS
5454: THEN
5455: x_return_status := okc_api.g_ret_sts_unexp_error;
5456: okc_api.set_message (g_app_name,
5457: g_unexpected_error,
5458: g_sqlcode_token,
5459: SQLCODE,
5460: g_sqlerrm_token,

Line 5639: okc_api.set_message (g_app_name,

5635: WHEN OTHERS
5636: THEN
5637: fnd_file.put_line(fnd_file.log,' Error while getting the object line id: '
5638: || SQLCODE||':'|| SQLERRM );
5639: okc_api.set_message (g_app_name,
5640: g_unexpected_error,
5641: g_sqlcode_token,
5642: SQLCODE,
5643: g_sqlerrm_token,

Line 5808: IF NOT l_return_status = okc_api.g_ret_sts_success

5804:
5805: fnd_file.put_line(fnd_file.log,'(OKS) -> Create contract header, status = ( '
5806: || l_return_status || ' )');
5807:
5808: IF NOT l_return_status = okc_api.g_ret_sts_success
5809: THEN
5810: x_return_status := l_return_status;
5811: RAISE g_exception_halt_validation;
5812: END IF;

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 Line, 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 subline, 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 5869: IF NOT l_return_status = okc_api.g_ret_sts_success

5865:
5866:
5867: fnd_file.put_line(fnd_file.log,'(OKS) -> CREATE_COV_BILLSCHD, status = ( '
5868: || l_return_status || ' )');
5869: IF NOT l_return_status = okc_api.g_ret_sts_success
5870: THEN
5871: x_return_status := l_return_status;
5872: RAISE g_exception_halt_validation;
5873: END IF;

Line 5885: x_return_status := okc_api.g_ret_sts_unexp_error;

5881: || SQLCODE||':'|| SQLERRM );
5882: NULL;
5883: WHEN OTHERS
5884: THEN
5885: x_return_status := okc_api.g_ret_sts_unexp_error;
5886: fnd_file.put_line(fnd_file.log,' Error while creating the contract : '
5887: || SQLCODE||':'|| SQLERRM );
5888: okc_api.set_message (g_app_name,
5889: g_unexpected_error,

Line 5888: okc_api.set_message (g_app_name,

5884: THEN
5885: x_return_status := okc_api.g_ret_sts_unexp_error;
5886: fnd_file.put_line(fnd_file.log,' Error while creating the contract : '
5887: || SQLCODE||':'|| SQLERRM );
5888: okc_api.set_message (g_app_name,
5889: g_unexpected_error,
5890: g_sqlcode_token,
5891: SQLCODE,
5892: g_sqlerrm_token,

Line 6038: x_return_status := okc_api.g_ret_sts_unexp_error;

6034: || SQLCODE||':'|| SQLERRM );
6035: NULL;
6036: WHEN OTHERS
6037: THEN
6038: x_return_status := okc_api.g_ret_sts_unexp_error;
6039: fnd_file.put_line(fnd_file.log,' Error while terminating/Canceling line/hdr: '
6040: || SQLCODE||':'|| SQLERRM );
6041: okc_api.set_message (g_app_name,
6042: g_unexpected_error,

Line 6041: okc_api.set_message (g_app_name,

6037: THEN
6038: x_return_status := okc_api.g_ret_sts_unexp_error;
6039: fnd_file.put_line(fnd_file.log,' Error while terminating/Canceling line/hdr: '
6040: || SQLCODE||':'|| SQLERRM );
6041: okc_api.set_message (g_app_name,
6042: g_unexpected_error,
6043: g_sqlcode_token,
6044: SQLCODE,
6045: g_sqlerrm_token,

Line 6840: Okc_api.set_message

6836:
6837: fnd_file.put_line(fnd_file.log,'(OKS) -> Forms Batch Rules status = ( '||l_return_status||' )');
6838: IF l_return_status <> 'S'
6839: THEN
6840: Okc_api.set_message
6841: (g_app_name,
6842: 'OKS_BATCH_ERROR'
6843: );
6844:

Line 6861: Okc_api.set_message

6857:
6858: IF get_batch_rules_csr%NOTFOUND
6859: THEN
6860:
6861: Okc_api.set_message
6862: (g_app_name,
6863: 'OKS_NO_BATCH_RULES_EXIST' ,
6864: 'BATCHID',
6865: P_batch_id

Line 6886: Okc_api.set_message

6882: FETCH get_batch_rules_trm_csr INTO batch_rules_trm_rec;
6883:
6884: IF get_batch_rules_trm_csr%NOTFOUND
6885: THEN
6886: Okc_api.set_message
6887: (g_app_name,
6888: 'OKS_NO_BATCH_RULES_EXIST',
6889: 'BATCHID',
6890: P_batch_id

Line 6921: okc_api.set_message

6917:
6918: IF P_new_acct_id IS NULL
6919: THEN
6920: fnd_file.put_line(fnd_file.log,'(OKS) -> New Account id is not passed to Contracts.');
6921: okc_api.set_message
6922: (
6923: g_app_name,
6924: 'OKS_NULL_ACCOUNT_ID',
6925: 'BATCHID',

Line 7002: OKC_API.SET_MESSAGE(

6998: fnd_log.string(FND_LOG.LEVEL_ERROR,G_MODULE_CURRENT||'.oks_mass_update.Update_contracts',
6999: ' Contract '||contract_number(i) ||' in QA_HOLD status' );
7000: END IF;
7001:
7002: OKC_API.SET_MESSAGE(
7003: g_app_name,
7004: 'OKS_CONTRACT_HOLD',
7005: 'CONTRACTNUMBER',
7006: CONTRACT_NUMBER(i)||' '||CONTRACT_NUMBER_MODIFIER(i)

Line 7014: l_return_status := OKC_API.G_RET_STS_ERROR;

7010: END LOOP;
7011:
7012: IF l_found
7013: THEN
7014: l_return_status := OKC_API.G_RET_STS_ERROR;
7015: RAISE G_EXCEPTION_HALT_VALIDATION;
7016: END IF;
7017: FORALL i IN contract_id.FIRST .. contract_id.LAST
7018: INSERT INTO oks_instance_k_dtls_temp

Line 7115: IF NOT l_return_status = okc_api.g_ret_sts_success

7111: END IF;
7112:
7113: fnd_file.put_line(fnd_file.log,'(OKS) -> Terminate_subline status = ( '|| l_return_status|| ' )');
7114:
7115: IF NOT l_return_status = okc_api.g_ret_sts_success
7116: THEN
7117: x_return_status := l_return_status;
7118: OKC_API.SET_MESSAGE
7119: (

Line 7118: OKC_API.SET_MESSAGE

7114:
7115: IF NOT l_return_status = okc_api.g_ret_sts_success
7116: THEN
7117: x_return_status := l_return_status;
7118: OKC_API.SET_MESSAGE
7119: (
7120: g_app_name,
7121: 'OKS_TERMINATE_ERROR',
7122: 'CONTRACTNUMBER',

Line 7146: IF NOT l_return_status = okc_api.g_ret_sts_success

7142:
7143:
7144: fnd_file.put_line(fnd_file.log,'(OKS) -> Terminate/cancel Line/Hdr status = ( '|| l_return_status|| ' )');
7145:
7146: IF NOT l_return_status = okc_api.g_ret_sts_success
7147: THEN
7148: x_return_status := l_return_status;
7149: OKC_API.SET_MESSAGE
7150: (

Line 7149: OKC_API.SET_MESSAGE

7145:
7146: IF NOT l_return_status = okc_api.g_ret_sts_success
7147: THEN
7148: x_return_status := l_return_status;
7149: OKC_API.SET_MESSAGE
7150: (
7151: g_app_name,
7152: 'OKS_TERMINATE_CANCEL_ERROR'
7153: );

Line 7357: OKC_API.SET_MESSAGE(

7353: ' Contract '||contract_number(i) ||' in QA_HOLD status' );
7354: END IF;
7355:
7356:
7357: OKC_API.SET_MESSAGE(
7358: g_app_name,
7359: 'OKS_CONTRACT_HOLD',
7360: 'CONTRACTNUMBER',
7361: CONTRACT_NUMBER(i)||' '||CONTRACT_NUMBER_MODIFIER(i)

Line 7369: l_return_status := OKC_API.G_RET_STS_ERROR;

7365: END LOOP;
7366:
7367: IF l_found
7368: THEN
7369: l_return_status := OKC_API.G_RET_STS_ERROR;
7370: RAISE G_EXCEPTION_HALT_VALIDATION;
7371: END IF;
7372:
7373: Delete Oks_Instance_k_dtls_temp where parent_id = p_batch_id;

Line 7483: IF NOT l_return_status = okc_api.g_ret_sts_success

7479: g_module_current || 'oks_mass_update.Update_contracts',
7480: 'Terminate_subline status = ( '|| l_return_status);
7481: END IF;
7482:
7483: IF NOT l_return_status = okc_api.g_ret_sts_success
7484: THEN
7485: x_return_status := l_return_status;
7486: OKC_API.SET_MESSAGE
7487: (

Line 7486: OKC_API.SET_MESSAGE

7482:
7483: IF NOT l_return_status = okc_api.g_ret_sts_success
7484: THEN
7485: x_return_status := l_return_status;
7486: OKC_API.SET_MESSAGE
7487: (
7488: g_app_name,
7489: 'OKS_TERMINATE_ERROR',
7490: 'CONTRACTNUMBER',

Line 7523: IF NOT l_return_status = okc_api.g_ret_sts_success

7519: END IF;
7520:
7521: fnd_file.put_line(fnd_file.log,'(OKS) -> Create contracts Status = ( '|| l_return_status|| ' )');
7522:
7523: IF NOT l_return_status = okc_api.g_ret_sts_success
7524: THEN
7525: x_return_status := l_return_status;
7526:
7527: RAISE g_exception_halt_validation;

Line 7565: IF NOT l_return_status = okc_api.g_ret_sts_success

7561: X_msg_data => x_msg_data);
7562:
7563: fnd_file.put_line(fnd_file.log,'(OKS) -> Terminate/cancel Line/Hdr status = ( '|| l_return_status|| ' )');
7564:
7565: IF NOT l_return_status = okc_api.g_ret_sts_success
7566: THEN
7567: x_return_status := l_return_status;
7568: OKC_API.SET_MESSAGE
7569: (

Line 7568: OKC_API.SET_MESSAGE

7564:
7565: IF NOT l_return_status = okc_api.g_ret_sts_success
7566: THEN
7567: x_return_status := l_return_status;
7568: OKC_API.SET_MESSAGE
7569: (
7570: g_app_name,
7571: 'OKS_TERMINATE_CANCEL_ERROR'
7572: );

Line 7608: IF NOT l_return_status = okc_api.g_ret_sts_success

7604:
7605: fnd_file.put_line(fnd_file.log,'(OKS) -> Create transfer transaction source ( '
7606: ||i||' )' || 'status = ( ' || l_return_status ||' )');
7607:
7608: IF NOT l_return_status = okc_api.g_ret_sts_success
7609: THEN
7610: x_return_status := l_return_status;
7611: RAISE g_exception_halt_validation;
7612: END IF;

Line 7653: IF NOT l_return_status = okc_api.g_ret_sts_success

7649:
7650: fnd_file.put_line(fnd_file.log,'(OKS) -> Create renewal transaction source ( '
7651: ||i||' )' || 'status = ( '|| l_return_status || ' )');
7652:
7653: IF NOT l_return_status = okc_api.g_ret_sts_success
7654: THEN
7655: x_return_status := l_return_status;
7656:
7657: RAISE g_exception_halt_validation;

Line 7924: l_return_status := OKC_API.G_RET_STS_SUCCESS;

7920:
7921: -- General Batch
7922: IF p_batch_type in ('GEN','MOVE') --'CSI_MU_GENERAL'
7923: THEN
7924: l_return_status := OKC_API.G_RET_STS_SUCCESS;
7925: fnd_file.put_line(fnd_file.log,'(OKS) -> General Batch Processing');
7926:
7927: OPEN get_k_for_idc_csr;
7928:

Line 7985: l_return_status := OKC_API.G_RET_STS_WARNING;

7981: FOR i IN 1..subline_id.count
7982: LOOP
7983: IF idc_date(i) IS NULL
7984: THEN
7985: l_return_status := OKC_API.G_RET_STS_WARNING;
7986: IF FND_LOG.LEVEL_ERROR >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
7987: fnd_log.string(FND_LOG.LEVEL_ERROR,G_MODULE_CURRENT||'.IB_INTERFACE',
7988: 'Installation date changed to null ' );
7989: End If;

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

7986: IF FND_LOG.LEVEL_ERROR >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
7987: fnd_log.string(FND_LOG.LEVEL_ERROR,G_MODULE_CURRENT||'.IB_INTERFACE',
7988: 'Installation date changed to null ' );
7989: End If;
7990: OKC_API.set_message(G_APP_NAME,'OKS_NULL_INSTALLATION_DATE');
7991: Raise G_EXCEPTION_HALT_VALIDATION;
7992:
7993: END IF;
7994: If sr_date(i) Is Not Null Then

Line 7998: l_Warn_return_status := OKC_API.G_RET_STS_WARNING;

7994: If sr_date(i) Is Not Null Then
7995: IF (trunc(sr_date(i)) <= trunc(idc_date(i))
7996: OR TRUNC(sr_date(i)) >= TRUNC(new_edt(i)))
7997: THEN
7998: l_Warn_return_status := OKC_API.G_RET_STS_WARNING;
7999: OKC_API.set_message(G_APP_NAME,'OKS_SR_EXISTS_FOR_CONTRACT'
8000: ,'CONTRACTNUMBER',COntractnumber_modifier(i)
8001: ,'CONTRACTLINE',line_number(i)
8002: ,'INSTANCE',custprod_id (i)

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

7995: IF (trunc(sr_date(i)) <= trunc(idc_date(i))
7996: OR TRUNC(sr_date(i)) >= TRUNC(new_edt(i)))
7997: THEN
7998: l_Warn_return_status := OKC_API.G_RET_STS_WARNING;
7999: OKC_API.set_message(G_APP_NAME,'OKS_SR_EXISTS_FOR_CONTRACT'
8000: ,'CONTRACTNUMBER',COntractnumber_modifier(i)
8001: ,'CONTRACTLINE',line_number(i)
8002: ,'INSTANCE',custprod_id (i)
8003: );

Line 8146: OKC_API.SET_MESSAGE(

8142:
8143:
8144: x_return_status := l_return_status;
8145:
8146: OKC_API.SET_MESSAGE(
8147: g_app_name,
8148: g_required_value,
8149: g_col_name_token,
8150: 'Adjust PM Program Schedule(SUB LINE)'

Line 8363: OKC_API.SET_MESSAGE(

8359: fnd_log.string(FND_LOG.LEVEL_ERROR,G_MODULE_CURRENT||'.oks_mass_update.Update_contracts',
8360: ' Contract '||contract_number(i) ||' in QA_HOLD status' );
8361: END IF;
8362:
8363: OKC_API.SET_MESSAGE(
8364: g_app_name,
8365: 'OKS_CONTRACT_HOLD',
8366: 'CONTRACTNUMBER',
8367: CONTRACT_NUMBER(i)||' '||CONTRACT_NUMBER_MODIFIER(i)

Line 8375: l_return_status := OKC_API.G_RET_STS_ERROR;

8371: END LOOP;
8372:
8373: IF l_found
8374: THEN
8375: l_return_status := OKC_API.G_RET_STS_ERROR;
8376: RAISE G_EXCEPTION_HALT_VALIDATION;
8377: END IF;
8378:
8379:

Line 8453: IF NOT l_return_status = okc_api.g_ret_sts_success

8449: );
8450:
8451: fnd_file.put_line(fnd_file.log,'(OKS) -> Terminate_subline status = ( '|| l_return_status|| ' )');
8452:
8453: IF NOT l_return_status = okc_api.g_ret_sts_success
8454: THEN
8455: x_return_status := l_return_status;
8456: OKC_API.SET_MESSAGE
8457: (

Line 8456: OKC_API.SET_MESSAGE

8452:
8453: IF NOT l_return_status = okc_api.g_ret_sts_success
8454: THEN
8455: x_return_status := l_return_status;
8456: OKC_API.SET_MESSAGE
8457: (
8458: g_app_name,
8459: 'OKS_TERMINATE_ERROR',
8460: 'CONTRACTNUMBER',

Line 8481: IF NOT l_return_status = okc_api.g_ret_sts_success

8477: X_msg_data => x_msg_data);
8478:
8479: fnd_file.put_line(fnd_file.log,'(OKS) -> Terminate/cancel Line/Hdr status = ( '|| l_return_status|| ' )');
8480:
8481: IF NOT l_return_status = okc_api.g_ret_sts_success
8482: THEN
8483: x_return_status := l_return_status;
8484: OKC_API.SET_MESSAGE
8485: (

Line 8484: OKC_API.SET_MESSAGE

8480:
8481: IF NOT l_return_status = okc_api.g_ret_sts_success
8482: THEN
8483: x_return_status := l_return_status;
8484: OKC_API.SET_MESSAGE
8485: (
8486: g_app_name,
8487: 'OKS_TERMINATE_CANCEL_ERROR'
8488: );

Line 8637: x_return_status := okc_api.g_ret_sts_error;

8633: End If;
8634: EXCEPTION
8635: WHEN g_exception_halt_validation
8636: THEN
8637: x_return_status := okc_api.g_ret_sts_error;
8638: fnd_file.put_line(fnd_file.log,' Error while updating the contract ' );
8639: FND_MSG_PUB.Count_And_Get
8640: (
8641: p_count => x_msg_count,

Line 8648: x_return_status := okc_api.g_ret_sts_unexp_error;

8644:
8645: NULL;
8646: WHEN OTHERS
8647: THEN
8648: x_return_status := okc_api.g_ret_sts_unexp_error;
8649: fnd_file.put_line(fnd_file.log,' Error while updating the contract : '
8650: || SQLCODE||':'|| SQLERRM );
8651: okc_api.set_message (g_app_name,
8652: g_unexpected_error,

Line 8651: okc_api.set_message (g_app_name,

8647: THEN
8648: x_return_status := okc_api.g_ret_sts_unexp_error;
8649: fnd_file.put_line(fnd_file.log,' Error while updating the contract : '
8650: || SQLCODE||':'|| SQLERRM );
8651: okc_api.set_message (g_app_name,
8652: g_unexpected_error,
8653: g_sqlcode_token,
8654: SQLCODE,
8655: g_sqlerrm_token,