APPS.PQH_WORKFLOW dependencies on PER_POS_STRUCTURE_VERSIONS

Line 1409: p_pos_str_ver_id in per_pos_structure_versions.pos_structure_version_id%type,

1405: raise;
1406: end next_applicable_position;
1407:
1408: procedure position_applicable(p_position_id in pqh_position_transactions.position_id%type,
1409: p_pos_str_ver_id in per_pos_structure_versions.pos_structure_version_id%type,
1410: p_routing_category_id in pqh_routing_categories.routing_category_id%type,
1411: p_tran_cat_id in pqh_transaction_categories.transaction_category_id%type,
1412: p_trans_id in pqh_position_transactions.position_transaction_id%type,
1413: p_status_flag out nocopy number,

Line 2001: p_pos_str_id in per_pos_structure_versions.position_structure_id%type,

1997: p_tran_cat_id in pqh_transaction_categories.transaction_category_id%type,
1998: p_from_clause in pqh_table_route.from_clause%type,
1999: p_routing_category_id in pqh_routing_categories.routing_category_id%type,
2000: p_old_position_id in pqh_position_transactions.position_id%type,
2001: p_pos_str_id in per_pos_structure_versions.position_structure_id%type,
2002: p_cur_user_id in out nocopy fnd_user.user_id%type,
2003: p_cur_user_name in out nocopy fnd_user.user_name%type,
2004: p_pos_str_ver_id out nocopy per_pos_structure_elements.pos_structure_version_id%type,
2005: p_cur_position_id out nocopy per_all_assignments_f.position_id%type,

Line 2008: p_old_pos_str_id out nocopy per_pos_structure_versions.position_structure_id%type,

2004: p_pos_str_ver_id out nocopy per_pos_structure_elements.pos_structure_version_id%type,
2005: p_cur_position_id out nocopy per_all_assignments_f.position_id%type,
2006: p_cur_person_id out nocopy fnd_user.employee_id%type,
2007: p_cur_assignment_id out nocopy per_all_assignments_f.assignment_id%type,
2008: p_old_pos_str_id out nocopy per_pos_structure_versions.position_structure_id%type,
2009: p_position_id out nocopy pqh_position_transactions.position_id%type,
2010: p_status_flag out nocopy number,
2011: p_can_approve out nocopy boolean,
2012: p_old_can_approve out nocopy boolean,

Line 4140: function find_pos_structure(p_pos_str_ver_id in per_pos_structure_versions.pos_structure_version_id%type) return number is

4136: p_can_approve := null;
4137: raise;
4138: end check_value_range ;
4139:
4140: function find_pos_structure(p_pos_str_ver_id in per_pos_structure_versions.pos_structure_version_id%type) return number is
4141: cursor c1 is select position_structure_id
4142: from per_pos_structure_versions
4143: where pos_structure_version_id = p_pos_str_ver_id ;
4144: l_proc varchar2(256) := g_package||'find_pos_structure';

Line 4142: from per_pos_structure_versions

4138: end check_value_range ;
4139:
4140: function find_pos_structure(p_pos_str_ver_id in per_pos_structure_versions.pos_structure_version_id%type) return number is
4141: cursor c1 is select position_structure_id
4142: from per_pos_structure_versions
4143: where pos_structure_version_id = p_pos_str_ver_id ;
4144: l_proc varchar2(256) := g_package||'find_pos_structure';
4145: l_pos_str_id per_pos_structure_versions.position_structure_id%type;
4146: begin

Line 4145: l_pos_str_id per_pos_structure_versions.position_structure_id%type;

4141: cursor c1 is select position_structure_id
4142: from per_pos_structure_versions
4143: where pos_structure_version_id = p_pos_str_ver_id ;
4144: l_proc varchar2(256) := g_package||'find_pos_structure';
4145: l_pos_str_id per_pos_structure_versions.position_structure_id%type;
4146: begin
4147: hr_utility.set_location('Entering '||l_proc,10);
4148: if p_pos_str_ver_id is null then
4149: hr_utility.set_location('Pos_str_version reqd '||l_proc,20);

Line 4165: function pos_str_version(p_pos_str_id in per_pos_structure_versions.position_structure_id%type) return number is

4161: hr_utility.set_location('Exiting '||l_proc,10000);
4162: return l_pos_str_id;
4163: end find_pos_structure;
4164:
4165: function pos_str_version(p_pos_str_id in per_pos_structure_versions.position_structure_id%type) return number is
4166: cursor c1 is select max(pos_structure_version_id)
4167: from per_pos_structure_versions
4168: where position_structure_id = p_pos_str_id ;
4169: l_proc varchar2(256) := g_package||'pos_str_version';

Line 4167: from per_pos_structure_versions

4163: end find_pos_structure;
4164:
4165: function pos_str_version(p_pos_str_id in per_pos_structure_versions.position_structure_id%type) return number is
4166: cursor c1 is select max(pos_structure_version_id)
4167: from per_pos_structure_versions
4168: where position_structure_id = p_pos_str_id ;
4169: l_proc varchar2(256) := g_package||'pos_str_version';
4170: l_pos_str_ver_id number;
4171: begin