[Home] [Help]
PACKAGE: APPS.PN_AM_WF
Source
1 PACKAGE PN_AM_WF AUTHID CURRENT_USER AS
2 /* $Header: PNLAMWFS.pls 120.1 2010/12/15 12:56:36 rmaringa noship $ */
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
12 PROCEDURE get_approver (
13 itemtype IN VARCHAR2,
14 itemkey IN VARCHAR2,
15 actid IN NUMBER,
16 funcmode IN VARCHAR2,
17 resultout OUT NOCOPY VARCHAR2
18 );
19
20 PROCEDURE update_status (
21 itemtype IN VARCHAR2,
22 itemkey IN VARCHAR2,
23 actid IN NUMBER,
24 funcmode IN VARCHAR2,
25 resultout OUT NOCOPY VARCHAR2
26 );
27
28 PROCEDURE call_lease_approval_wf (
29 p_transaction_id IN NUMBER,
30 p_lease_id IN NUMBER
31 );
32
33 PROCEDURE set_approval_status (
34 itemtype IN VARCHAR2,
35 itemkey IN VARCHAR2,
36 actid IN NUMBER,
37 funcmode IN VARCHAR2,
38 resultout OUT NOCOPY VARCHAR2
39 );
40
41 PROCEDURE set_status_on_exit (
42 itemtype IN VARCHAR2,
43 itemkey IN VARCHAR2,
44 actid IN NUMBER,
45 funcmode IN VARCHAR2,
46 resultout OUT NOCOPY VARCHAR2
47 );
48
49 PROCEDURE get_notification_agent (
50 itemtype IN VARCHAR2,
51 itemkey IN VARCHAR2,
52 actid IN NUMBER,
53 funcmode IN VARCHAR2,
54 p_user_id IN NUMBER,
55 x_name OUT NOCOPY VARCHAR2,
56 x_description OUT NOCOPY VARCHAR2
57 );
58
59 PROCEDURE validate_lease_request (
60 itemtype IN VARCHAR2,
61 itemkey IN VARCHAR2,
62 actid IN NUMBER,
63 funcmode IN VARCHAR2,
64 resultout OUT NOCOPY VARCHAR2
65 );
66
67 PROCEDURE wf_debug (
68 p_log_message IN VARCHAR2,
69 p_log_level IN NUMBER DEFAULT 3
70 );
71
72 FUNCTION submit_program (
73 p_api_name IN VARCHAR2,
74 p_org_id IN NUMBER,
75 p_lease_id IN NUMBER,
76 p_lease_status IN VARCHAR2,
77 p_lease_commencement_date IN DATE
78 )
79 RETURN NUMBER;
80 END pn_am_wf;