1 PACKAGE gma_standard AS
2 /* $Header: GMASTNDS.pls 120.1 2005/07/19 11:41:32 txdaniel noship $
3
4 /* Global Variables */
5
6 G_SIGNATURE_STATUS varchar2(80):=NULL; -- Global variable which hold the status of workflow ('APPROVED','REJECTED')
7
8 G_API_VERSION NUMBER := 1.0;
9
10 /* Global Record Groups */
11
12 Type eventDetails is record(
13 event_name varchar2(240),
14 event_key varchar2(240),
15 key_type VARCHAR2(40)
16 );
17 Type eventQuery is table of eventDetails index by binary_integer;
18
19 Type RuleInputvalues is record(
20 input_name varchar2(240),
21 input_value varchar2(240)
22 );
23 Type ameRuleinputvalues is table of ruleInputvalues index by binary_integer;
24
25 /* signature Status. This Procedure returns signature status for a given event.
26 The status is for the latest event happened and has values 'PENDING','COMPLETE','ERROR' */
27 PROCEDURE PSIG_STATUS
28 (
29 p_event in varchar2,
30 p_event_key in varchar2,
31 P_status out NOCOPY varchar2
32 ) ;
33
34 /* signature Requirement. This Procedure returns signature requireemnt for a given event.
35 The status is boolean ('TRUE','FALSE') */
36
37 PROCEDURE PSIG_REQUIRED
38 (
39 p_event in varchar2,
40 p_event_key in varchar2,
41 P_status out NOCOPY boolean
42 ) ;
43
44 /* eRecord Requirement. This Procedure returns eRecord Requirement for a given event.
45 The status is boolean ('TRUE','FALSE') */
46
47 PROCEDURE EREC_REQUIRED
48 (
49 p_event in varchar2,
50 p_event_key in varchar2,
51 P_status out NOCOPY boolean
52 ) ;
53
54 /* This function will be called from forms before calling the Transaction Query form */
55
56 FUNCTION PSIG_QUERY(p_eventQuery GMA_STANDARD.eventQuery) return number;
57
58 /* This procedure will be called to get AME input variable for a given transaction*/
59
60 PROCEDURE GET_AMERULE_INPUT_VALUES(ameapplication IN varchar2,
61 ameruleid IN NUMBER,
62 amerulename IN VARCHAR2,
63 ameruleinputvalues OUT NOCOPY GMA_STANDARD.ameruleinputvalues) ;
64
65
66 /* This Funcitons Returns a display date format */
67 PROCEDURE DISPLAY_DATE(P_DATE_IN in DATE , P_DATE_OUT OUT NOCOPY Varchar2) ;
68
69
70 /* Package Specification for the Document Management */
71
72 PROCEDURE Upload_File ( p_api_version IN NUMBER,
73 p_commit IN VARCHAR2,
74 p_called_from_forms IN VARCHAR2,
75 p_file_name IN VARCHAR2,
76 p_category IN VARCHAR2,
77 p_content_type IN VARCHAR2,
78 p_version_label IN VARCHAR2,
79 p_file_data IN BLOB,
80 p_file_format IN VARCHAR2,
81 p_source_lang IN VARCHAR2,
82 p_description IN VARCHAR2,
83 p_file_exists_action IN VARCHAR2,
84 p_submit_for_approval IN VARCHAR2,
85 p_attribute1 IN VARCHAR2,
86 p_attribute2 IN VARCHAR2,
87 p_attribute3 IN VARCHAR2,
88 p_attribute4 IN VARCHAR2,
89 p_attribute5 IN VARCHAR2,
90 p_attribute6 IN VARCHAR2,
91 p_attribute7 IN VARCHAR2,
92 p_attribute8 IN VARCHAR2,
93 p_attribute9 IN VARCHAR2,
94 p_attribute10 IN VARCHAR2,
95 p_created_by IN NUMBER,
96 p_creation_date IN DATE,
97 p_last_updated_by IN NUMBER,
98 p_last_update_login IN NUMBER,
99 p_last_update_date IN DATE,
100 x_return_status OUT NOCOPY VARCHAR2,
101 x_msg_data OUT NOCOPY VARCHAR2);
102
103 -- Added for Melanie Grosser as a fix for bug# 3280763
104 -- This function is used to build a query of eRecords events based upon a
105 -- document attachment. It return the id of the query so that the query can
106 -- be executed.
107 FUNCTION build_eres_query (p_entity_name IN VARCHAR2,
108 p_pk1_value IN VARCHAR2,
109 p_pk2_value IN VARCHAR2,
110 p_pk3_value IN VARCHAR2,
111 p_pk4_value IN VARCHAR2,
112 p_pk5_value IN VARCHAR2,
113 x_error_message OUT NOCOPY VARCHAR2,
114 x_return_status OUT NOCOPY VARCHAR2
115 ) RETURN NUMBER;
116 -- Added for the erecord enhancement for GME. Details in bug 4328588
117 FUNCTION GET_ERECORD_ID
118 ( p_event_name IN VARCHAR2
119 ,p_event_key IN VARCHAR2
120 ) RETURN NUMBER ;
121
122 end gma_standard;