[Home] [Help]
PACKAGE: APPS.OTA_FR_PLAN_DFORM
Source
1 PACKAGE OTA_FR_PLAN_DFORM AS
2 /* $Header: otafrpdf.pkh 120.0.12010000.1 2008/10/14 06:33:57 parusia noship $ */
3 --
4 ---------------------------------------------------
5 -- Main procedure for building XML string
6 ------------------------------------------------------
7 PROCEDURE pdf_main_fill_table(p_business_group_id NUMBER,
8 p_company_id NUMBER DEFAULT NULL,
9 p_estab_id NUMBER DEFAULT NULL,
10 p_calendar VARCHAR2,
11 p_time_period_id NUMBER,
12 p_consolidate VARCHAR2,
13 p_training_plan_id NUMBER DEFAULT NULL,
14 p_list_events VARCHAR2,
15 p_template_name VARCHAR2, -- added to match parameters with CP
16 p_xml OUT NOCOPY CLOB);
17 -------------
18 --------------------------------------------------------------------------
19 -- Function for retrieving budget level for a training plan
20 --------------------------------------------------------------------------
21 FUNCTION get_budget_level(p_business_group_id number) return varchar2;
22
23 --------------------------------------------------------------------------
24 -- Function for calculating member budget values:
25 ---------------------------------------------------------------------------
26 FUNCTION get_member_budget_values(p_measure_code varchar2
27 ,p_member_level varchar2
28 ,p_member_id number
29 ,p_training_plan_id number
30 ,p_business_group_id number) return number;
31
32 ----------------------------------------------------------------------------
33 -- Function for calculating event duration
34 ----------------------------------------------------------------------------
35 FUNCTION get_event_duration(p_training_plan_id number,
36 p_event_id number,
37 p_member_level varchar2,
38 p_member_id number,
39 p_business_group_id number) return number;
40
41 ------------------------------------------------------
42 -- Procedure for writing format of XML string
43 ---------------------------------------------------------
44 procedure load_xml_declaration(p_xml in out nocopy clob);
45
46 -------------------------------------------------------------
47 -- Procedure for appending labels of the XML string
48 -------------------------------------------------------------
49 procedure load_xml_label(p_xml in out nocopy clob,
50 p_node varchar2,
51 p_open_not_close boolean);
52
53
54 ----------------------------------------------------------------
55 -- Procedure for writing tag names and values
56 ---------------------------------------------------------------
57 procedure load_xml (p_xml in out nocopy clob,
58 p_node varchar2,
59 p_data varchar2,
60 p_attribs varchar2 default null) ;
61
62 -----------------------------------------------------------
63 -- Procedure for writing the clob
64 -----------------------------------------------------------
65 procedure write_to_clob (p_xml in out nocopy clob,
66 p_data varchar2);
67 -------------------------------------------------------
68 END OTA_FR_PLAN_DFORM;