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 1981: fnd_dflex.get_flexfield(

1977: END IF;
1978:
1979: -- get the structure of address location dff
1980:
1981: fnd_dflex.get_flexfield(
1982: 'PER',
1983: 'Address Location',
1984: pr_flexfield,
1985: pr_flexinfo);

Line 3263: pr_segments FND_DFLEX.SEGMENTS_DR;

3259:
3260: ----------------------------
3261: -- Private Variables
3262: ----------------------------
3263: pr_segments FND_DFLEX.SEGMENTS_DR;
3264: pr_contexts FND_DFLEX.CONTEXTS_DR;
3265: i BINARY_INTEGER;
3266: l_style HR_LOCATIONS_ALL.STYLE%type;
3267: l_context NUMBER;

Line 3264: pr_contexts FND_DFLEX.CONTEXTS_DR;

3260: ----------------------------
3261: -- Private Variables
3262: ----------------------------
3263: pr_segments FND_DFLEX.SEGMENTS_DR;
3264: pr_contexts FND_DFLEX.CONTEXTS_DR;
3265: i BINARY_INTEGER;
3266: l_style HR_LOCATIONS_ALL.STYLE%type;
3267: l_context NUMBER;
3268: l_column VARCHAR2(150);

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

3279: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_EXTRACT_PKG.get_location_column',
3280: 'P_CLASSIFICATION = '||p_classification);
3281: END IF;
3282:
3283: fnd_dflex.get_contexts(pr_flexfield, pr_contexts);
3284: l_context := NULL;
3285:
3286: FOR i IN 1 .. pr_contexts.ncontexts LOOP
3287: IF(pr_contexts.is_enabled(i)) THEN

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

3300: return NULL;
3301: END IF;
3302:
3303: -- Select the segments which correspond to the selected context.
3304: fnd_dflex.get_segments(fnd_dflex.make_context(pr_flexfield,
3305: pr_contexts.context_code(l_context)),
3306: pr_segments,
3307: TRUE);
3308: