APPS.AP_WEB_DB_EXPLINE_PKG dependencies on FND_DFLEX

Line 1239: l_flexfield FND_DFLEX.DFLEX_R;

1235: ) RETURN BOOLEAN IS
1236: --------------------------------------------------------------------------------
1237: C_LinesDescFlexName CONSTANT VARCHAR2(50) := 'AP_EXPENSE_REPORT_LINES';
1238: l_context_enabled VARCHAR2(1) := 'N';
1239: l_flexfield FND_DFLEX.DFLEX_R;
1240: l_flexinfo FND_DFLEX.DFLEX_DR;
1241: BEGIN
1242:
1243: FND_DFLEX.Get_Flexfield('SQLAP',

Line 1240: l_flexinfo FND_DFLEX.DFLEX_DR;

1236: --------------------------------------------------------------------------------
1237: C_LinesDescFlexName CONSTANT VARCHAR2(50) := 'AP_EXPENSE_REPORT_LINES';
1238: l_context_enabled VARCHAR2(1) := 'N';
1239: l_flexfield FND_DFLEX.DFLEX_R;
1240: l_flexinfo FND_DFLEX.DFLEX_DR;
1241: BEGIN
1242:
1243: FND_DFLEX.Get_Flexfield('SQLAP',
1244: C_LinesDescFlexname,

Line 1243: FND_DFLEX.Get_Flexfield('SQLAP',

1239: l_flexfield FND_DFLEX.DFLEX_R;
1240: l_flexinfo FND_DFLEX.DFLEX_DR;
1241: BEGIN
1242:
1243: FND_DFLEX.Get_Flexfield('SQLAP',
1244: C_LinesDescFlexname,
1245: l_flexfield,
1246: l_flexinfo);
1247:

Line 5160: l_dflex_r fnd_dflex.dflex_r;

5156: p_addressstyle IN per_addresses.style%TYPE,
5157: p_region IN per_addresses.region_1%TYPE)
5158: RETURN VARCHAR2
5159: AS
5160: l_dflex_r fnd_dflex.dflex_r;
5161: l_dflex_dr fnd_dflex.dflex_dr;
5162: l_contexts_dr fnd_dflex.contexts_dr;
5163: l_segments_dr fnd_dflex.segments_dr;
5164: l_valueset_id fnd_descr_flex_col_usage_vl.flex_value_set_id%TYPE;

Line 5161: l_dflex_dr fnd_dflex.dflex_dr;

5157: p_region IN per_addresses.region_1%TYPE)
5158: RETURN VARCHAR2
5159: AS
5160: l_dflex_r fnd_dflex.dflex_r;
5161: l_dflex_dr fnd_dflex.dflex_dr;
5162: l_contexts_dr fnd_dflex.contexts_dr;
5163: l_segments_dr fnd_dflex.segments_dr;
5164: l_valueset_id fnd_descr_flex_col_usage_vl.flex_value_set_id%TYPE;
5165: l_vset_r fnd_vset.valueset_r;

Line 5162: l_contexts_dr fnd_dflex.contexts_dr;

5158: RETURN VARCHAR2
5159: AS
5160: l_dflex_r fnd_dflex.dflex_r;
5161: l_dflex_dr fnd_dflex.dflex_dr;
5162: l_contexts_dr fnd_dflex.contexts_dr;
5163: l_segments_dr fnd_dflex.segments_dr;
5164: l_valueset_id fnd_descr_flex_col_usage_vl.flex_value_set_id%TYPE;
5165: l_vset_r fnd_vset.valueset_r;
5166: l_value_dr fnd_vset.value_dr;

Line 5163: l_segments_dr fnd_dflex.segments_dr;

5159: AS
5160: l_dflex_r fnd_dflex.dflex_r;
5161: l_dflex_dr fnd_dflex.dflex_dr;
5162: l_contexts_dr fnd_dflex.contexts_dr;
5163: l_segments_dr fnd_dflex.segments_dr;
5164: l_valueset_id fnd_descr_flex_col_usage_vl.flex_value_set_id%TYPE;
5165: l_vset_r fnd_vset.valueset_r;
5166: l_value_dr fnd_vset.value_dr;
5167: l_vset_dr fnd_vset.valueset_dr;

Line 5182: fnd_dflex.get_flexfield('PER','Address Structure',l_dflex_r,l_dflex_dr);

5178: OR AP_WEB_CUST_DFLEX_PKG.CustomGetCountyProvince(p_addressstyle, l_region) then
5179: return l_region;
5180: END IF;
5181:
5182: fnd_dflex.get_flexfield('PER','Address Structure',l_dflex_r,l_dflex_dr);
5183: fnd_dflex.get_segments(fnd_dflex.make_context(l_dflex_r,p_addressStyle),l_segments_dr,TRUE);
5184:
5185: FOR i IN 1 .. l_segments_dr.nsegments LOOP
5186: IF (UPPER(l_segments_dr.segment_name(i)) IN ('COUNTY','PROVINCE')) THEN

Line 5183: fnd_dflex.get_segments(fnd_dflex.make_context(l_dflex_r,p_addressStyle),l_segments_dr,TRUE);

5179: return l_region;
5180: END IF;
5181:
5182: fnd_dflex.get_flexfield('PER','Address Structure',l_dflex_r,l_dflex_dr);
5183: fnd_dflex.get_segments(fnd_dflex.make_context(l_dflex_r,p_addressStyle),l_segments_dr,TRUE);
5184:
5185: FOR i IN 1 .. l_segments_dr.nsegments LOOP
5186: IF (UPPER(l_segments_dr.segment_name(i)) IN ('COUNTY','PROVINCE')) THEN
5187: l_valueset_id := l_segments_dr.value_set(i);