[Home] [Help]
315: l_cons_inv_number VARCHAR2(30) DEFAULT p_cons_inv_number;
316: l_contract_number VARCHAR2(30) DEFAULT p_contract_number;
317: l_ar_inv_number VARCHAR2(30) DEFAULT p_ar_inv_number;
318:
319: l_sty_id OKL_SRCH_STRM_TYPS.STY_ID%TYPE DEFAULT NULL;
320: l_amount_due_remaining NUMBER DEFAULT NULL;
321: l_currency_code ar_cash_receipts.currency_code%TYPE DEFAULT p_currency_code;
322:
323: l_running_total NUMBER DEFAULT NULL;
334: i NUMBER DEFAULT NULL; -- for scn table count
335: j NUMBER DEFAULT NULL; -- for ttl table count
336: k NUMBER DEFAULT NULL; -- for tmc table count
337:
338: l_cah_id OKL_SRCH_STRM_TYPS.CAH_ID%TYPE DEFAULT NULL;
339: l_seq_num OKL_CSH_ALLCT_SRCHS.SEQUENCE_NUMBER%TYPE DEFAULT NULL;
340: l_csh_type OKL_CSH_ALLCT_SRCHS.CASH_SEARCH_TYPE%TYPE DEFAULT NULL;
341:
342: l_rule_sty_id OKL_SRCH_STRM_TYPS.STY_ID%TYPE DEFAULT NULL;
338: l_cah_id OKL_SRCH_STRM_TYPS.CAH_ID%TYPE DEFAULT NULL;
339: l_seq_num OKL_CSH_ALLCT_SRCHS.SEQUENCE_NUMBER%TYPE DEFAULT NULL;
340: l_csh_type OKL_CSH_ALLCT_SRCHS.CASH_SEARCH_TYPE%TYPE DEFAULT NULL;
341:
342: l_rule_sty_id OKL_SRCH_STRM_TYPS.STY_ID%TYPE DEFAULT NULL;
343: l_add_yn OKL_SRCH_STRM_TYPS.ADD_YN%TYPE DEFAULT NULL;
344:
345: l_api_version NUMBER := 1.0;
346: l_init_msg_list VARCHAR2(1) := FND_API.G_FALSE;
339: l_seq_num OKL_CSH_ALLCT_SRCHS.SEQUENCE_NUMBER%TYPE DEFAULT NULL;
340: l_csh_type OKL_CSH_ALLCT_SRCHS.CASH_SEARCH_TYPE%TYPE DEFAULT NULL;
341:
342: l_rule_sty_id OKL_SRCH_STRM_TYPS.STY_ID%TYPE DEFAULT NULL;
343: l_add_yn OKL_SRCH_STRM_TYPS.ADD_YN%TYPE DEFAULT NULL;
344:
345: l_api_version NUMBER := 1.0;
346: l_init_msg_list VARCHAR2(1) := FND_API.G_FALSE;
347: l_return_status VARCHAR2(1);
435:
436: -- get search combination rule lines
437: CURSOR c_get_rule_lines(cp_cah_id IN NUMBER) IS
438: SELECT sty_id, add_yn
439: FROM okl_srch_strm_typs
440: WHERE cah_id = cp_cah_id;
441:
442: ----------
443: