2442: --
2443: end get_scl_from_scl;
2444: --
2445: procedure get_asg(
2446: p_item_type in wf_items.item_type%TYPE
2447: ,p_item_key in wf_items.item_key%TYPE
2448: ,p_assignment_id in per_all_assignments_f.assignment_id%type
2449: ,p_effective_date in date
2450: ,p_assignment_rec out nocopy per_all_assignments_f%rowtype) is
2443: end get_scl_from_scl;
2444: --
2445: procedure get_asg(
2446: p_item_type in wf_items.item_type%TYPE
2447: ,p_item_key in wf_items.item_key%TYPE
2448: ,p_assignment_id in per_all_assignments_f.assignment_id%type
2449: ,p_effective_date in date
2450: ,p_assignment_rec out nocopy per_all_assignments_f%rowtype) is
2451: /* This procedure gets all of the assignment data from the transaction tables
2473: end if;
2474: end get_asg;
2475: --
2476: procedure get_step(
2477: p_item_type in wf_items.item_type%TYPE
2478: ,p_item_key in wf_items.item_key%TYPE
2479: ,p_api_name in varchar2
2480: ,p_transaction_step_id out nocopy number
2481: ,p_transaction_id out nocopy number) is
2474: end get_asg;
2475: --
2476: procedure get_step(
2477: p_item_type in wf_items.item_type%TYPE
2478: ,p_item_key in wf_items.item_key%TYPE
2479: ,p_api_name in varchar2
2480: ,p_transaction_step_id out nocopy number
2481: ,p_transaction_id out nocopy number) is
2482: /* This procedure gets the transaction_step_id based on a given item_type and
2501: end if;
2502: end get_step;
2503: --
2504: function step_open(
2505: p_item_type in wf_items.item_type%TYPE
2506: ,p_item_key in wf_items.item_key%TYPE
2507: ,p_api_name in varchar2) return boolean is
2508: /* This procedure looks to see if a transaction step is open for a given
2509: item type, item key and api name
2502: end get_step;
2503: --
2504: function step_open(
2505: p_item_type in wf_items.item_type%TYPE
2506: ,p_item_key in wf_items.item_key%TYPE
2507: ,p_api_name in varchar2) return boolean is
2508: /* This procedure looks to see if a transaction step is open for a given
2509: item type, item key and api name
2510: */