eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.JTF_RS_INTEGRATION_PUB dependencies on JTF_RS_RESOURCE_SKILLS

Line 59: (p_category_id IN jtf_rs_resource_skills.category_id%TYPE,

55: * @rep:displayname Get resources based on skill
56: */
57:
58: PROCEDURE get_resources_by_skill
59: (p_category_id IN jtf_rs_resource_skills.category_id%TYPE,
60: p_subcategory IN jtf_rs_resource_skills.subcategory%TYPE,
61: p_product_id IN jtf_rs_resource_skills.product_id%TYPE,
62: p_product_org_id IN jtf_rs_resource_skills.product_org_id%TYPE,
63: p_component_id IN jtf_rs_resource_skills.component_id%TYPE,

Line 60: p_subcategory IN jtf_rs_resource_skills.subcategory%TYPE,

56: */
57:
58: PROCEDURE get_resources_by_skill
59: (p_category_id IN jtf_rs_resource_skills.category_id%TYPE,
60: p_subcategory IN jtf_rs_resource_skills.subcategory%TYPE,
61: p_product_id IN jtf_rs_resource_skills.product_id%TYPE,
62: p_product_org_id IN jtf_rs_resource_skills.product_org_id%TYPE,
63: p_component_id IN jtf_rs_resource_skills.component_id%TYPE,
64: p_subcomponent_id IN jtf_rs_resource_skills.subcomponent_id%TYPE,

Line 61: p_product_id IN jtf_rs_resource_skills.product_id%TYPE,

57:
58: PROCEDURE get_resources_by_skill
59: (p_category_id IN jtf_rs_resource_skills.category_id%TYPE,
60: p_subcategory IN jtf_rs_resource_skills.subcategory%TYPE,
61: p_product_id IN jtf_rs_resource_skills.product_id%TYPE,
62: p_product_org_id IN jtf_rs_resource_skills.product_org_id%TYPE,
63: p_component_id IN jtf_rs_resource_skills.component_id%TYPE,
64: p_subcomponent_id IN jtf_rs_resource_skills.subcomponent_id%TYPE,
65: p_platform_id IN jtf_rs_resource_skills.platform_id%TYPE,

Line 62: p_product_org_id IN jtf_rs_resource_skills.product_org_id%TYPE,

58: PROCEDURE get_resources_by_skill
59: (p_category_id IN jtf_rs_resource_skills.category_id%TYPE,
60: p_subcategory IN jtf_rs_resource_skills.subcategory%TYPE,
61: p_product_id IN jtf_rs_resource_skills.product_id%TYPE,
62: p_product_org_id IN jtf_rs_resource_skills.product_org_id%TYPE,
63: p_component_id IN jtf_rs_resource_skills.component_id%TYPE,
64: p_subcomponent_id IN jtf_rs_resource_skills.subcomponent_id%TYPE,
65: p_platform_id IN jtf_rs_resource_skills.platform_id%TYPE,
66: p_platform_org_id IN jtf_rs_resource_skills.platform_org_id%TYPE,

Line 63: p_component_id IN jtf_rs_resource_skills.component_id%TYPE,

59: (p_category_id IN jtf_rs_resource_skills.category_id%TYPE,
60: p_subcategory IN jtf_rs_resource_skills.subcategory%TYPE,
61: p_product_id IN jtf_rs_resource_skills.product_id%TYPE,
62: p_product_org_id IN jtf_rs_resource_skills.product_org_id%TYPE,
63: p_component_id IN jtf_rs_resource_skills.component_id%TYPE,
64: p_subcomponent_id IN jtf_rs_resource_skills.subcomponent_id%TYPE,
65: p_platform_id IN jtf_rs_resource_skills.platform_id%TYPE,
66: p_platform_org_id IN jtf_rs_resource_skills.platform_org_id%TYPE,
67: p_problem_code IN jtf_rs_resource_skills.problem_code%TYPE,

Line 64: p_subcomponent_id IN jtf_rs_resource_skills.subcomponent_id%TYPE,

60: p_subcategory IN jtf_rs_resource_skills.subcategory%TYPE,
61: p_product_id IN jtf_rs_resource_skills.product_id%TYPE,
62: p_product_org_id IN jtf_rs_resource_skills.product_org_id%TYPE,
63: p_component_id IN jtf_rs_resource_skills.component_id%TYPE,
64: p_subcomponent_id IN jtf_rs_resource_skills.subcomponent_id%TYPE,
65: p_platform_id IN jtf_rs_resource_skills.platform_id%TYPE,
66: p_platform_org_id IN jtf_rs_resource_skills.platform_org_id%TYPE,
67: p_problem_code IN jtf_rs_resource_skills.problem_code%TYPE,
68: p_skill_level_id IN jtf_rs_resource_skills.skill_level_id%TYPE,

Line 65: p_platform_id IN jtf_rs_resource_skills.platform_id%TYPE,

61: p_product_id IN jtf_rs_resource_skills.product_id%TYPE,
62: p_product_org_id IN jtf_rs_resource_skills.product_org_id%TYPE,
63: p_component_id IN jtf_rs_resource_skills.component_id%TYPE,
64: p_subcomponent_id IN jtf_rs_resource_skills.subcomponent_id%TYPE,
65: p_platform_id IN jtf_rs_resource_skills.platform_id%TYPE,
66: p_platform_org_id IN jtf_rs_resource_skills.platform_org_id%TYPE,
67: p_problem_code IN jtf_rs_resource_skills.problem_code%TYPE,
68: p_skill_level_id IN jtf_rs_resource_skills.skill_level_id%TYPE,
69: x_get_resources_tbl OUT NOCOPY jtf_rs_integration_pub.Resource_table_type,

Line 66: p_platform_org_id IN jtf_rs_resource_skills.platform_org_id%TYPE,

62: p_product_org_id IN jtf_rs_resource_skills.product_org_id%TYPE,
63: p_component_id IN jtf_rs_resource_skills.component_id%TYPE,
64: p_subcomponent_id IN jtf_rs_resource_skills.subcomponent_id%TYPE,
65: p_platform_id IN jtf_rs_resource_skills.platform_id%TYPE,
66: p_platform_org_id IN jtf_rs_resource_skills.platform_org_id%TYPE,
67: p_problem_code IN jtf_rs_resource_skills.problem_code%TYPE,
68: p_skill_level_id IN jtf_rs_resource_skills.skill_level_id%TYPE,
69: x_get_resources_tbl OUT NOCOPY jtf_rs_integration_pub.Resource_table_type,
70: x_return_status OUT NOCOPY VARCHAR2

Line 67: p_problem_code IN jtf_rs_resource_skills.problem_code%TYPE,

63: p_component_id IN jtf_rs_resource_skills.component_id%TYPE,
64: p_subcomponent_id IN jtf_rs_resource_skills.subcomponent_id%TYPE,
65: p_platform_id IN jtf_rs_resource_skills.platform_id%TYPE,
66: p_platform_org_id IN jtf_rs_resource_skills.platform_org_id%TYPE,
67: p_problem_code IN jtf_rs_resource_skills.problem_code%TYPE,
68: p_skill_level_id IN jtf_rs_resource_skills.skill_level_id%TYPE,
69: x_get_resources_tbl OUT NOCOPY jtf_rs_integration_pub.Resource_table_type,
70: x_return_status OUT NOCOPY VARCHAR2
71: );

Line 68: p_skill_level_id IN jtf_rs_resource_skills.skill_level_id%TYPE,

64: p_subcomponent_id IN jtf_rs_resource_skills.subcomponent_id%TYPE,
65: p_platform_id IN jtf_rs_resource_skills.platform_id%TYPE,
66: p_platform_org_id IN jtf_rs_resource_skills.platform_org_id%TYPE,
67: p_problem_code IN jtf_rs_resource_skills.problem_code%TYPE,
68: p_skill_level_id IN jtf_rs_resource_skills.skill_level_id%TYPE,
69: x_get_resources_tbl OUT NOCOPY jtf_rs_integration_pub.Resource_table_type,
70: x_return_status OUT NOCOPY VARCHAR2
71: );
72: