DBA Data[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;