APPS.CSM_ACC_PKG dependencies on JTF_RS_RESOURCE_EXTNS

Line 182: l_resource_id jtf_rs_resource_extns.resource_id%TYPE;

178: l_pk1_string VARCHAR2(4000);
179: l_pk2_string VARCHAR2(4000);
180: l_pk3_string VARCHAR2(4000);
181: l_rc BOOLEAN;
182: l_resource_id jtf_rs_resource_extns.resource_id%TYPE;
183: BEGIN
184: /*** insert new ACC record for current resource ***/
185: l_access_id := Get_Acc_Id
186: ( p_acc_table_name => p_acc_table_name

Line 372: l_resource_id jtf_rs_resource_extns.resource_id%TYPE;

368: l_pk_err_msg_txt VARCHAR2(4000);
369: l_count_value NUMBER;
370: l_rc BOOLEAN;
371: l_index NUMBER;
372: l_resource_id jtf_rs_resource_extns.resource_id%TYPE;
373: BEGIN
374: IF p_pk1_date_value IS null THEN
375: l_pk1_value := NVL( TO_CHAR(p_pk1_num_value ), p_pk1_char_value );
376: l_pk1_string:= ':P1';

Line 554: l_resource_id jtf_rs_resource_extns.resource_id%TYPE;

550: ,p_access_id in NUMBER
551: )
552: IS
553: l_rc BOOLEAN;
554: l_resource_id jtf_rs_resource_extns.resource_id%TYPE;
555: BEGIN
556: --get the resource id
557: OPEN c_get_resource(p_user_id);
558: FETCH c_get_resource INTO l_resource_id;