358:
359: TYPE bill_tbl_type IS TABLE OF bill_rec_type INDEX BY BINARY_INTEGER;
360:
361: TYPE cimv_rec_type IS RECORD(
362: id NUMBER := OKC_API.G_MISS_NUM,
363: object_version_number NUMBER := OKC_API.G_MISS_NUM,
364: cle_id NUMBER := OKC_API.G_MISS_NUM,
365: chr_id NUMBER := OKC_API.G_MISS_NUM,
366: cle_id_for NUMBER := OKC_API.G_MISS_NUM,
359: TYPE bill_tbl_type IS TABLE OF bill_rec_type INDEX BY BINARY_INTEGER;
360:
361: TYPE cimv_rec_type IS RECORD(
362: id NUMBER := OKC_API.G_MISS_NUM,
363: object_version_number NUMBER := OKC_API.G_MISS_NUM,
364: cle_id NUMBER := OKC_API.G_MISS_NUM,
365: chr_id NUMBER := OKC_API.G_MISS_NUM,
366: cle_id_for NUMBER := OKC_API.G_MISS_NUM,
367: dnz_chr_id NUMBER := OKC_API.G_MISS_NUM,
360:
361: TYPE cimv_rec_type IS RECORD(
362: id NUMBER := OKC_API.G_MISS_NUM,
363: object_version_number NUMBER := OKC_API.G_MISS_NUM,
364: cle_id NUMBER := OKC_API.G_MISS_NUM,
365: chr_id NUMBER := OKC_API.G_MISS_NUM,
366: cle_id_for NUMBER := OKC_API.G_MISS_NUM,
367: dnz_chr_id NUMBER := OKC_API.G_MISS_NUM,
368: object1_id1 OKC_K_ITEMS_V.OBJECT1_ID1%TYPE := OKC_API.G_MISS_CHAR,
361: TYPE cimv_rec_type IS RECORD(
362: id NUMBER := OKC_API.G_MISS_NUM,
363: object_version_number NUMBER := OKC_API.G_MISS_NUM,
364: cle_id NUMBER := OKC_API.G_MISS_NUM,
365: chr_id NUMBER := OKC_API.G_MISS_NUM,
366: cle_id_for NUMBER := OKC_API.G_MISS_NUM,
367: dnz_chr_id NUMBER := OKC_API.G_MISS_NUM,
368: object1_id1 OKC_K_ITEMS_V.OBJECT1_ID1%TYPE := OKC_API.G_MISS_CHAR,
369: object1_id2 OKC_K_ITEMS_V.OBJECT1_ID2%TYPE := OKC_API.G_MISS_CHAR,
362: id NUMBER := OKC_API.G_MISS_NUM,
363: object_version_number NUMBER := OKC_API.G_MISS_NUM,
364: cle_id NUMBER := OKC_API.G_MISS_NUM,
365: chr_id NUMBER := OKC_API.G_MISS_NUM,
366: cle_id_for NUMBER := OKC_API.G_MISS_NUM,
367: dnz_chr_id NUMBER := OKC_API.G_MISS_NUM,
368: object1_id1 OKC_K_ITEMS_V.OBJECT1_ID1%TYPE := OKC_API.G_MISS_CHAR,
369: object1_id2 OKC_K_ITEMS_V.OBJECT1_ID2%TYPE := OKC_API.G_MISS_CHAR,
370: jtot_object1_code OKC_K_ITEMS_V.JTOT_OBJECT1_CODE%TYPE := OKC_API.G_MISS_CHAR,
363: object_version_number NUMBER := OKC_API.G_MISS_NUM,
364: cle_id NUMBER := OKC_API.G_MISS_NUM,
365: chr_id NUMBER := OKC_API.G_MISS_NUM,
366: cle_id_for NUMBER := OKC_API.G_MISS_NUM,
367: dnz_chr_id NUMBER := OKC_API.G_MISS_NUM,
368: object1_id1 OKC_K_ITEMS_V.OBJECT1_ID1%TYPE := OKC_API.G_MISS_CHAR,
369: object1_id2 OKC_K_ITEMS_V.OBJECT1_ID2%TYPE := OKC_API.G_MISS_CHAR,
370: jtot_object1_code OKC_K_ITEMS_V.JTOT_OBJECT1_CODE%TYPE := OKC_API.G_MISS_CHAR,
371: uom_code OKC_K_ITEMS_V.UOM_CODE%TYPE := OKC_API.G_MISS_CHAR,
364: cle_id NUMBER := OKC_API.G_MISS_NUM,
365: chr_id NUMBER := OKC_API.G_MISS_NUM,
366: cle_id_for NUMBER := OKC_API.G_MISS_NUM,
367: dnz_chr_id NUMBER := OKC_API.G_MISS_NUM,
368: object1_id1 OKC_K_ITEMS_V.OBJECT1_ID1%TYPE := OKC_API.G_MISS_CHAR,
369: object1_id2 OKC_K_ITEMS_V.OBJECT1_ID2%TYPE := OKC_API.G_MISS_CHAR,
370: jtot_object1_code OKC_K_ITEMS_V.JTOT_OBJECT1_CODE%TYPE := OKC_API.G_MISS_CHAR,
371: uom_code OKC_K_ITEMS_V.UOM_CODE%TYPE := OKC_API.G_MISS_CHAR,
372: exception_yn OKC_K_ITEMS_V.EXCEPTION_YN%TYPE := OKC_API.G_MISS_CHAR,
365: chr_id NUMBER := OKC_API.G_MISS_NUM,
366: cle_id_for NUMBER := OKC_API.G_MISS_NUM,
367: dnz_chr_id NUMBER := OKC_API.G_MISS_NUM,
368: object1_id1 OKC_K_ITEMS_V.OBJECT1_ID1%TYPE := OKC_API.G_MISS_CHAR,
369: object1_id2 OKC_K_ITEMS_V.OBJECT1_ID2%TYPE := OKC_API.G_MISS_CHAR,
370: jtot_object1_code OKC_K_ITEMS_V.JTOT_OBJECT1_CODE%TYPE := OKC_API.G_MISS_CHAR,
371: uom_code OKC_K_ITEMS_V.UOM_CODE%TYPE := OKC_API.G_MISS_CHAR,
372: exception_yn OKC_K_ITEMS_V.EXCEPTION_YN%TYPE := OKC_API.G_MISS_CHAR,
373: number_of_items NUMBER := OKC_API.G_MISS_NUM,
366: cle_id_for NUMBER := OKC_API.G_MISS_NUM,
367: dnz_chr_id NUMBER := OKC_API.G_MISS_NUM,
368: object1_id1 OKC_K_ITEMS_V.OBJECT1_ID1%TYPE := OKC_API.G_MISS_CHAR,
369: object1_id2 OKC_K_ITEMS_V.OBJECT1_ID2%TYPE := OKC_API.G_MISS_CHAR,
370: jtot_object1_code OKC_K_ITEMS_V.JTOT_OBJECT1_CODE%TYPE := OKC_API.G_MISS_CHAR,
371: uom_code OKC_K_ITEMS_V.UOM_CODE%TYPE := OKC_API.G_MISS_CHAR,
372: exception_yn OKC_K_ITEMS_V.EXCEPTION_YN%TYPE := OKC_API.G_MISS_CHAR,
373: number_of_items NUMBER := OKC_API.G_MISS_NUM,
374: upg_orig_system_ref OKC_K_ITEMS_V.UPG_ORIG_SYSTEM_REF%TYPE := OKC_API.G_MISS_CHAR,
367: dnz_chr_id NUMBER := OKC_API.G_MISS_NUM,
368: object1_id1 OKC_K_ITEMS_V.OBJECT1_ID1%TYPE := OKC_API.G_MISS_CHAR,
369: object1_id2 OKC_K_ITEMS_V.OBJECT1_ID2%TYPE := OKC_API.G_MISS_CHAR,
370: jtot_object1_code OKC_K_ITEMS_V.JTOT_OBJECT1_CODE%TYPE := OKC_API.G_MISS_CHAR,
371: uom_code OKC_K_ITEMS_V.UOM_CODE%TYPE := OKC_API.G_MISS_CHAR,
372: exception_yn OKC_K_ITEMS_V.EXCEPTION_YN%TYPE := OKC_API.G_MISS_CHAR,
373: number_of_items NUMBER := OKC_API.G_MISS_NUM,
374: upg_orig_system_ref OKC_K_ITEMS_V.UPG_ORIG_SYSTEM_REF%TYPE := OKC_API.G_MISS_CHAR,
375: upg_orig_system_ref_id NUMBER := OKC_API.G_MISS_NUM,
368: object1_id1 OKC_K_ITEMS_V.OBJECT1_ID1%TYPE := OKC_API.G_MISS_CHAR,
369: object1_id2 OKC_K_ITEMS_V.OBJECT1_ID2%TYPE := OKC_API.G_MISS_CHAR,
370: jtot_object1_code OKC_K_ITEMS_V.JTOT_OBJECT1_CODE%TYPE := OKC_API.G_MISS_CHAR,
371: uom_code OKC_K_ITEMS_V.UOM_CODE%TYPE := OKC_API.G_MISS_CHAR,
372: exception_yn OKC_K_ITEMS_V.EXCEPTION_YN%TYPE := OKC_API.G_MISS_CHAR,
373: number_of_items NUMBER := OKC_API.G_MISS_NUM,
374: upg_orig_system_ref OKC_K_ITEMS_V.UPG_ORIG_SYSTEM_REF%TYPE := OKC_API.G_MISS_CHAR,
375: upg_orig_system_ref_id NUMBER := OKC_API.G_MISS_NUM,
376: priced_item_yn OKC_K_ITEMS_V.PRICED_ITEM_YN%TYPE := OKC_API.G_MISS_CHAR,
369: object1_id2 OKC_K_ITEMS_V.OBJECT1_ID2%TYPE := OKC_API.G_MISS_CHAR,
370: jtot_object1_code OKC_K_ITEMS_V.JTOT_OBJECT1_CODE%TYPE := OKC_API.G_MISS_CHAR,
371: uom_code OKC_K_ITEMS_V.UOM_CODE%TYPE := OKC_API.G_MISS_CHAR,
372: exception_yn OKC_K_ITEMS_V.EXCEPTION_YN%TYPE := OKC_API.G_MISS_CHAR,
373: number_of_items NUMBER := OKC_API.G_MISS_NUM,
374: upg_orig_system_ref OKC_K_ITEMS_V.UPG_ORIG_SYSTEM_REF%TYPE := OKC_API.G_MISS_CHAR,
375: upg_orig_system_ref_id NUMBER := OKC_API.G_MISS_NUM,
376: priced_item_yn OKC_K_ITEMS_V.PRICED_ITEM_YN%TYPE := OKC_API.G_MISS_CHAR,
377: created_by NUMBER := OKC_API.G_MISS_NUM,
370: jtot_object1_code OKC_K_ITEMS_V.JTOT_OBJECT1_CODE%TYPE := OKC_API.G_MISS_CHAR,
371: uom_code OKC_K_ITEMS_V.UOM_CODE%TYPE := OKC_API.G_MISS_CHAR,
372: exception_yn OKC_K_ITEMS_V.EXCEPTION_YN%TYPE := OKC_API.G_MISS_CHAR,
373: number_of_items NUMBER := OKC_API.G_MISS_NUM,
374: upg_orig_system_ref OKC_K_ITEMS_V.UPG_ORIG_SYSTEM_REF%TYPE := OKC_API.G_MISS_CHAR,
375: upg_orig_system_ref_id NUMBER := OKC_API.G_MISS_NUM,
376: priced_item_yn OKC_K_ITEMS_V.PRICED_ITEM_YN%TYPE := OKC_API.G_MISS_CHAR,
377: created_by NUMBER := OKC_API.G_MISS_NUM,
378: creation_date OKC_K_ITEMS_V.CREATION_DATE%TYPE := OKC_API.G_MISS_DATE,
371: uom_code OKC_K_ITEMS_V.UOM_CODE%TYPE := OKC_API.G_MISS_CHAR,
372: exception_yn OKC_K_ITEMS_V.EXCEPTION_YN%TYPE := OKC_API.G_MISS_CHAR,
373: number_of_items NUMBER := OKC_API.G_MISS_NUM,
374: upg_orig_system_ref OKC_K_ITEMS_V.UPG_ORIG_SYSTEM_REF%TYPE := OKC_API.G_MISS_CHAR,
375: upg_orig_system_ref_id NUMBER := OKC_API.G_MISS_NUM,
376: priced_item_yn OKC_K_ITEMS_V.PRICED_ITEM_YN%TYPE := OKC_API.G_MISS_CHAR,
377: created_by NUMBER := OKC_API.G_MISS_NUM,
378: creation_date OKC_K_ITEMS_V.CREATION_DATE%TYPE := OKC_API.G_MISS_DATE,
379: last_updated_by NUMBER := OKC_API.G_MISS_NUM,
372: exception_yn OKC_K_ITEMS_V.EXCEPTION_YN%TYPE := OKC_API.G_MISS_CHAR,
373: number_of_items NUMBER := OKC_API.G_MISS_NUM,
374: upg_orig_system_ref OKC_K_ITEMS_V.UPG_ORIG_SYSTEM_REF%TYPE := OKC_API.G_MISS_CHAR,
375: upg_orig_system_ref_id NUMBER := OKC_API.G_MISS_NUM,
376: priced_item_yn OKC_K_ITEMS_V.PRICED_ITEM_YN%TYPE := OKC_API.G_MISS_CHAR,
377: created_by NUMBER := OKC_API.G_MISS_NUM,
378: creation_date OKC_K_ITEMS_V.CREATION_DATE%TYPE := OKC_API.G_MISS_DATE,
379: last_updated_by NUMBER := OKC_API.G_MISS_NUM,
380: last_update_date OKC_K_ITEMS_V.LAST_UPDATE_DATE%TYPE := OKC_API.G_MISS_DATE,
373: number_of_items NUMBER := OKC_API.G_MISS_NUM,
374: upg_orig_system_ref OKC_K_ITEMS_V.UPG_ORIG_SYSTEM_REF%TYPE := OKC_API.G_MISS_CHAR,
375: upg_orig_system_ref_id NUMBER := OKC_API.G_MISS_NUM,
376: priced_item_yn OKC_K_ITEMS_V.PRICED_ITEM_YN%TYPE := OKC_API.G_MISS_CHAR,
377: created_by NUMBER := OKC_API.G_MISS_NUM,
378: creation_date OKC_K_ITEMS_V.CREATION_DATE%TYPE := OKC_API.G_MISS_DATE,
379: last_updated_by NUMBER := OKC_API.G_MISS_NUM,
380: last_update_date OKC_K_ITEMS_V.LAST_UPDATE_DATE%TYPE := OKC_API.G_MISS_DATE,
381: last_update_login NUMBER := OKC_API.G_MISS_NUM
374: upg_orig_system_ref OKC_K_ITEMS_V.UPG_ORIG_SYSTEM_REF%TYPE := OKC_API.G_MISS_CHAR,
375: upg_orig_system_ref_id NUMBER := OKC_API.G_MISS_NUM,
376: priced_item_yn OKC_K_ITEMS_V.PRICED_ITEM_YN%TYPE := OKC_API.G_MISS_CHAR,
377: created_by NUMBER := OKC_API.G_MISS_NUM,
378: creation_date OKC_K_ITEMS_V.CREATION_DATE%TYPE := OKC_API.G_MISS_DATE,
379: last_updated_by NUMBER := OKC_API.G_MISS_NUM,
380: last_update_date OKC_K_ITEMS_V.LAST_UPDATE_DATE%TYPE := OKC_API.G_MISS_DATE,
381: last_update_login NUMBER := OKC_API.G_MISS_NUM
382: );
375: upg_orig_system_ref_id NUMBER := OKC_API.G_MISS_NUM,
376: priced_item_yn OKC_K_ITEMS_V.PRICED_ITEM_YN%TYPE := OKC_API.G_MISS_CHAR,
377: created_by NUMBER := OKC_API.G_MISS_NUM,
378: creation_date OKC_K_ITEMS_V.CREATION_DATE%TYPE := OKC_API.G_MISS_DATE,
379: last_updated_by NUMBER := OKC_API.G_MISS_NUM,
380: last_update_date OKC_K_ITEMS_V.LAST_UPDATE_DATE%TYPE := OKC_API.G_MISS_DATE,
381: last_update_login NUMBER := OKC_API.G_MISS_NUM
382: );
383:
376: priced_item_yn OKC_K_ITEMS_V.PRICED_ITEM_YN%TYPE := OKC_API.G_MISS_CHAR,
377: created_by NUMBER := OKC_API.G_MISS_NUM,
378: creation_date OKC_K_ITEMS_V.CREATION_DATE%TYPE := OKC_API.G_MISS_DATE,
379: last_updated_by NUMBER := OKC_API.G_MISS_NUM,
380: last_update_date OKC_K_ITEMS_V.LAST_UPDATE_DATE%TYPE := OKC_API.G_MISS_DATE,
381: last_update_login NUMBER := OKC_API.G_MISS_NUM
382: );
383:
384: TYPE cimv_tbl_type IS TABLE OF cimv_rec_type INDEX BY BINARY_INTEGER;
377: created_by NUMBER := OKC_API.G_MISS_NUM,
378: creation_date OKC_K_ITEMS_V.CREATION_DATE%TYPE := OKC_API.G_MISS_DATE,
379: last_updated_by NUMBER := OKC_API.G_MISS_NUM,
380: last_update_date OKC_K_ITEMS_V.LAST_UPDATE_DATE%TYPE := OKC_API.G_MISS_DATE,
381: last_update_login NUMBER := OKC_API.G_MISS_NUM
382: );
383:
384: TYPE cimv_tbl_type IS TABLE OF cimv_rec_type INDEX BY BINARY_INTEGER;
385: