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