[Home] [Help]
891: okl.id cle_id,
892: okl.dnz_chr_id,
893: okl.sts_code,
894: okl.currency_code
895: FROM oks_cov_txn_groups_int_all obp,
896: okc_k_lines_b okl,
897: oks_coverages_int_all cov,
898: oks_con_lines_int_all lines,
899: oks_con_headers_int_all head
2068: l_clev_tbl_in(i+1000).attribute14 :=Attribute14_Tbl(i);
2069: l_clev_tbl_in(i+1000).attribute15 :=Attribute15_Tbl(i);
2070: -- -- dbms_output.put_line('Test4');
2071: l_clev_tbl_in(i+1000).attribute_Category :=attribute_Category_Tbl(i);
2072: l_clev_tbl_in(i+1000).Upg_Orig_System_Ref :='oks_cov_txn_groups_int_all REACTION_TIMES';
2073: l_clev_tbl_in(i+1000).Upg_Orig_System_Ref_Id :=Reaction_Time_ID_Tbl(i);
2074: l_clev_tbl_in(i+1000).INVOICE_LINE_LEVEL_IND :=Null;
2075: l_clev_tbl_in(i+1000).DPAS_RATING :=Null;
2076: l_clev_tbl_in(i+1000).TEMPLATE_USED :=Null;
3322:
3323: END IF;
3324: FORALL i in 1 .. COVERAGE_BUSS_PROCESS_ID_tbl.COUNT
3325:
3326: UPDATE oks_cov_txn_groups_int_all
3327: SET INTERFACED_STATUS_FLAG = 'S',
3328: LAST_UPDATED_BY = -1,
3329: LAST_UPDATE_DATE = sysdate,
3330: LAST_UPDATE_LOGIN = -1
3386: okl.end_date ,
3387: okl.currency_code
3388: FROM
3389: oks_cov_bill_types_int_all obt ,
3390: oks_cov_txn_groups_int_all obp,
3391: okc_k_lines_b okl,
3392: oks_coverages_int_all cov,
3393: oks_con_lines_int_all lines,
3394: oks_con_headers_int_all head
3835: okl.currency_code
3836: FROM oks_cov_bill_rates_int_all obr ,
3837: oks_cov_bill_types_int_all obt,
3838: okc_k_lines_b okl,
3839: oks_cov_txn_groups_int_all obp,
3840: oks_coverages_int_all cov,
3841: oks_con_lines_int_all lines,
3842: oks_con_headers_int_all head
3843: WHERE obr.COVERAGE_BILLING_TYPE_ID = obt.COV_BP_BILLING_TYPE_ID
4233: Cursor get_Buss_Process (p_id in NUMBER)
4234: IS SELECT Coverage_Bus_process_id,
4235: Business_process_id,
4236: Interfaced_Status_flag
4237: FROM oks_cov_txn_groups_int_all txn
4238: WHERE txn.coverage_id = p_id;
4239:
4240: Cursor get_bill_types (p_id in NUMBER)
4241: IS SELECT Interfaced_Status_flag,