APPS.WIP_WS_SKILL_CHECK_PVT dependencies on WIP_OPERATION_COMPETENCIES

Line 87: from wip_operation_competencies

83: is
84:
85: cursor get_operation_competence is
86: select competence_id,rating_level_id,qualification_type_id
87: from wip_operation_competencies
88: where wip_entity_id = p_wip_entity_id
89: and operation_seq_num = p_operation;
90:
91: l_counter Number;

Line 99: competency_id wip_operation_competencies.competence_id%type,

95: l_next_review_date date;
96: l_comp_certify_required varchar2(1);
97:
98: type job_op_competence_rec is record (
99: competency_id wip_operation_competencies.competence_id%type,
100: rating_level_id wip_operation_competencies.rating_level_id%type,
101: qualification_type_id wip_operation_competencies.qualification_type_id%type);
102:
103: type t_job_op_competence is table of job_op_competence_rec index by binary_integer;

Line 100: rating_level_id wip_operation_competencies.rating_level_id%type,

96: l_comp_certify_required varchar2(1);
97:
98: type job_op_competence_rec is record (
99: competency_id wip_operation_competencies.competence_id%type,
100: rating_level_id wip_operation_competencies.rating_level_id%type,
101: qualification_type_id wip_operation_competencies.qualification_type_id%type);
102:
103: type t_job_op_competence is table of job_op_competence_rec index by binary_integer;
104: v_job_op_competence t_job_op_competence;

Line 101: qualification_type_id wip_operation_competencies.qualification_type_id%type);

97:
98: type job_op_competence_rec is record (
99: competency_id wip_operation_competencies.competence_id%type,
100: rating_level_id wip_operation_competencies.rating_level_id%type,
101: qualification_type_id wip_operation_competencies.qualification_type_id%type);
102:
103: type t_job_op_competence is table of job_op_competence_rec index by binary_integer;
104: v_job_op_competence t_job_op_competence;
105:

Line 202: from wip_operation_competencies

198: begin
199: select 1 into l_op_competence_exist
200: from dual
201: where exists (select 1
202: from wip_operation_competencies
203: where wip_entity_id = p_wip_entity_id
204: and operation_seq_num = p_operation );
205: exception
206: when others then