DBA Data[Home] [Help]

APPS.JTF_AM_FILTER_RESOURCE_PVT dependencies on JTF_VARCHAR2_TABLE_100

Line 406: l_resource_type JTF_VARCHAR2_TABLE_100 := JTF_VARCHAR2_TABLE_100();

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;

Line 453: l_resource_type JTF_VARCHAR2_TABLE_100 := JTF_VARCHAR2_TABLE_100();

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();

Line 514: l_resource_type := JTF_VARCHAR2_TABLE_100();

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);