PACKAGE: APPS.PQP_OSS_DFF_UTILS

Source

1 PACKAGE PQP_OSS_DFF_UTILS AUTHID CURRENT_USER AS
2 /* $Header: pqphrossutil.pkh 120.2 2012/01/19 07:40:36 rpahune ship $ */
3 
4 -- =============================================================================
5 -- ~ Package Body Global variables:
6 -- =============================================================================
7 
8    g_pkg           CONSTANT Varchar2(150) := 'pqp_oss_ddf_utils';
9 
10    TYPE t_delim_contxt IS RECORD
11    (con_seg_delim                fnd_descriptive_flexs.concatenated_segment_delimiter%TYPE
12    ,con_col_name                 fnd_descriptive_flexs.context_column_name%TYPE
13    );
14 
15    TYPE t_seg_valsetid IS RECORD
16    (seg_name                     fnd_descr_flex_column_usages.application_column_name%TYPE
17    ,flx_valset_id                fnd_descr_flex_column_usages.flex_value_set_id%TYPE
18    );
19 
20 
21 -- =============================================================================
22 -- ~ parse_segment:
23 -- =============================================================================
24 FUNCTION parse_segment
25         (p_seg_valset_rec IN t_seg_valsetid)
26 RETURN Varchar2;
27 
28 
29 -- =============================================================================
30 -- ~ get_concat_dff_segs:
31 -- =============================================================================
32 FUNCTION get_concat_dff_segs
33          (p_ddf_name      IN Varchar2
34          ,p_dp_view_name  IN Varchar2
35          ,p_batch_id      IN Number
36          ,p_app_id        IN Number
37          ,p_link_value    IN Number   DEFAULT NULL)
38 RETURN Varchar2;
39 
40 
41 -- =============================================================================
42 -- ~ Get Key Flexfield breakup segments:
43 -- =============================================================================
44 
45 FUNCTION Get_Breakup_KFF_Segment
46 		(application_short_name	IN VARCHAR2
47                  ,key_flex_code		IN VARCHAR2
48                  ,structure_number	IN NUMBER
49                  ,combination_id	IN NUMBER
50                  ,segment_number	IN NUMBER) RETURN Varchar2;
51 
52 
53 END PQP_OSS_DFF_UTILS;
54