1 PACKAGE AP_WEB_PCARD_WORkFLOW_PKG AS
2 /* $Header: apwpcwfs.pls 120.3 2005/07/26 19:49:49 kgurumur noship $ */
3
4 PROCEDURE DistributeEmpVerifications (errbuf OUT NOCOPY VARCHAR2,
5 retcode OUT NOCOPY NUMBER,
6 p_card_program_id IN NUMBER DEFAULT NULL,
7 p_employee_id IN NUMBER DEFAULT NULL,
8 p_status_lookup_code IN VARCHAR2 DEFAULT NULL,p_org_id in NUMBER);
9
10 PROCEDURE DistributeManagerApprovals (errbuf OUT NOCOPY VARCHAR2,
11 retcode OUT NOCOPY NUMBER,
12 p_manager_id IN NUMBER DEFAULT NULL,
13 p_org_id IN NUMBER);
14 PROCEDURE OpenP(p1 VARCHAR2,
15 p2 VARCHAR2,
16 p11 VARCHAR2 DEFAULT NULL);
17
18 PROCEDURE CheckEmpNotificationMethod(p_item_type IN VARCHAR2,
19 p_item_key IN VARCHAR2,
20 p_actid IN NUMBER,
21 p_funmode IN VARCHAR2,
22 p_result OUT NOCOPY VARCHAR2);
23
24 PROCEDURE MarkRemainingTransVerified(p_item_type IN VARCHAR2,
25 p_item_key IN VARCHAR2,
26 p_actid IN NUMBER,
27 p_funmode IN VARCHAR2,
28 p_result OUT NOCOPY VARCHAR2);
29
30 PROCEDURE AutoApprvVeriTransNotReqAprvl(p_item_type IN VARCHAR2,
31 p_item_key IN VARCHAR2,
32 p_actid IN NUMBER,
33 p_funmode IN VARCHAR2,
34 p_result OUT NOCOPY VARCHAR2);
35
36 PROCEDURE CheckEmpVerificationComplete(p_item_type IN VARCHAR2,
37 p_item_key IN VARCHAR2,
38 p_actid IN NUMBER,
39 p_funmode IN VARCHAR2,
40 p_result OUT NOCOPY VARCHAR2);
41
42 PROCEDURE BuildEmpVerificationMessage(p_item_type IN VARCHAR2,
43 p_item_key IN VARCHAR2,
44 p_actid IN NUMBER,
45 p_funmode IN VARCHAR2,
46 p_result OUT NOCOPY VARCHAR2);
47
48 PROCEDURE CheckManagerApprovalMethod(p_item_type IN VARCHAR2,
49 p_item_key IN VARCHAR2,
50 p_actid IN NUMBER,
51 p_funmode IN VARCHAR2,
52 p_result OUT NOCOPY VARCHAR2);
53
54 PROCEDURE MarkTransactionsAsRejected(p_item_type IN VARCHAR2,
55 p_item_key IN VARCHAR2,
56 p_actid IN NUMBER,
57 p_funmode IN VARCHAR2,
58 p_result OUT NOCOPY VARCHAR2);
59
60 PROCEDURE MarkTransactionsAsApproved(p_item_type IN VARCHAR2,
61 p_item_key IN VARCHAR2,
62 p_actid IN NUMBER,
63 p_funmode IN VARCHAR2,
64 p_result OUT NOCOPY VARCHAR2);
65
66 PROCEDURE BuildManagerApprovalMessage(p_item_type IN VARCHAR2,
67 p_item_key IN VARCHAR2,
68 p_actid IN NUMBER,
69 p_funmode IN VARCHAR2,
70 p_result OUT NOCOPY VARCHAR2);
71
72
73 END AP_WEB_PCARD_WORkFLOW_PKG;