1230: ) RETURN BOOLEAN IS
1231: --------------------------------------------------------------------------------
1232: C_LinesDescFlexName CONSTANT VARCHAR2(50) := 'AP_EXPENSE_REPORT_LINES';
1233: l_context_enabled VARCHAR2(1) := 'N';
1234: l_flexfield FND_DFLEX.DFLEX_R;
1235: l_flexinfo FND_DFLEX.DFLEX_DR;
1236: BEGIN
1237:
1238: FND_DFLEX.Get_Flexfield('SQLAP',
1231: --------------------------------------------------------------------------------
1232: C_LinesDescFlexName CONSTANT VARCHAR2(50) := 'AP_EXPENSE_REPORT_LINES';
1233: l_context_enabled VARCHAR2(1) := 'N';
1234: l_flexfield FND_DFLEX.DFLEX_R;
1235: l_flexinfo FND_DFLEX.DFLEX_DR;
1236: BEGIN
1237:
1238: FND_DFLEX.Get_Flexfield('SQLAP',
1239: C_LinesDescFlexname,
1234: l_flexfield FND_DFLEX.DFLEX_R;
1235: l_flexinfo FND_DFLEX.DFLEX_DR;
1236: BEGIN
1237:
1238: FND_DFLEX.Get_Flexfield('SQLAP',
1239: C_LinesDescFlexname,
1240: l_flexfield,
1241: l_flexinfo);
1242:
4841: p_addressstyle IN per_addresses.style%TYPE,
4842: p_region IN per_addresses.region_1%TYPE)
4843: RETURN VARCHAR2
4844: AS
4845: l_dflex_r fnd_dflex.dflex_r;
4846: l_dflex_dr fnd_dflex.dflex_dr;
4847: l_contexts_dr fnd_dflex.contexts_dr;
4848: l_segments_dr fnd_dflex.segments_dr;
4849: l_valueset_id fnd_descr_flex_col_usage_vl.flex_value_set_id%TYPE;
4842: p_region IN per_addresses.region_1%TYPE)
4843: RETURN VARCHAR2
4844: AS
4845: l_dflex_r fnd_dflex.dflex_r;
4846: l_dflex_dr fnd_dflex.dflex_dr;
4847: l_contexts_dr fnd_dflex.contexts_dr;
4848: l_segments_dr fnd_dflex.segments_dr;
4849: l_valueset_id fnd_descr_flex_col_usage_vl.flex_value_set_id%TYPE;
4850: l_vset_r fnd_vset.valueset_r;
4843: RETURN VARCHAR2
4844: AS
4845: l_dflex_r fnd_dflex.dflex_r;
4846: l_dflex_dr fnd_dflex.dflex_dr;
4847: l_contexts_dr fnd_dflex.contexts_dr;
4848: l_segments_dr fnd_dflex.segments_dr;
4849: l_valueset_id fnd_descr_flex_col_usage_vl.flex_value_set_id%TYPE;
4850: l_vset_r fnd_vset.valueset_r;
4851: l_value_dr fnd_vset.value_dr;
4844: AS
4845: l_dflex_r fnd_dflex.dflex_r;
4846: l_dflex_dr fnd_dflex.dflex_dr;
4847: l_contexts_dr fnd_dflex.contexts_dr;
4848: l_segments_dr fnd_dflex.segments_dr;
4849: l_valueset_id fnd_descr_flex_col_usage_vl.flex_value_set_id%TYPE;
4850: l_vset_r fnd_vset.valueset_r;
4851: l_value_dr fnd_vset.value_dr;
4852: l_vset_dr fnd_vset.valueset_dr;
4863: OR AP_WEB_CUST_DFLEX_PKG.CustomGetCountyProvince(p_addressstyle, l_region) then
4864: return l_region;
4865: END IF;
4866:
4867: fnd_dflex.get_flexfield('PER','Address Structure',l_dflex_r,l_dflex_dr);
4868: fnd_dflex.get_segments(fnd_dflex.make_context(l_dflex_r,p_addressStyle),l_segments_dr,TRUE);
4869:
4870: FOR i IN 1 .. l_segments_dr.nsegments LOOP
4871: IF (UPPER(l_segments_dr.segment_name(i)) IN ('COUNTY','PROVINCE')) THEN
4864: return l_region;
4865: END IF;
4866:
4867: fnd_dflex.get_flexfield('PER','Address Structure',l_dflex_r,l_dflex_dr);
4868: fnd_dflex.get_segments(fnd_dflex.make_context(l_dflex_r,p_addressStyle),l_segments_dr,TRUE);
4869:
4870: FOR i IN 1 .. l_segments_dr.nsegments LOOP
4871: IF (UPPER(l_segments_dr.segment_name(i)) IN ('COUNTY','PROVINCE')) THEN
4872: l_valueset_id := l_segments_dr.value_set(i);