3:
4: PROCEDURE raise_business_event (
5: p_transaction_id IN NUMBER,
6: p_event_name IN VARCHAR2,
7: p_lease_id IN pn_leases_all.lease_id%TYPE,
8: p_old_lease_status IN pn_leases_all.lease_status%TYPE,
9: p_new_lease_status IN pn_leases_all.lease_status%TYPE
10: );
11:
4: PROCEDURE raise_business_event (
5: p_transaction_id IN NUMBER,
6: p_event_name IN VARCHAR2,
7: p_lease_id IN pn_leases_all.lease_id%TYPE,
8: p_old_lease_status IN pn_leases_all.lease_status%TYPE,
9: p_new_lease_status IN pn_leases_all.lease_status%TYPE
10: );
11:
12: PROCEDURE get_approver (
5: p_transaction_id IN NUMBER,
6: p_event_name IN VARCHAR2,
7: p_lease_id IN pn_leases_all.lease_id%TYPE,
8: p_old_lease_status IN pn_leases_all.lease_status%TYPE,
9: p_new_lease_status IN pn_leases_all.lease_status%TYPE
10: );
11:
12: PROCEDURE get_approver (
13: itemtype IN VARCHAR2,