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_RESOURCE_SKILLS_PVT dependencies on JTF_RS_RESOURCE_SKILLS_S

Line 25: P_SKILL_LEVEL_ID IN JTF_RS_RESOURCE_SKILLS.SKILL_LEVEL_ID%TYPE,

21: (P_API_VERSION IN NUMBER,
22: P_INIT_MSG_LIST IN VARCHAR2,
23: P_COMMIT IN VARCHAR2,
24: P_RESOURCE_ID IN JTF_RS_RESOURCE_SKILLS.RESOURCE_ID%TYPE,
25: P_SKILL_LEVEL_ID IN JTF_RS_RESOURCE_SKILLS.SKILL_LEVEL_ID%TYPE,
26: P_CATEGORY_ID IN JTF_RS_RESOURCE_SKILLS.CATEGORY_ID%TYPE,
27: P_SUBCATEGORY IN JTF_RS_RESOURCE_SKILLS.SUBCATEGORY%TYPE,
28: P_PRODUCT_ID IN JTF_RS_RESOURCE_SKILLS.PRODUCT_ID%TYPE,
29: P_PRODUCT_ORG_ID IN JTF_RS_RESOURCE_SKILLS.PRODUCT_ORG_ID%TYPE,

Line 27: P_SUBCATEGORY IN JTF_RS_RESOURCE_SKILLS.SUBCATEGORY%TYPE,

23: P_COMMIT IN VARCHAR2,
24: P_RESOURCE_ID IN JTF_RS_RESOURCE_SKILLS.RESOURCE_ID%TYPE,
25: P_SKILL_LEVEL_ID IN JTF_RS_RESOURCE_SKILLS.SKILL_LEVEL_ID%TYPE,
26: P_CATEGORY_ID IN JTF_RS_RESOURCE_SKILLS.CATEGORY_ID%TYPE,
27: P_SUBCATEGORY IN JTF_RS_RESOURCE_SKILLS.SUBCATEGORY%TYPE,
28: P_PRODUCT_ID IN JTF_RS_RESOURCE_SKILLS.PRODUCT_ID%TYPE,
29: P_PRODUCT_ORG_ID IN JTF_RS_RESOURCE_SKILLS.PRODUCT_ORG_ID%TYPE,
30: P_PLATFORM_ID IN JTF_RS_RESOURCE_SKILLS.PLATFORM_ID%TYPE,
31: P_PLATFORM_ORG_ID IN JTF_RS_RESOURCE_SKILLS.PLATFORM_ORG_ID%TYPE,

Line 34: P_SUBCOMPONENT_ID IN JTF_RS_RESOURCE_SKILLS.SUBCOMPONENT_ID%TYPE,

30: P_PLATFORM_ID IN JTF_RS_RESOURCE_SKILLS.PLATFORM_ID%TYPE,
31: P_PLATFORM_ORG_ID IN JTF_RS_RESOURCE_SKILLS.PLATFORM_ORG_ID%TYPE,
32: P_PROBLEM_CODE IN JTF_RS_RESOURCE_SKILLS.PROBLEM_CODE%TYPE,
33: P_COMPONENT_ID IN JTF_RS_RESOURCE_SKILLS.COMPONENT_ID%TYPE,
34: P_SUBCOMPONENT_ID IN JTF_RS_RESOURCE_SKILLS.SUBCOMPONENT_ID%TYPE,
35: P_ATTRIBUTE1 IN JTF_RS_RESOURCE_SKILLS.ATTRIBUTE1%TYPE,
36: P_ATTRIBUTE2 IN JTF_RS_RESOURCE_SKILLS.ATTRIBUTE2%TYPE,
37: P_ATTRIBUTE3 IN JTF_RS_RESOURCE_SKILLS.ATTRIBUTE3%TYPE,
38: P_ATTRIBUTE4 IN JTF_RS_RESOURCE_SKILLS.ATTRIBUTE4%TYPE,

Line 82: CURSOR skill_level_id_cur(ll_skill_level_id JTF_RS_RESOURCE_SKILLS.SKILL_LEVEL_ID%TYPE)

78:
79: resource_id_rec resource_id_cur%rowtype;
80:
81: -- Check Skill_level_id is valid
82: CURSOR skill_level_id_cur(ll_skill_level_id JTF_RS_RESOURCE_SKILLS.SKILL_LEVEL_ID%TYPE)
83: IS
84: SELECT skill_level_id
85: FROM JTF_RS_SKILL_LEVELS_B
86: WHERE skill_level_id = ll_skill_level_id;

Line 117: CURSOR subcategory_cur(ll_subcategory JTF_RS_RESOURCE_SKILLS.SUBCATEGORY%TYPE)

113:
114: category_catset_id_rec category_catset_id_cur%rowtype;
115:
116: -- Check subcategory is valid
117: CURSOR subcategory_cur(ll_subcategory JTF_RS_RESOURCE_SKILLS.SUBCATEGORY%TYPE)
118: IS
119: SELECT lookup_code, meaning
120: FROM FND_LOOKUPS
121: WHERE lookup_type = 'JTF_RS_SKILL_CAT_TYPE'

Line 226: lpd_subcategory JTF_RS_RESOURCE_SKILLS.subcategory%TYPE,

222:
223: -- Duplicate cursor check for product
224: CURSOR product_dup_cur (lpd_resource_id JTF_RS_RESOURCE_SKILLS.resource_id%TYPE,
225: lpd_category_id JTF_RS_RESOURCE_SKILLS.category_id%TYPE,
226: lpd_subcategory JTF_RS_RESOURCE_SKILLS.subcategory%TYPE,
227: lpd_product_id JTF_RS_RESOURCE_SKILLS.product_id%TYPE,
228: lpd_component_id JTF_RS_RESOURCE_SKILLS.component_id%TYPE,
229: lpd_problem_code JTF_RS_RESOURCE_SKILLS.problem_code%TYPE,
230: lpd_product_org_id JTF_RS_RESOURCE_SKILLS.product_org_id%TYPE)

Line 247: lpt_subcategory JTF_RS_RESOURCE_SKILLS.subcategory%TYPE,

243:
244: -- Duplicate cursor check for platform
245: CURSOR platform_dup_cur (lpt_resource_id JTF_RS_RESOURCE_SKILLS.resource_id%TYPE,
246: lpt_category_id JTF_RS_RESOURCE_SKILLS.category_id%TYPE,
247: lpt_subcategory JTF_RS_RESOURCE_SKILLS.subcategory%TYPE,
248: lpt_platform_id JTF_RS_RESOURCE_SKILLS.platform_id%TYPE,
249: lpt_platform_org_id JTF_RS_RESOURCE_SKILLS.platform_org_id%TYPE)
250: IS
251: SELECT resource_skill_id

Line 264: lpc_subcategory JTF_RS_RESOURCE_SKILLS.subcategory%TYPE,

260:
261: -- Duplicate cursor check for problem_code
262: CURSOR problem_code_dup_cur (lpc_resource_id JTF_RS_RESOURCE_SKILLS.resource_id%TYPE,
263: lpc_category_id JTF_RS_RESOURCE_SKILLS.category_id%TYPE,
264: lpc_subcategory JTF_RS_RESOURCE_SKILLS.subcategory%TYPE,
265: lpc_problem_code JTF_RS_RESOURCE_SKILLS.problem_code%TYPE)
266: IS
267: SELECT resource_skill_id
268: FROM JTF_RS_RESOURCE_SKILLS

Line 626: SELECT jtf_rs_resource_skills_s.nextval

622: -----------------------------------------------------------------------
623:
624: IF (l_go_ahead = 'YES') THEN
625:
626: SELECT jtf_rs_resource_skills_s.nextval
627: INTO l_resource_skill_id
628: FROM dual;
629:
630: JTF_RS_RESOURCE_SKILLS_PKG.INSERT_ROW(

Line 720: P_SKILL_LEVEL_ID IN JTF_RS_RESOURCE_SKILLS.SKILL_LEVEL_ID%TYPE,

716: P_INIT_MSG_LIST IN VARCHAR2,
717: P_COMMIT IN VARCHAR2,
718: P_RESOURCE_SKILL_ID IN JTF_RS_RESOURCE_SKILLS.RESOURCE_SKILL_ID%TYPE,
719: P_RESOURCE_ID IN JTF_RS_RESOURCE_SKILLS.RESOURCE_ID%TYPE,
720: P_SKILL_LEVEL_ID IN JTF_RS_RESOURCE_SKILLS.SKILL_LEVEL_ID%TYPE,
721: P_CATEGORY_ID IN JTF_RS_RESOURCE_SKILLS.CATEGORY_ID%TYPE,
722: P_SUBCATEGORY IN JTF_RS_RESOURCE_SKILLS.SUBCATEGORY%TYPE,
723: P_PRODUCT_ID IN JTF_RS_RESOURCE_SKILLS.PRODUCT_ID%TYPE,
724: P_PRODUCT_ORG_ID IN JTF_RS_RESOURCE_SKILLS.PRODUCT_ORG_ID%TYPE,

Line 722: P_SUBCATEGORY IN JTF_RS_RESOURCE_SKILLS.SUBCATEGORY%TYPE,

718: P_RESOURCE_SKILL_ID IN JTF_RS_RESOURCE_SKILLS.RESOURCE_SKILL_ID%TYPE,
719: P_RESOURCE_ID IN JTF_RS_RESOURCE_SKILLS.RESOURCE_ID%TYPE,
720: P_SKILL_LEVEL_ID IN JTF_RS_RESOURCE_SKILLS.SKILL_LEVEL_ID%TYPE,
721: P_CATEGORY_ID IN JTF_RS_RESOURCE_SKILLS.CATEGORY_ID%TYPE,
722: P_SUBCATEGORY IN JTF_RS_RESOURCE_SKILLS.SUBCATEGORY%TYPE,
723: P_PRODUCT_ID IN JTF_RS_RESOURCE_SKILLS.PRODUCT_ID%TYPE,
724: P_PRODUCT_ORG_ID IN JTF_RS_RESOURCE_SKILLS.PRODUCT_ORG_ID%TYPE,
725: P_PLATFORM_ID IN JTF_RS_RESOURCE_SKILLS.PLATFORM_ID%TYPE,
726: P_PLATFORM_ORG_ID IN JTF_RS_RESOURCE_SKILLS.PLATFORM_ORG_ID%TYPE,

Line 729: P_SUBCOMPONENT_ID IN JTF_RS_RESOURCE_SKILLS.SUBCOMPONENT_ID%TYPE,

725: P_PLATFORM_ID IN JTF_RS_RESOURCE_SKILLS.PLATFORM_ID%TYPE,
726: P_PLATFORM_ORG_ID IN JTF_RS_RESOURCE_SKILLS.PLATFORM_ORG_ID%TYPE,
727: P_PROBLEM_CODE IN JTF_RS_RESOURCE_SKILLS.PROBLEM_CODE%TYPE,
728: P_COMPONENT_ID IN JTF_RS_RESOURCE_SKILLS.COMPONENT_ID%TYPE,
729: P_SUBCOMPONENT_ID IN JTF_RS_RESOURCE_SKILLS.SUBCOMPONENT_ID%TYPE,
730: P_OBJECT_VERSION_NUM IN OUT NOCOPY JTF_RS_RESOURCE_SKILLS.OBJECT_VERSION_NUMBER%TYPE,
731: P_ATTRIBUTE1 IN JTF_RS_RESOURCE_SKILLS.ATTRIBUTE1%TYPE,
732: P_ATTRIBUTE2 IN JTF_RS_RESOURCE_SKILLS.ATTRIBUTE2%TYPE,
733: P_ATTRIBUTE3 IN JTF_RS_RESOURCE_SKILLS.ATTRIBUTE3%TYPE,

Line 821: l_skill_level_id JTF_RS_RESOURCE_SKILLS.SKILL_LEVEL_ID%TYPE := p_skill_level_id;

817: resource_skills_rec resource_skills_cur%rowtype;
818:
819: l_resource_skill_id JTF_RS_RESOURCE_SKILLS.RESOURCE_SKILL_ID%TYPE := p_resource_skill_id;
820: l_resource_id JTF_RS_RESOURCE_SKILLS.RESOURCE_ID%TYPE := p_resource_id;
821: l_skill_level_id JTF_RS_RESOURCE_SKILLS.SKILL_LEVEL_ID%TYPE := p_skill_level_id;
822: l_category_id JTF_RS_RESOURCE_SKILLS.CATEGORY_ID%TYPE := p_category_id;
823: l_subcategory JTF_RS_RESOURCE_SKILLS.SUBCATEGORY%TYPE := p_subcategory;
824: l_product_id JTF_RS_RESOURCE_SKILLS.PRODUCT_ID%TYPE := p_product_id;
825: l_product_org_id JTF_RS_RESOURCE_SKILLS.PRODUCT_ORG_ID%TYPE := p_product_org_id;

Line 823: l_subcategory JTF_RS_RESOURCE_SKILLS.SUBCATEGORY%TYPE := p_subcategory;

819: l_resource_skill_id JTF_RS_RESOURCE_SKILLS.RESOURCE_SKILL_ID%TYPE := p_resource_skill_id;
820: l_resource_id JTF_RS_RESOURCE_SKILLS.RESOURCE_ID%TYPE := p_resource_id;
821: l_skill_level_id JTF_RS_RESOURCE_SKILLS.SKILL_LEVEL_ID%TYPE := p_skill_level_id;
822: l_category_id JTF_RS_RESOURCE_SKILLS.CATEGORY_ID%TYPE := p_category_id;
823: l_subcategory JTF_RS_RESOURCE_SKILLS.SUBCATEGORY%TYPE := p_subcategory;
824: l_product_id JTF_RS_RESOURCE_SKILLS.PRODUCT_ID%TYPE := p_product_id;
825: l_product_org_id JTF_RS_RESOURCE_SKILLS.PRODUCT_ORG_ID%TYPE := p_product_org_id;
826: l_platform_id JTF_RS_RESOURCE_SKILLS.PLATFORM_ID%TYPE := p_platform_id;
827: l_platform_org_id JTF_RS_RESOURCE_SKILLS.PLATFORM_ORG_ID%TYPE := p_platform_org_id;

Line 830: l_subcomponent_id JTF_RS_RESOURCE_SKILLS.SUBCOMPONENT_ID%TYPE := p_subcomponent_id;

826: l_platform_id JTF_RS_RESOURCE_SKILLS.PLATFORM_ID%TYPE := p_platform_id;
827: l_platform_org_id JTF_RS_RESOURCE_SKILLS.PLATFORM_ORG_ID%TYPE := p_platform_org_id;
828: l_problem_code JTF_RS_RESOURCE_SKILLS.PROBLEM_CODE%TYPE := p_problem_code;
829: l_component_id JTF_RS_RESOURCE_SKILLS.COMPONENT_ID%TYPE := p_component_id;
830: l_subcomponent_id JTF_RS_RESOURCE_SKILLS.SUBCOMPONENT_ID%TYPE := p_subcomponent_id;
831:
832: l_object_version_number JTF_RS_RESOURCE_SKILLS.OBJECT_VERSION_NUMBER%TYPE := p_object_version_num;
833:
834: l_return_status VARCHAR2(200);