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 43: (p_category_id IN jtf_rs_resource_skills.category_id%TYPE,

39: logic.
40: ******************************************************************************/
41:
42: PROCEDURE get_resources_by_skill
43: (p_category_id IN jtf_rs_resource_skills.category_id%TYPE,
44: p_subcategory IN jtf_rs_resource_skills.subcategory%TYPE,
45: p_product_id IN jtf_rs_resource_skills.product_id%TYPE,
46: p_product_org_id IN jtf_rs_resource_skills.product_org_id%TYPE,
47: p_component_id IN jtf_rs_resource_skills.component_id%TYPE,

Line 44: p_subcategory IN jtf_rs_resource_skills.subcategory%TYPE,

40: ******************************************************************************/
41:
42: PROCEDURE get_resources_by_skill
43: (p_category_id IN jtf_rs_resource_skills.category_id%TYPE,
44: p_subcategory IN jtf_rs_resource_skills.subcategory%TYPE,
45: p_product_id IN jtf_rs_resource_skills.product_id%TYPE,
46: p_product_org_id IN jtf_rs_resource_skills.product_org_id%TYPE,
47: p_component_id IN jtf_rs_resource_skills.component_id%TYPE,
48: p_subcomponent_id IN jtf_rs_resource_skills.subcomponent_id%TYPE,

Line 45: p_product_id IN jtf_rs_resource_skills.product_id%TYPE,

41:
42: PROCEDURE get_resources_by_skill
43: (p_category_id IN jtf_rs_resource_skills.category_id%TYPE,
44: p_subcategory IN jtf_rs_resource_skills.subcategory%TYPE,
45: p_product_id IN jtf_rs_resource_skills.product_id%TYPE,
46: p_product_org_id IN jtf_rs_resource_skills.product_org_id%TYPE,
47: p_component_id IN jtf_rs_resource_skills.component_id%TYPE,
48: p_subcomponent_id IN jtf_rs_resource_skills.subcomponent_id%TYPE,
49: p_platform_id IN jtf_rs_resource_skills.platform_id%TYPE,

Line 46: p_product_org_id IN jtf_rs_resource_skills.product_org_id%TYPE,

42: PROCEDURE get_resources_by_skill
43: (p_category_id IN jtf_rs_resource_skills.category_id%TYPE,
44: p_subcategory IN jtf_rs_resource_skills.subcategory%TYPE,
45: p_product_id IN jtf_rs_resource_skills.product_id%TYPE,
46: p_product_org_id IN jtf_rs_resource_skills.product_org_id%TYPE,
47: p_component_id IN jtf_rs_resource_skills.component_id%TYPE,
48: p_subcomponent_id IN jtf_rs_resource_skills.subcomponent_id%TYPE,
49: p_platform_id IN jtf_rs_resource_skills.platform_id%TYPE,
50: p_platform_org_id IN jtf_rs_resource_skills.platform_org_id%TYPE,

Line 47: p_component_id IN jtf_rs_resource_skills.component_id%TYPE,

43: (p_category_id IN jtf_rs_resource_skills.category_id%TYPE,
44: p_subcategory IN jtf_rs_resource_skills.subcategory%TYPE,
45: p_product_id IN jtf_rs_resource_skills.product_id%TYPE,
46: p_product_org_id IN jtf_rs_resource_skills.product_org_id%TYPE,
47: p_component_id IN jtf_rs_resource_skills.component_id%TYPE,
48: p_subcomponent_id IN jtf_rs_resource_skills.subcomponent_id%TYPE,
49: p_platform_id IN jtf_rs_resource_skills.platform_id%TYPE,
50: p_platform_org_id IN jtf_rs_resource_skills.platform_org_id%TYPE,
51: p_problem_code IN jtf_rs_resource_skills.problem_code%TYPE,

Line 48: p_subcomponent_id IN jtf_rs_resource_skills.subcomponent_id%TYPE,

44: p_subcategory IN jtf_rs_resource_skills.subcategory%TYPE,
45: p_product_id IN jtf_rs_resource_skills.product_id%TYPE,
46: p_product_org_id IN jtf_rs_resource_skills.product_org_id%TYPE,
47: p_component_id IN jtf_rs_resource_skills.component_id%TYPE,
48: p_subcomponent_id IN jtf_rs_resource_skills.subcomponent_id%TYPE,
49: p_platform_id IN jtf_rs_resource_skills.platform_id%TYPE,
50: p_platform_org_id IN jtf_rs_resource_skills.platform_org_id%TYPE,
51: p_problem_code IN jtf_rs_resource_skills.problem_code%TYPE,
52: p_skill_level_id IN jtf_rs_resource_skills.skill_level_id%TYPE,

Line 49: p_platform_id IN jtf_rs_resource_skills.platform_id%TYPE,

45: p_product_id IN jtf_rs_resource_skills.product_id%TYPE,
46: p_product_org_id IN jtf_rs_resource_skills.product_org_id%TYPE,
47: p_component_id IN jtf_rs_resource_skills.component_id%TYPE,
48: p_subcomponent_id IN jtf_rs_resource_skills.subcomponent_id%TYPE,
49: p_platform_id IN jtf_rs_resource_skills.platform_id%TYPE,
50: p_platform_org_id IN jtf_rs_resource_skills.platform_org_id%TYPE,
51: p_problem_code IN jtf_rs_resource_skills.problem_code%TYPE,
52: p_skill_level_id IN jtf_rs_resource_skills.skill_level_id%TYPE,
53: x_get_resources_tbl OUT NOCOPY jtf_rs_integration_pub.Resource_table_type,

Line 50: p_platform_org_id IN jtf_rs_resource_skills.platform_org_id%TYPE,

46: p_product_org_id IN jtf_rs_resource_skills.product_org_id%TYPE,
47: p_component_id IN jtf_rs_resource_skills.component_id%TYPE,
48: p_subcomponent_id IN jtf_rs_resource_skills.subcomponent_id%TYPE,
49: p_platform_id IN jtf_rs_resource_skills.platform_id%TYPE,
50: p_platform_org_id IN jtf_rs_resource_skills.platform_org_id%TYPE,
51: p_problem_code IN jtf_rs_resource_skills.problem_code%TYPE,
52: p_skill_level_id IN jtf_rs_resource_skills.skill_level_id%TYPE,
53: x_get_resources_tbl OUT NOCOPY jtf_rs_integration_pub.Resource_table_type,
54: x_return_status OUT NOCOPY VARCHAR2

Line 51: p_problem_code IN jtf_rs_resource_skills.problem_code%TYPE,

47: p_component_id IN jtf_rs_resource_skills.component_id%TYPE,
48: p_subcomponent_id IN jtf_rs_resource_skills.subcomponent_id%TYPE,
49: p_platform_id IN jtf_rs_resource_skills.platform_id%TYPE,
50: p_platform_org_id IN jtf_rs_resource_skills.platform_org_id%TYPE,
51: p_problem_code IN jtf_rs_resource_skills.problem_code%TYPE,
52: p_skill_level_id IN jtf_rs_resource_skills.skill_level_id%TYPE,
53: x_get_resources_tbl OUT NOCOPY jtf_rs_integration_pub.Resource_table_type,
54: x_return_status OUT NOCOPY VARCHAR2
55: ) IS

Line 52: p_skill_level_id IN jtf_rs_resource_skills.skill_level_id%TYPE,

48: p_subcomponent_id IN jtf_rs_resource_skills.subcomponent_id%TYPE,
49: p_platform_id IN jtf_rs_resource_skills.platform_id%TYPE,
50: p_platform_org_id IN jtf_rs_resource_skills.platform_org_id%TYPE,
51: p_problem_code IN jtf_rs_resource_skills.problem_code%TYPE,
52: p_skill_level_id IN jtf_rs_resource_skills.skill_level_id%TYPE,
53: x_get_resources_tbl OUT NOCOPY jtf_rs_integration_pub.Resource_table_type,
54: x_return_status OUT NOCOPY VARCHAR2
55: ) IS
56:

Line 80: l_select := 'SELECT distinct resource_id from jtf_rs_resource_skills ';

76: BEGIN
77:
78: l_api_name := 'GET_RESOURCES_BY_SKILL';
79: x_return_status := fnd_api.g_ret_sts_success;
80: l_select := 'SELECT distinct resource_id from jtf_rs_resource_skills ';
81: l_where := NULL;
82: i := 1;
83:
84: /* BINDVAR_SCAN_IGNORE [57] */