APPS.OKS_CCMIGRATE_PVT dependencies on OKS_K_LINES_BH

Line 201: From OKS_K_LINES_BH okslineh ;

197: max(okslineh.id) maxid,
198: avg(okslineh.id) avgid,
199: stddev(okslineh.id) stdid,
200: count(*) total
201: From OKS_K_LINES_BH okslineh ;
202:
203: l_agg_rec l_line_agg_csr2%rowtype;
204: l_sub_requests number;
205: l_sub_req number;

Line 260: -- The following csr is on OKS_K_LINES_BH

256: END IF;
257:
258:
259:
260: -- The following csr is on OKS_K_LINES_BH
261: open l_line_agg_csr2;
262: fetch l_line_agg_csr2 into l_agg_rec;
263: close l_line_agg_csr2;
264:

Line 455: from OKS_K_LINES_BH oksline,

451: SEC.sec_segment_id,
452: SEC.cc_number_length,
453: SEC.cc_unmask_digits,
454: LPAD(sec.cc_unmask_digits, NVL(range.card_number_length, length(oksline.cc_no)),'X')
455: from OKS_K_LINES_BH oksline,
456: (select hz.party_id, hdr.authoring_org_id, hdr.id hdr_id, line.cust_acct_id,
457: line.bill_to_site_use_id, line.id line_id
458: from okc_k_lines_b line, okc_k_headers_all_b hdr, hz_cust_accounts_all hz
459: where line.dnz_chr_id = hdr.id

Line 516: from oks_k_lines_bh oksline,

512: SUBSTR(oksline.cc_no,GREATEST(-4,-LENGTH(oksline.cc_no))) cc_unmask_digits,
513: LPAD(SUBSTR(oksline.cc_no, GREATEST(-4,-LENGTH(oksline.cc_no))),
514: LENGTH(oksline.cc_no),
515: 'X' ) masked_cc_number
516: from oks_k_lines_bh oksline,
517: (select hz.party_id, hdr.authoring_org_id, hdr.id hdr_id, line.cust_acct_id,
518: line.bill_to_site_use_id, line.id line_id
519: from okc_k_lines_b line, okc_k_headers_all_b hdr, hz_cust_accounts_all hz
520: where line.dnz_chr_id = hdr.id

Line 717: UPDATE oks_k_lines_bh

713:
714: -- update the foreign key relationship
715:
716: FORALL i in c_trxn_entity_id.first..c_trxn_entity_id.last
717: UPDATE oks_k_lines_bh
718: SET TRXN_EXTENSION_ID = c_trxn_entity_id(i)
719: WHERE id = oksline_id(i)
720: AND major_version = oksline_major_version(i);
721:

Line 2725: From OKS_K_LINES_BH okslineh ;

2721: max(okslineh.id) maxid,
2722: avg(okslineh.id) avgid,
2723: stddev(okslineh.id) stdid,
2724: count(*) total
2725: From OKS_K_LINES_BH okslineh ;
2726:
2727: l_agg_rec l_line_hist_agg_csr%rowtype;
2728: l_sub_requests number;
2729: l_sub_req number;

Line 2877: From oks_k_lines_bh ks

2873:
2874:
2875: Cursor l_line_hist_csr Is
2876: Select Ks.id
2877: From oks_k_lines_bh ks
2878: where Ks.cc_no is not null
2879: And Ks.trxn_extension_id is not null
2880: And Ks.id between p_id_low and p_id_high;
2881:

Line 2895: Update Oks_k_Lines_bh

2891:
2892: -- Update Line history table
2893:
2894: Forall i in l_line_id.first..l_line_id.last
2895: Update Oks_k_Lines_bh
2896: Set cc_no = null,
2897: cc_bank_acct_id = null,
2898: cc_expiry_date = null,
2899: cc_auth_code = null