APPS.CSF_UTIL_PVT dependencies on CSF_RESOURCE_PUB

Line 289: OPEN c_plan_terr(csf_resource_pub.resource_id(l_user_id));

285: l_terr_table(l_terr_table.LAST) := l_selected_terr;
286: END IF;
287: ELSE
288: -- If the user has selected territories.. then return those.
289: OPEN c_plan_terr(csf_resource_pub.resource_id(l_user_id));
290: FETCH c_plan_terr BULK COLLECT INTO l_terr_table;
291: CLOSE c_plan_terr;
292:
293: -- The given user is not attached to any Planner Group.

Line 547: * @deprecated Use CSF_RESOURCE_PUB.GET_RES_QUALIFIER_TABLE

543: * (Deprecated) Retained because Service Team is still using it.
544: * Returns the Qualifier Table having the list of valid Qualifiers
545: * based on the Task Information of the given Task ID.
546: *
547: * @deprecated Use CSF_RESOURCE_PUB.GET_RES_QUALIFIER_TABLE
548: */
549: FUNCTION get_qualifier_table ( p_task_id NUMBER )
550: RETURN csf_resource_pub.resource_qualifier_tbl_type IS
551: BEGIN

Line 550: RETURN csf_resource_pub.resource_qualifier_tbl_type IS

546: *
547: * @deprecated Use CSF_RESOURCE_PUB.GET_RES_QUALIFIER_TABLE
548: */
549: FUNCTION get_qualifier_table ( p_task_id NUMBER )
550: RETURN csf_resource_pub.resource_qualifier_tbl_type IS
551: BEGIN
552: RETURN csf_resource_pub.get_res_qualifier_table(p_task_id);
553: END get_qualifier_table;
554:

Line 552: RETURN csf_resource_pub.get_res_qualifier_table(p_task_id);

548: */
549: FUNCTION get_qualifier_table ( p_task_id NUMBER )
550: RETURN csf_resource_pub.resource_qualifier_tbl_type IS
551: BEGIN
552: RETURN csf_resource_pub.get_res_qualifier_table(p_task_id);
553: END get_qualifier_table;
554:
555: FUNCTION get_query_where(p_query_id NUMBER)
556: RETURN VARCHAR2 IS

Line 586: || ' and owner_id = ' || csf_resource_pub.resource_id

582: IF (l_query_info.owner_enabled_flag IN ('Y', 'y')) THEN
583: IF (l_query_info.owners_count = 0) THEN
584: l_query_info.where_clause :=
585: l_query_info.where_clause
586: || ' and owner_id = ' || csf_resource_pub.resource_id
587: || ' and owner_type_code = ''' || csf_resource_pub.resource_type || '''';
588: ELSE
589: l_query_info.where_clause :=
590: l_query_info.where_clause

Line 587: || ' and owner_type_code = ''' || csf_resource_pub.resource_type || '''';

583: IF (l_query_info.owners_count = 0) THEN
584: l_query_info.where_clause :=
585: l_query_info.where_clause
586: || ' and owner_id = ' || csf_resource_pub.resource_id
587: || ' and owner_type_code = ''' || csf_resource_pub.resource_type || '''';
588: ELSE
589: l_query_info.where_clause :=
590: l_query_info.where_clause
591: || ' AND (owner_id, owner_type_code)