DBA Data[Home] [Help]

APPS.PQH_WORKFLOW dependencies on PER_POS_STRUCTURE_VERSIONS

Line 86: p_pos_str_ver_id in per_pos_structure_versions.pos_structure_version_id%type,

82: p_status_flag out nocopy number,
83: p_applicable_flag out nocopy boolean) ;
84:
85: procedure position_applicable(p_position_id in pqh_position_transactions.position_id%type,
86: p_pos_str_ver_id in per_pos_structure_versions.pos_structure_version_id%type,
87: p_routing_category_id in pqh_routing_categories.routing_category_id%type,
88: p_tran_cat_id in pqh_transaction_categories.transaction_category_id%type,
89: p_trans_id in pqh_position_transactions.position_transaction_id%type,
90: p_status_flag out nocopy number,

Line 168: p_pos_str_id in per_pos_structure_versions.position_structure_id%type,

164: p_tran_cat_id in pqh_transaction_categories.transaction_category_id%type,
165: p_from_clause in pqh_table_route.from_clause%type,
166: p_routing_category_id in pqh_routing_categories.routing_category_id%type,
167: p_old_position_id in pqh_position_transactions.position_id%type,
168: p_pos_str_id in per_pos_structure_versions.position_structure_id%type,
169: p_cur_user_id in out nocopy fnd_user.user_id%type,
170: p_cur_user_name in out nocopy fnd_user.user_name%type,
171: p_pos_str_ver_id out nocopy per_pos_structure_elements.pos_structure_version_id%type,
172: p_cur_position_id out nocopy per_all_assignments_f.position_id%type,

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

171: p_pos_str_ver_id out nocopy per_pos_structure_elements.pos_structure_version_id%type,
172: p_cur_position_id out nocopy per_all_assignments_f.position_id%type,
173: p_cur_person_id out nocopy fnd_user.employee_id%type,
174: p_cur_assignment_id out nocopy per_all_assignments_f.assignment_id%type,
175: p_old_pos_str_id out nocopy per_pos_structure_versions.position_structure_id%type,
176: p_position_id out nocopy pqh_position_transactions.position_id%type,
177: p_status_flag out nocopy number,
178: p_can_approve out nocopy boolean,
179: p_old_can_approve out nocopy boolean,

Line 323: function pos_str_version(p_pos_str_id in per_pos_structure_versions.position_structure_id%type) return number;

319: p_pos_str_ver_id in pqh_routing_history.pos_structure_version_id%type,
320: p_position_id out nocopy pqh_position_transactions.position_id%type,
321: p_status_flag out nocopy number ) ;
322:
323: function pos_str_version(p_pos_str_id in per_pos_structure_versions.position_structure_id%type) return number;
324:
325: function find_pos_structure(p_pos_str_ver_id in per_pos_structure_versions.pos_structure_version_id%type) return number;
326:
327: function get_txn_cat(p_short_name in varchar2,

Line 325: function find_pos_structure(p_pos_str_ver_id in per_pos_structure_versions.pos_structure_version_id%type) return number;

321: p_status_flag out nocopy number ) ;
322:
323: function pos_str_version(p_pos_str_id in per_pos_structure_versions.position_structure_id%type) return number;
324:
325: function find_pos_structure(p_pos_str_ver_id in per_pos_structure_versions.pos_structure_version_id%type) return number;
326:
327: function get_txn_cat(p_short_name in varchar2,
328: p_business_group_id in number default null) return number ;
329: procedure get_role_user(p_member_id in number,