DBA Data[Home] [Help]

APPS.JTF_RS_JSP_LOV_RECS_PUB dependencies on JTF_RESOURCE_UTL

Line 542: l_org_id := jtf_resource_utl.get_inventory_org_id();

538: x_lov_ak_region := 'JTF_RS_PRODUCTS_LOV_REGION';
539: -- Product field
540: l_display_value := UPPER(l_in_filter_lov_rec.display_value) || '%';
541:
542: l_org_id := jtf_resource_utl.get_inventory_org_id();
543:
544: l_aux_value1 := l_in_filter_lov_rec.aux_value1;
545:
546: if l_aux_value1 is null then

Line 619: l_org_id := jtf_resource_utl.get_inventory_org_id();

615: x_lov_ak_region := 'JTF_RS_PLATFORMS_LOV_REGION';
616: -- Product field
617: l_display_value := UPPER(l_in_filter_lov_rec.display_value) || '%';
618:
619: l_org_id := jtf_resource_utl.get_inventory_org_id();
620:
621: l_aux_value1 := l_in_filter_lov_rec.aux_value1;
622:
623: if l_aux_value1 is null then

Line 724: l_org_id := jtf_resource_utl.get_inventory_org_id();

720: l_display_value := UPPER(l_in_filter_lov_rec.display_value) || '%';
721: -- filter input product id
722: l_aux_value1 := l_in_filter_lov_rec.aux_value1;
723:
724: l_org_id := jtf_resource_utl.get_inventory_org_id();
725:
726: if l_aux_value1 is null then
727:
728: OPEN lov_output_cur FOR

Line 769: l_org_id := jtf_resource_utl.get_inventory_org_id();

765: l_display_value := UPPER(l_in_filter_lov_rec.display_value) || '%';
766: -- filter input product id
767: l_aux_value1 := l_in_filter_lov_rec.aux_value1;
768:
769: l_org_id := jtf_resource_utl.get_inventory_org_id();
770:
771: if l_aux_value1 is null then
772: OPEN lov_output_cur FOR
773: ' select null, null, null, null, null, null, null, null, null, null '||