DBA Data[Home] [Help]

APPS.OKL_CSH_ALLCT_RULES_PVT dependencies on OKL_CSH_ALLCT_SRCHS

Line 28: l_allct_name OKL_CSH_ALLCT_SRCHS.NAME%TYPE;

24: l_return_status VARCHAR2(1);
25: l_msg_count NUMBER;
26: l_msg_data VARCHAR2(2000);
27: i NUMBER;
28: l_allct_name OKL_CSH_ALLCT_SRCHS.NAME%TYPE;
29: l_allct_id OKL_CSH_ALLCT_SRCHS.ID%TYPE;
30: l_del_ext EXCEPTION;
31:
32: ------------------------------

Line 29: l_allct_id OKL_CSH_ALLCT_SRCHS.ID%TYPE;

25: l_msg_count NUMBER;
26: l_msg_data VARCHAR2(2000);
27: i NUMBER;
28: l_allct_name OKL_CSH_ALLCT_SRCHS.NAME%TYPE;
29: l_allct_id OKL_CSH_ALLCT_SRCHS.ID%TYPE;
30: l_del_ext EXCEPTION;
31:
32: ------------------------------
33: -- DECLARE Record/Table Types

Line 49: -- FROM OKL_CSH_ALLCT_SRCHS_V cas

45: -------------------
46: -- Get the ID given the name of the rule
47: -- CURSOR c_csh_allct_srchs_id (cp_rule_name IN VARCHAR2) IS
48: -- SELECT cas.ID
49: -- FROM OKL_CSH_ALLCT_SRCHS_V cas
50: -- WHERE cas.NAME = cp_rule_name;
51:
52: -- Get the ID of the combination given the CAH_ID
53: CURSOR c_srch_strm_typs_id (cp_rule_id IN NUMBER) IS

Line 104: Okl_Csh_Allct_Srchs_Pub.delete_csh_allct_srchs(l_api_version

100:
101: l_cahv_rec.ID := l_allct_id;
102:
103:
104: Okl_Csh_Allct_Srchs_Pub.delete_csh_allct_srchs(l_api_version
105: ,l_init_msg_list
106: ,l_return_status
107: ,l_msg_count
108: ,l_msg_data