1 PACKAGE GCS_DATASUB_WF_PKG as
2 /* $Header: gcs_datasub_wfs.pls 120.6 2006/11/10 12:01:16 smatam noship $ */
3
4 -- Header level information regarding datasubmission details
5 TYPE r_datasub_info IS RECORD(
6 load_id NUMBER(15),
7 load_name VARCHAR2(50),
8 entity_id NUMBER,
9 ledger_id NUMBER(15),
10 cal_period_id NUMBER,
11 currency_code VARCHAR2(30),
12 balance_type_code VARCHAR2(30),
13 load_method_code VARCHAR2(30),
14 currency_type_code VARCHAR2(30),
15 amount_type_code VARCHAR2(30),
16 measure_type_code VARCHAR2(30),
17 notify_options_code VARCHAR2(30),
18 ledger_display_code VARCHAR2(150),
19 entity_display_code VARCHAR2(150),
20 transform_rule_set_id NUMBER(15),
21 validation_rule_set_id NUMBER(15),
22 balances_rule_id NUMBER(15),
23 source_system_code NUMBER(15),
24 dataset_code NUMBER(15),
25 ds_balance_type_code VARCHAR2(30),
26 budget_id NUMBER,
27 budget_display_code VARCHAR2(150),
28 encumbrance_type_id NUMBER,
29 encumbrance_type_code VARCHAR2(150));
30
31 PROCEDURE submit_datasub(x_errbuf OUT NOCOPY VARCHAR2,
32 x_retcode OUT NOCOPY VARCHAR2,
33 p_load_id IN NUMBER);
34
35 PROCEDURE init_datasub_process(p_itemtype IN VARCHAR2,
36 p_itemkey IN VARCHAR2,
37 p_actid IN NUMBER,
38 p_funcmode IN VARCHAR2,
39 p_result IN OUT NOCOPY VARCHAR2);
40
41 PROCEDURE check_idt_required(p_itemtype IN VARCHAR2,
42 p_itemkey IN VARCHAR2,
43 p_actid IN NUMBER,
44 p_funcmode IN VARCHAR2,
45 p_result IN OUT NOCOPY VARCHAR2);
46
47 PROCEDURE check_validation_required(p_itemtype IN VARCHAR2,
48 p_itemkey IN VARCHAR2,
49 p_actid IN NUMBER,
50 p_funcmode IN VARCHAR2,
51 p_result IN OUT NOCOPY VARCHAR2);
52
53 PROCEDURE update_amounts(p_itemtype IN VARCHAR2,
54 p_itemkey IN VARCHAR2,
55 p_actid IN NUMBER,
56 p_funcmode IN VARCHAR2,
57 p_result IN OUT NOCOPY VARCHAR2);
58
59 PROCEDURE update_status(p_load_id IN NUMBER);
60
61 PROCEDURE transfer_data_to_interface(p_itemtype IN VARCHAR2,
62 p_itemkey IN VARCHAR2,
63 p_actid IN NUMBER,
64 p_funcmode IN VARCHAR2,
65 p_result IN OUT NOCOPY VARCHAR2);
66
67 PROCEDURE raise_impact_analysis_event(p_load_id IN NUMBER,
68 p_ledger_id IN NUMBER);
69
70 PROCEDURE execute_validation(p_itemtype IN VARCHAR2,
71 p_itemkey IN VARCHAR2,
72 p_actid IN NUMBER,
73 p_funcmode IN VARCHAR2,
74 p_result IN OUT NOCOPY VARCHAR2);
75
76 PROCEDURE execute_idt(p_itemtype IN VARCHAR2,
77 p_itemkey IN VARCHAR2,
78 p_actid IN NUMBER,
79 p_funcmode IN VARCHAR2,
80 p_result IN OUT NOCOPY VARCHAR2);
81
82 PROCEDURE submit_ogl_datasub(p_load_id IN NUMBER,
83 p_request_id OUT NOCOPY NUMBER);
84
85 PROCEDURE validate_member_values(p_itemtype IN VARCHAR2,
86 p_itemkey IN VARCHAR2,
87 p_actid IN NUMBER,
88 p_funcmode IN VARCHAR2,
89 p_result IN OUT NOCOPY VARCHAR2);
90 --
91 -- function
92 -- populate_ogl_datasub_dtls
93 -- Purpose
94 -- An API to populate the gcs_dats_sub_dtls.
95 -- This API has subscription with the business event "oracle.apps.fem.oglintg.balrule.execute"
96 -- Arguments
97 -- p_subscription_guid - This subscription GUID is passed when the event is raised
98 -- p_event - wf_event_t param
99 -- Notes
100 --
101
102 FUNCTION populate_ogl_datasub_dtls(p_subscription_guid IN RAW,
103 p_event IN OUT NOCOPY wf_event_t)
104 RETURN VARCHAR2;
105
106 --
107 -- function
108 -- handle_undo_event
109 -- Purpose
110 -- An API to handle the UNDO Event submitted via EPF.
111 -- This API has subscription with the business event "oracle.apps.fem.ud.complete"
112 -- Arguments
113 -- p_subscription_guid - This subscription GUID is passed when the event is raised
114 -- p_event - wf_event_t param
115 -- Notes
116 -- Bug Fix : 5647099
117 FUNCTION handle_undo_event(p_subscription_guid IN RAW,
118 p_event IN OUT NOCOPY wf_event_t)
119 RETURN VARCHAR2;
120
121 END GCS_DATASUB_WF_PKG;