APPS.ZX_EXTRACT_PKG dependencies on FND_DFLEX

Line 13: pr_flexfield FND_DFLEX.DFLEX_R;

9: --
10: -- Define Global Variables;
11:
12: --pr_org_loc_rec HR_LOCATIONS_V%ROWTYPE;
13: pr_flexfield FND_DFLEX.DFLEX_R;
14: pr_flexinfo FND_DFLEX.DFLEX_DR;
15: pg_sql varchar2(32000) := null;
16: pg_table_owner VARCHAR2(30);
17: g_ledger_type VARCHAR2(1);

Line 14: pr_flexinfo FND_DFLEX.DFLEX_DR;

10: -- Define Global Variables;
11:
12: --pr_org_loc_rec HR_LOCATIONS_V%ROWTYPE;
13: pr_flexfield FND_DFLEX.DFLEX_R;
14: pr_flexinfo FND_DFLEX.DFLEX_DR;
15: pg_sql varchar2(32000) := null;
16: pg_table_owner VARCHAR2(30);
17: g_ledger_type VARCHAR2(1);
18: g_ledger_id NUMBER(15);

Line 1514: fnd_dflex.get_flexfield(

1510: END IF;
1511:
1512: -- get the structure of address location dff
1513:
1514: fnd_dflex.get_flexfield(
1515: 'PER',
1516: 'Address Location',
1517: pr_flexfield,
1518: pr_flexinfo);

Line 2804: pr_segments FND_DFLEX.SEGMENTS_DR;

2800:
2801: ----------------------------
2802: -- Private Variables
2803: ----------------------------
2804: pr_segments FND_DFLEX.SEGMENTS_DR;
2805: pr_contexts FND_DFLEX.CONTEXTS_DR;
2806: i BINARY_INTEGER;
2807: l_style HR_LOCATIONS_ALL.STYLE%type;
2808: l_context NUMBER;

Line 2805: pr_contexts FND_DFLEX.CONTEXTS_DR;

2801: ----------------------------
2802: -- Private Variables
2803: ----------------------------
2804: pr_segments FND_DFLEX.SEGMENTS_DR;
2805: pr_contexts FND_DFLEX.CONTEXTS_DR;
2806: i BINARY_INTEGER;
2807: l_style HR_LOCATIONS_ALL.STYLE%type;
2808: l_context NUMBER;
2809: l_column VARCHAR2(150);

Line 2824: fnd_dflex.get_contexts(pr_flexfield, pr_contexts);

2820: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_EXTRACT_PKG.get_location_column',
2821: 'P_CLASSIFICATION = '||p_classification);
2822: END IF;
2823:
2824: fnd_dflex.get_contexts(pr_flexfield, pr_contexts);
2825: l_context := NULL;
2826:
2827: FOR i IN 1 .. pr_contexts.ncontexts LOOP
2828: IF(pr_contexts.is_enabled(i)) THEN

Line 2845: fnd_dflex.get_segments(fnd_dflex.make_context(pr_flexfield,

2841: return NULL;
2842: END IF;
2843:
2844: -- Select the segments which correspond to the selected context.
2845: fnd_dflex.get_segments(fnd_dflex.make_context(pr_flexfield,
2846: pr_contexts.context_code(l_context)),
2847: pr_segments,
2848: TRUE);
2849: