[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'
521: l_pay_group_code okl_trx_ap_invoices_v.pay_group_lookup_code%TYPE;
522: l_fee_line_amount NUMBER;
523: l_amount_disbursed NUMBER;
524: l_amnt_to_be_disbursed NUMBER;
525: l_sty_id okl_strm_type_v.id%TYPE;
526: l_try_id okl_trx_types_v.id%TYPE;
527: l_payout_date DATE;
528: l_investor_name PO_VENDORS.vendor_name%TYPE;
529: l_investor_site_code PO_VENDOR_SITES.vendor_site_code%TYPE;
526: l_try_id okl_trx_types_v.id%TYPE;
527: l_payout_date DATE;
528: l_investor_name PO_VENDORS.vendor_name%TYPE;
529: l_investor_site_code PO_VENDOR_SITES.vendor_site_code%TYPE;
530: l_strm_name OKL_STRM_TYPE_V.name%TYPE;
531:
532: l_ia_id okl_k_headers_full_v.id%type;
533: l_currency_code okl_k_headers_full_v.currency_code%TYPE;
534: l_currency_conv_type okl_k_headers_full_v.currency_conversion_type%TYPE;
840: oklh.deal_type deal_type
841: FROM
842: okl_strm_elements ste,
843: okl_streams stm,
844: okl_strm_type_v sty,
845: okc_k_headers_b khr,
846: okl_k_headers oklh
847: WHERE trunc(ste.stream_element_date) <= trunc(NVL(p_date_to, SYSDATE))
848: AND ste.amount <> 0
897: -- Bug 4550607
898: okl_strm_elements ste1,
899: -- End Bug 4550607
900: okl_streams stm,
901: okl_strm_type_v sty,
902: okc_k_headers_b khr,
903: okl_k_headers khl,
904: okc_statuses_b khs ,
905: --Added by bkatraga for bug 6983321
1177: -- xlp_id okl_xtl_pay_invs_v.id%TYPE,
1178: proc_sel_id okl_strm_elements.id%TYPE,
1179: bill_date DATE,
1180: contract_number okc_k_headers_b.contract_number%type,
1181: stream_name okl_strm_type_v.name%type,
1182: amount okl_strm_elements.amount%type,
1183: error_message Varchar2(2000)
1184: );
1185:
1195: -- xlp_id okl_xtl_pay_invs_v.id%TYPE,
1196: proc_sel_id okl_strm_elements.id%TYPE,
1197: bill_date DATE,
1198: contract_number okc_k_headers_b.contract_number%type,
1199: stream_name okl_strm_type_v.name%type,
1200: amount okl_strm_elements.amount%type,
1201: error_message Varchar2(2000)
1202: );
1203:
1222: -----------------------------------------------------------------
1223: l_org_id okc_k_headers_b.authoring_org_id%TYPE;
1224: l_sob_id HR_OPERATING_UNITS.set_of_books_id%TYPE;
1225: l_try_id okl_trx_types_v.id%TYPE;
1226: l_sty_id okl_strm_type_v.id%TYPE;
1227: l_pdt_id okl_products_v.id%TYPE;
1228:
1229: l_payout_date DATE;
1230:
1325: --end:| 09-Mar-2007 cklee code fixed to refer to proper FK
1326:
1327: l_percent_stake okl_k_lines.percent_stake%TYPE;
1328:
1329: l_parent_sty_id okl_strm_type_v.id%TYPE;
1330:
1331: l_dstr_cnt NUMBER;
1332:
1333: l_idh_id NUMBER;
1333: l_idh_id NUMBER;
1334:
1335: l_rcpt_cnt NUMBER;
1336:
1337: l_parent_sty_subclass OKL_STRM_TYPE_V.stream_type_subclass%TYPE;
1338:
1339: l_disb_strm_name OKL_STRM_TYPE_V.name%TYPE;
1340:
1341: -- Start Bug 4648410
1335: l_rcpt_cnt NUMBER;
1336:
1337: l_parent_sty_subclass OKL_STRM_TYPE_V.stream_type_subclass%TYPE;
1338:
1339: l_disb_strm_name OKL_STRM_TYPE_V.name%TYPE;
1340:
1341: -- Start Bug 4648410
1342: l_tmpl_identify_rec Okl_Account_Dist_Pvt.TMPL_IDENTIFY_REC_TYPE;
1343: l_init_tmpl_identify_rec Okl_Account_Dist_Pvt.TMPL_IDENTIFY_REC_TYPE;
1379: SELECT 'Y'
1380: FROM dual
1381: WHERE EXISTS
1382: ( SELECT 1
1383: FROM OKL_POOLS pool, okl_pool_contents_v poc, okl_strm_type_v sty
1384: WHERE pool.khr_id = p_khr_id
1385: AND pool.id = poc.pol_id
1386: AND poc.sty_id = sty.id
1387: AND sty.stream_type_purpose = 'RESIDUAL_VALUE'
1413: xlp_id okl_xtl_pay_invs_v.id%TYPE,
1414: proc_sel_id okl_strm_elements.id%TYPE,
1415: bill_date DATE,
1416: contract_number okc_k_headers_b.contract_number%type,
1417: stream_name okl_strm_type_v.name%type,
1418: amount okl_strm_elements.amount%type,
1419: error_message Varchar2(2000)
1420: );
1421: