1 PACKAGE gms_workflow_utils AS
2 /* $Header: gmsfutls.pls 120.1 2005/07/26 14:22:14 appldev ship $ */
3
4
5
6 PROCEDURE Insert_WF_Processes
7 (p_wf_type_code IN VARCHAR2
8 , p_item_type IN VARCHAR2
9 , p_item_key IN VARCHAR2
10 , p_entity_key1 IN VARCHAR2
11 , p_entity_key2 IN VARCHAR2 := GMS_BUDGET_PUB.G_PA_MISS_CHAR
12 , p_description IN VARCHAR2 := GMS_BUDGET_PUB.G_PA_MISS_CHAR
13 , p_err_code IN OUT NOCOPY NUMBER
14 , p_err_stage IN OUT NOCOPY VARCHAR2
15 , p_err_stack IN OUT NOCOPY VARCHAR2
16 );
17
18 PROCEDURE Set_Global_Attr
19 (p_item_type IN VARCHAR2
20 , p_item_key IN VARCHAR2
21 , p_err_code OUT NOCOPY VARCHAR2
22 );
23
24 PROCEDURE Set_Notification_Messages
25 (p_item_type IN VARCHAR2
26 , p_item_key IN VARCHAR2
27 );
28
29 --
30 -- FUNCTION
31 -- get_application_id
32 -- PURPOSE
33 -- This function retrieves the application id of a responsibility.
34 -- If no application id is found, null is returned.
35 -- If Oracle error occurs, Oracle error number is returned.
36
37 function get_application_id (x_responsibility_id IN number) return number;
38 pragma RESTRICT_REFERENCES (get_application_id, WNDS, WNPS);
39
40 END gms_workflow_utils;