313: --------------------CHECK COVERAGE MATCH------------------------------------------
314: TYPE oks_bp_rec IS RECORD
315: (PRICE_LIST_ID OKC_K_LINES_B.PRICE_LIST_ID%TYPE,
316: OBJECT1_ID1 OKC_K_ITEMS.OBJECT1_ID1%TYPE,
317: DISCOUNT_LIST OKS_K_LINES_B.DISCOUNT_LIST%TYPE,
318: OFFSET_DURATION OKS_K_LINES_B.OFFSET_DURATION%TYPE,
319: OFFSET_PERIOD OKS_K_LINES_B.OFFSET_PERIOD%TYPE,
320: ALLOW_BT_DISCOUNT OKS_K_LINES_B.ALLOW_BT_DISCOUNT%TYPE,
321: APPLY_DEFAULT_TIMEZONE OKS_K_LINES_B.APPLY_DEFAULT_TIMEZONE%TYPE);
314: TYPE oks_bp_rec IS RECORD
315: (PRICE_LIST_ID OKC_K_LINES_B.PRICE_LIST_ID%TYPE,
316: OBJECT1_ID1 OKC_K_ITEMS.OBJECT1_ID1%TYPE,
317: DISCOUNT_LIST OKS_K_LINES_B.DISCOUNT_LIST%TYPE,
318: OFFSET_DURATION OKS_K_LINES_B.OFFSET_DURATION%TYPE,
319: OFFSET_PERIOD OKS_K_LINES_B.OFFSET_PERIOD%TYPE,
320: ALLOW_BT_DISCOUNT OKS_K_LINES_B.ALLOW_BT_DISCOUNT%TYPE,
321: APPLY_DEFAULT_TIMEZONE OKS_K_LINES_B.APPLY_DEFAULT_TIMEZONE%TYPE);
322:
315: (PRICE_LIST_ID OKC_K_LINES_B.PRICE_LIST_ID%TYPE,
316: OBJECT1_ID1 OKC_K_ITEMS.OBJECT1_ID1%TYPE,
317: DISCOUNT_LIST OKS_K_LINES_B.DISCOUNT_LIST%TYPE,
318: OFFSET_DURATION OKS_K_LINES_B.OFFSET_DURATION%TYPE,
319: OFFSET_PERIOD OKS_K_LINES_B.OFFSET_PERIOD%TYPE,
320: ALLOW_BT_DISCOUNT OKS_K_LINES_B.ALLOW_BT_DISCOUNT%TYPE,
321: APPLY_DEFAULT_TIMEZONE OKS_K_LINES_B.APPLY_DEFAULT_TIMEZONE%TYPE);
322:
323: TYPE oks_bp_tbl IS TABLE OF oks_bp_rec
316: OBJECT1_ID1 OKC_K_ITEMS.OBJECT1_ID1%TYPE,
317: DISCOUNT_LIST OKS_K_LINES_B.DISCOUNT_LIST%TYPE,
318: OFFSET_DURATION OKS_K_LINES_B.OFFSET_DURATION%TYPE,
319: OFFSET_PERIOD OKS_K_LINES_B.OFFSET_PERIOD%TYPE,
320: ALLOW_BT_DISCOUNT OKS_K_LINES_B.ALLOW_BT_DISCOUNT%TYPE,
321: APPLY_DEFAULT_TIMEZONE OKS_K_LINES_B.APPLY_DEFAULT_TIMEZONE%TYPE);
322:
323: TYPE oks_bp_tbl IS TABLE OF oks_bp_rec
324: INDEX BY BINARY_INTEGER;
317: DISCOUNT_LIST OKS_K_LINES_B.DISCOUNT_LIST%TYPE,
318: OFFSET_DURATION OKS_K_LINES_B.OFFSET_DURATION%TYPE,
319: OFFSET_PERIOD OKS_K_LINES_B.OFFSET_PERIOD%TYPE,
320: ALLOW_BT_DISCOUNT OKS_K_LINES_B.ALLOW_BT_DISCOUNT%TYPE,
321: APPLY_DEFAULT_TIMEZONE OKS_K_LINES_B.APPLY_DEFAULT_TIMEZONE%TYPE);
322:
323: TYPE oks_bp_tbl IS TABLE OF oks_bp_rec
324: INDEX BY BINARY_INTEGER;
325:
373: TYPE bill_type_rec IS RECORD
374: (object1_id1 OKC_K_ITEMS_V.OBJECT1_ID1%TYPE,
375: bill_type_line_id NUMBER,
376: billing_type VARCHAR2(30),
377: discount_amount OKS_K_LINES_B.DISCOUNT_AMOUNT%TYPE,
378: discount_percent OKS_K_LINES_B.DISCOUNT_PERCENT%TYPE);
379:
380: TYPE bill_type_tbl IS TABLE OF bill_type_rec INDEX BY BINARY_INTEGER;
381:
374: (object1_id1 OKC_K_ITEMS_V.OBJECT1_ID1%TYPE,
375: bill_type_line_id NUMBER,
376: billing_type VARCHAR2(30),
377: discount_amount OKS_K_LINES_B.DISCOUNT_AMOUNT%TYPE,
378: discount_percent OKS_K_LINES_B.DISCOUNT_PERCENT%TYPE);
379:
380: TYPE bill_type_tbl IS TABLE OF bill_type_rec INDEX BY BINARY_INTEGER;
381:
382: x_source_bill_tbl bill_type_tbl;