[Home] [Help]
PACKAGE: APPS.PQP_RIW_WEBADI_UTILS
Source
1 Package PQP_RIW_WEBADI_UTILS as
2 /* $Header: pqpriwadiutl.pkh 120.2.12010000.2 2008/11/28 16:38:10 psengupt ship $ */
3
4 g_proc_name Varchar2(200) :='PQP_RIW_WEBADI_UTILS.';
5 g_seq_numbers Varchar2(2000);
6
7 -- =============================================================================
8 -- Record : r_riw_data
9 -- to get riw data
10 -- =============================================================================
11 TYPE r_riw_data IS RECORD(
12 sequence NUMBER
13 ,interface_seq NUMBER
14 ,xml_tag VARCHAR2(200)
15 ,default_type VARCHAR2(10)
16 ,default_value VARCHAR2(2000)
17 ,placement VARCHAR2(10)
18 ,group_name VARCHAR2(30)
19 );
20
21 TYPE t_riw_data is Table OF r_riw_data
22 INDEX BY BINARY_INTEGER;
23
24 g_riw_data t_riw_data;
25 g_temp_riw_data t_riw_data;
26
27 -- =============================================================================
28 -- Record : r_delim_contxt
29 -- to get dff delimiter and context
30 -- =============================================================================
31 TYPE r_delim_contxt IS RECORD(
32 con_seg_delim fnd_descriptive_flexs.concatenated_segment_delimiter%TYPE
33 ,con_col_name fnd_descriptive_flexs.context_column_name%TYPE
34 );
35
36 -- =============================================================================
37 -- Record : r_delim_contxt
38 -- to get dff delimiter and context
39 -- =============================================================================
40 TYPE r_segment_list IS RECORD(
41 seg_name fnd_descr_flex_column_usages.application_column_name%TYPE
42 );
43
44 -- =============================================================================
45 -- This procedure creates RIW Webadi Setup
46 -- =============================================================================
47 PROCEDURE Create_RIW_Webadi_Setup
48 (p_application_id IN NUMBER
49 ,p_data_source IN VARCHAR2
50 ,p_user_function_name IN VARCHAR2
51 ,p_menu_id IN NUMBER
52 ,p_seq_params IN VARCHAR2
53 ,p_intrfce_seq_params IN VARCHAR2
54 ,p_xml_tag_params IN pqp_prompt_array_tab
55 ,p_defalut_type_params IN VARCHAR2
56 ,p_defalut_value_params IN pqp_default_array_tab
57 ,p_placement_params IN VARCHAR2
58 ,p_group_params IN VARCHAR2
59 ,p_action_type IN VARCHAR2
60 ,p_upd_layout_code IN VARCHAR2
61 ,p_upd_interface_code IN VARCHAR2
62 ,p_upd_mapping_code IN VARCHAR2
63 ,p_ins_upd_datapmp_flag IN VARCHAR2
64 ,p_entity_name IN VARCHAR2 DEFAULT NULL
65 ,p_return_status OUT NOCOPY VARCHAR2);
66
67 -- =============================================================================
68 -- This procedure creates RIW XML Tags
69 -- =============================================================================
70 PROCEDURE Create_RIW_XML_Tags
71 (p_field_id IN NUMBER
72 ,p_xml_tag_id IN NUMBER
73 ,p_xml_tag_name IN VARCHAR2
74 ,p_business_group_id IN VARCHAR2 );
75
76 -- =============================================================================
77 -- This procedure Deletes RIW Webadi Setup
78 -- =============================================================================
79 PROCEDURE Delete_RIW_Webadi_Setup
80 (p_function_id IN NUMBER
81 ,p_menu_id IN NUMBER);
82
83 -- =============================================================================
84 -- This procedure deletes RIW XML Tags
85 -- =============================================================================
86 PROCEDURE Delete_RIW_XML_Tag
87 (p_xml_tag_id IN NUMBER
88 ,p_business_group_id IN NUMBER) ;
89
90 -- =============================================================================
91 -- ~ Get Concatenated Exception for the linked batch lines:
92 -- =============================================================================
93 FUNCTION Get_concatenated_exception(p_batch_id in number,p_batch_link in number)
94 return varchar2;
95
96 -- =============================================================================
97 -- ~ Get Descriptive Flexfield concatanated data:
98 -- =============================================================================
99 FUNCTION Get_Concatanated_DFF_Segments
100 (p_dff_name IN VARCHAR2
101 ,p_app_id IN NUMBER
102 ,p_context IN VARCHAR2
103 ,p_effective_date IN DATE
104 ,p_entity IN VARCHAR2
105 ,p_entity_id IN NUMBER) RETURN Varchar2;
106
107
108
109
110 END PQP_RIW_WEBADI_UTILS;