[Home] [Help]
94: -- Cursor to fetch Stream Name
95: -----------------------------------------------------------------
96: CURSOR disb_strm_csr( p_sty_id NUMBER ) IS
97: SELECT name
98: FROM OKL_STRM_TYPE_V
99: WHERE id = p_sty_id;
100:
101: -- gboomina Bug 6788005 - End
102:
111: p_rbk_kle_id NUMBER ) IS
112: SELECT NVL(SUM(SEL.AMOUNT),0)
113: FROM OKL_STREAMS STM,
114: OKL_STRM_ELEMENTS SEL,
115: OKL_STRM_TYPE_V STY
116: WHERE STM.KHR_ID = p_rbk_khr_id
117: AND NVL(STM.KLE_ID,-99) = NVL ( p_rbk_kle_id,-99 )
118: AND STM.STY_ID = STY.ID
119: AND stm.source_table = 'OKL_K_HEADERS'
506: l_pay_group_code okl_trx_ap_invoices_v.pay_group_lookup_code%TYPE;
507: l_fee_line_amount NUMBER;
508: l_amount_disbursed NUMBER;
509: l_amnt_to_be_disbursed NUMBER;
510: l_sty_id okl_strm_type_v.id%TYPE;
511: l_try_id okl_trx_types_v.id%TYPE;
512: l_payout_date DATE;
513: l_investor_name PO_VENDORS.vendor_name%TYPE;
514: l_investor_site_code PO_VENDOR_SITES.vendor_site_code%TYPE;
511: l_try_id okl_trx_types_v.id%TYPE;
512: l_payout_date DATE;
513: l_investor_name PO_VENDORS.vendor_name%TYPE;
514: l_investor_site_code PO_VENDOR_SITES.vendor_site_code%TYPE;
515: l_strm_name OKL_STRM_TYPE_V.name%TYPE;
516:
517: l_ia_id okl_k_headers_full_v.id%type;
518: l_currency_code okl_k_headers_full_v.currency_code%TYPE;
519: l_currency_conv_type okl_k_headers_full_v.currency_conversion_type%TYPE;
825: oklh.deal_type deal_type
826: FROM
827: okl_strm_elements ste,
828: okl_streams stm,
829: okl_strm_type_v sty,
830: okc_k_headers_b khr,
831: okl_k_headers oklh
832: WHERE trunc(ste.stream_element_date) <= trunc(NVL(p_date_to, SYSDATE))
833: AND ste.amount <> 0
882: -- Bug 4550607
883: okl_strm_elements ste1,
884: -- End Bug 4550607
885: okl_streams stm,
886: okl_strm_type_v sty,
887: okc_k_headers_b khr,
888: okl_k_headers khl,
889: okc_statuses_b khs ,
890: --Added by bkatraga for bug 6983321
1107: -- xlp_id okl_xtl_pay_invs_v.id%TYPE,
1108: proc_sel_id okl_strm_elements.id%TYPE,
1109: bill_date DATE,
1110: contract_number okc_k_headers_b.contract_number%type,
1111: stream_name okl_strm_type_v.name%type,
1112: amount okl_strm_elements.amount%type,
1113: error_message Varchar2(2000)
1114: );
1115:
1125: -- xlp_id okl_xtl_pay_invs_v.id%TYPE,
1126: proc_sel_id okl_strm_elements.id%TYPE,
1127: bill_date DATE,
1128: contract_number okc_k_headers_b.contract_number%type,
1129: stream_name okl_strm_type_v.name%type,
1130: amount okl_strm_elements.amount%type,
1131: error_message Varchar2(2000)
1132: );
1133:
1152: -----------------------------------------------------------------
1153: l_org_id okc_k_headers_b.authoring_org_id%TYPE;
1154: l_sob_id HR_OPERATING_UNITS.set_of_books_id%TYPE;
1155: l_try_id okl_trx_types_v.id%TYPE;
1156: l_sty_id okl_strm_type_v.id%TYPE;
1157: l_pdt_id okl_products_v.id%TYPE;
1158:
1159: l_payout_date DATE;
1160:
1255: --end:| 09-Mar-2007 cklee code fixed to refer to proper FK
1256:
1257: l_percent_stake okl_k_lines.percent_stake%TYPE;
1258:
1259: l_parent_sty_id okl_strm_type_v.id%TYPE;
1260:
1261: l_dstr_cnt NUMBER;
1262:
1263: l_idh_id NUMBER;
1263: l_idh_id NUMBER;
1264:
1265: l_rcpt_cnt NUMBER;
1266:
1267: l_parent_sty_subclass OKL_STRM_TYPE_V.stream_type_subclass%TYPE;
1268:
1269: l_disb_strm_name OKL_STRM_TYPE_V.name%TYPE;
1270:
1271: -- Start Bug 4648410
1265: l_rcpt_cnt NUMBER;
1266:
1267: l_parent_sty_subclass OKL_STRM_TYPE_V.stream_type_subclass%TYPE;
1268:
1269: l_disb_strm_name OKL_STRM_TYPE_V.name%TYPE;
1270:
1271: -- Start Bug 4648410
1272: l_tmpl_identify_rec Okl_Account_Dist_Pvt.TMPL_IDENTIFY_REC_TYPE;
1273: l_init_tmpl_identify_rec Okl_Account_Dist_Pvt.TMPL_IDENTIFY_REC_TYPE;
1309: SELECT 'Y'
1310: FROM dual
1311: WHERE EXISTS
1312: ( SELECT 1
1313: FROM OKL_POOLS pool, okl_pool_contents_v poc, okl_strm_type_v sty
1314: WHERE pool.khr_id = p_khr_id
1315: AND pool.id = poc.pol_id
1316: AND poc.sty_id = sty.id
1317: AND sty.stream_type_purpose = 'RESIDUAL_VALUE'
1343: xlp_id okl_xtl_pay_invs_v.id%TYPE,
1344: proc_sel_id okl_strm_elements.id%TYPE,
1345: bill_date DATE,
1346: contract_number okc_k_headers_b.contract_number%type,
1347: stream_name okl_strm_type_v.name%type,
1348: amount okl_strm_elements.amount%type,
1349: error_message Varchar2(2000)
1350: );
1351: