402: l_msg_count NUMBER;
403: l_msg_data VARCHAR2(2000);
404: l_return_status VARCHAR2(10);
405: l_resource_id JTF_NUMBER_TABLE := JTF_NUMBER_TABLE();
406: l_resource_type JTF_VARCHAR2_TABLE_100 := JTF_VARCHAR2_TABLE_100();
407: l_count number := 0;
408: i number := 0;
409: l_current_rec number := 0;
410: l_temp number := 0;
449: DECLARE
450:
451: l_sr_rec CS_SR_SECURITY_GRP.sr_rec_type;
452: l_resource_id JTF_NUMBER_TABLE := JTF_NUMBER_TABLE();
453: l_resource_type JTF_VARCHAR2_TABLE_100 := JTF_VARCHAR2_TABLE_100();
454: l_return_status VARCHAR2(10);
455: l_msg_count NUMBER;
456: l_msg_data VARCHAR2(2000);
457: l_sr_resource_tbl CS_SR_SECURITY_GRP.RESOURCE_VALIDATE_TBL_TYPE := CS_SR_SECURITY_GRP.RESOURCE_VALIDATE_TBL_TYPE();
510: l_indx := l_sr_resource_tbl.first;
511: l_resource_id.delete;
512: l_resource_type.delete;
513: l_resource_id := JTF_NUMBER_TABLE();
514: l_resource_type := JTF_VARCHAR2_TABLE_100();
515:
516: IF(l_sr_resource_tbl.count > 0)
517: THEN
518: l_resource_id.extend(l_sr_resource_tbl.count);