DBA Data[Home] [Help]

APPS.AP_WEB_DB_EXPLINE_PKG dependencies on FND_DFLEX

Line 1234: l_flexfield FND_DFLEX.DFLEX_R;

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',

Line 1235: l_flexinfo FND_DFLEX.DFLEX_DR;

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,

Line 1238: FND_DFLEX.Get_Flexfield('SQLAP',

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:

Line 4845: l_dflex_r fnd_dflex.dflex_r;

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;

Line 4846: l_dflex_dr fnd_dflex.dflex_dr;

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;

Line 4847: l_contexts_dr fnd_dflex.contexts_dr;

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;

Line 4848: l_segments_dr fnd_dflex.segments_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;

Line 4867: fnd_dflex.get_flexfield('PER','Address Structure',l_dflex_r,l_dflex_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

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

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);