51: ,funcmode in varchar2
52: ,resultout out nocopy varchar2);
53:
54: function get_item_type
55: (p_transaction_id IN hr_api_transactions.transaction_id%TYPE)
56: return varchar2;
57: function get_item_key
58: (p_transaction_id IN hr_api_transactions.transaction_id%TYPE)
59: return varchar2;
54: function get_item_type
55: (p_transaction_id IN hr_api_transactions.transaction_id%TYPE)
56: return varchar2;
57: function get_item_key
58: (p_transaction_id IN hr_api_transactions.transaction_id%TYPE)
59: return varchar2;
60: function get_process_name
61: (p_transaction_id IN hr_api_transactions.transaction_id%TYPE)
62: return varchar2;
57: function get_item_key
58: (p_transaction_id IN hr_api_transactions.transaction_id%TYPE)
59: return varchar2;
60: function get_process_name
61: (p_transaction_id IN hr_api_transactions.transaction_id%TYPE)
62: return varchar2;
63: function get_approval_level
64: (p_transaction_id IN hr_api_transactions.transaction_id%TYPE)
65: return number;
60: function get_process_name
61: (p_transaction_id IN hr_api_transactions.transaction_id%TYPE)
62: return varchar2;
63: function get_approval_level
64: (p_transaction_id IN hr_api_transactions.transaction_id%TYPE)
65: return number;
66: function get_effective_date
67: (p_transaction_id IN hr_api_transactions.transaction_id%TYPE)
68: return date;
63: function get_approval_level
64: (p_transaction_id IN hr_api_transactions.transaction_id%TYPE)
65: return number;
66: function get_effective_date
67: (p_transaction_id IN hr_api_transactions.transaction_id%TYPE)
68: return date;
69: function get_assignment_id
70: (p_transaction_id IN hr_api_transactions.transaction_id%TYPE)
71: return number;
66: function get_effective_date
67: (p_transaction_id IN hr_api_transactions.transaction_id%TYPE)
68: return date;
69: function get_assignment_id
70: (p_transaction_id IN hr_api_transactions.transaction_id%TYPE)
71: return number;
72: function get_final_approver
73: (p_transaction_id IN hr_api_transactions.transaction_id%TYPE)
74: return number;
69: function get_assignment_id
70: (p_transaction_id IN hr_api_transactions.transaction_id%TYPE)
71: return number;
72: function get_final_approver
73: (p_transaction_id IN hr_api_transactions.transaction_id%TYPE)
74: return number;
75:
76: --
77: -- ------------------------------------------------------------------------
109: result out nocopy varchar2 );
110:
111:
112: function allow_requestor_approval
113: (p_transaction_id IN hr_api_transactions.transaction_id%TYPE)
114: return varchar2;
115: --
116: -- ------------------------------------------------------------------------
117: -- |------------------ < check_mid_pay_period_change > --------------------|
255: aname in varchar2,
256: ignore_notfound in varchar2 default 'FALSE') return varchar2;
257:
258: function getApprStartingPointPersonId
259: (p_transaction_id IN hr_api_transactions.transaction_id%TYPE) return number;
260:
261:
262: procedure updateSFLTransaction (itemtype in varchar2,
263: itemkey in varchar2,