DBA Data[Home] [Help]

APPS.AP_WEB_DFLEX_PKG dependencies on FND_VSET

Line 133: FUNCTION IsSegmentValidType(P_ValueSetInfo IN FND_VSET.VALUESET_R)

129: RETURN(P_Segments.description(P_Index) IS NOT NULL);
130: END IsSegmentWebEnabled;
131:
132: -------------------------------------------------------------------------------
133: FUNCTION IsSegmentValidType(P_ValueSetInfo IN FND_VSET.VALUESET_R)
134: RETURN BOOLEAN
135: -------------------------------------------------------------------------------
136: IS
137: BEGIN

Line 146: P_ValueSetInfo IN FND_VSET.VALUESET_R)

142:
143: -------------------------------------------------------------------------------
144: FUNCTION IsSegmentRendered(P_Segments IN FND_DFLEX.SEGMENTS_DR,
145: P_SegIndex IN NUMBER,
146: P_ValueSetInfo IN FND_VSET.VALUESET_R)
147: RETURN BOOLEAN
148: -------------------------------------------------------------------------------
149: IS
150: BEGIN

Line 184: PROCEDURE GetIndepSegmentEnabledValues(P_ValueSetInfo IN FND_VSET.VALUESET_R,

180:
181: END GetEnabledSegments;
182:
183: -------------------------------------------------------------------------------
184: PROCEDURE GetIndepSegmentEnabledValues(P_ValueSetInfo IN FND_VSET.VALUESET_R,
185: P_NumOfTableElem IN OUT NOCOPY NUMBER,
186: P_PoplistArray IN OUT NOCOPY PoplistValues_A)
187: -------------------------------------------------------------------------------
188: IS

Line 194: V_ValueInfo FND_VSET.VALUE_DR;

190: -- Returns the enabled independent validation values for the given
191: -- valueset in the P_PoplistArray.
192: --
193:
194: V_ValueInfo FND_VSET.VALUE_DR;
195: V_NumValueSetValue NUMBER;
196: V_Found BOOLEAN;
197: V_CurrentCallingSequence VARCHAR2(100);
198: V_DebugInfo VARCHAR2(100);

Line 204: FND_VSET.get_value_init(P_ValueSetInfo, TRUE);

200:
201: V_CurrentCallingSequence := 'AP_WEB_FLEX_PKG.GetIndepSegmentEnabledValues';
202:
203: P_NumOfTableElem := 0;
204: FND_VSET.get_value_init(P_ValueSetInfo, TRUE);
205:
206: FND_VSET.get_value(P_ValueSetInfo, V_NumValueSetValue, V_Found, V_ValueInfo);
207: WHILE V_Found LOOP
208:

Line 206: FND_VSET.get_value(P_ValueSetInfo, V_NumValueSetValue, V_Found, V_ValueInfo);

202:
203: P_NumOfTableElem := 0;
204: FND_VSET.get_value_init(P_ValueSetInfo, TRUE);
205:
206: FND_VSET.get_value(P_ValueSetInfo, V_NumValueSetValue, V_Found, V_ValueInfo);
207: WHILE V_Found LOOP
208:
209: IF (trunc(nvl(V_ValueInfo.start_date_active,sysdate)) <= trunc(sysdate)
210: AND trunc(nvl(V_ValueInfo.end_date_active,sysdate)) >= trunc(sysdate))

Line 218: FND_VSET.get_value(P_ValueSetInfo, V_NumValueSetValue, V_Found, V_ValueInfo);

214: P_PoplistArray(P_NumOfTableElem).InternalValue := V_ValueInfo.value;
215: P_PoplistArray(P_NumOfTableElem).DisplayText := V_ValueInfo.value;
216: END IF;
217:
218: FND_VSET.get_value(P_ValueSetInfo, V_NumValueSetValue, V_Found, V_ValueInfo);
219:
220: END LOOP;
221:
222: FND_VSET.get_value_end(P_ValueSetInfo);

Line 222: FND_VSET.get_value_end(P_ValueSetInfo);

218: FND_VSET.get_value(P_ValueSetInfo, V_NumValueSetValue, V_Found, V_ValueInfo);
219:
220: END LOOP;
221:
222: FND_VSET.get_value_end(P_ValueSetInfo);
223: EXCEPTION
224: WHEN OTHERS THEN
225: BEGIN
226: FND_MESSAGE.SET_NAME('SQLAP','AP_DEBUG');

Line 238: P_ValueSetInfo OUT NOCOPY FND_VSET.VALUESET_R,

234: END GetIndepSegmentEnabledValues;
235:
236: -------------------------------------------------------------------------------
237: PROCEDURE GetValueSet(P_ValueSetID IN NUMBER,
238: P_ValueSetInfo OUT NOCOPY FND_VSET.VALUESET_R,
239: P_ValueSetFormat OUT NOCOPY FND_VSET.VALUESET_DR)
240: -------------------------------------------------------------------------------
241: IS
242: -- Since segments without value sets are allowed, we're setting the

Line 239: P_ValueSetFormat OUT NOCOPY FND_VSET.VALUESET_DR)

235:
236: -------------------------------------------------------------------------------
237: PROCEDURE GetValueSet(P_ValueSetID IN NUMBER,
238: P_ValueSetInfo OUT NOCOPY FND_VSET.VALUESET_R,
239: P_ValueSetFormat OUT NOCOPY FND_VSET.VALUESET_DR)
240: -------------------------------------------------------------------------------
241: IS
242: -- Since segments without value sets are allowed, we're setting the
243: -- values in P_ValueSetInfo and P_ValueSetFormat used throughout the

Line 253: FND_VSET.Get_valueset(P_ValueSetID, P_ValueSetInfo, P_ValueSetFormat);

249: -- If value set assigned to segment, then get appropriate information
250: -- from Get_valueset output. The V_ValueSetInfo will only be referenced
251: -- if it is an independent-validated type value set.
252:
253: FND_VSET.Get_valueset(P_ValueSetID, P_ValueSetInfo, P_ValueSetFormat);
254:
255: ELSE
256:
257: -- If no value set assigned to segment, treat it as a none-validated

Line 553: V_ValueSetInfo FND_VSET.VALUESET_R;

549: -- Generates the HTML input objects (SELECT, TEXT, HIDDEN, CHECKBOX) for the
550: -- particular flexfield segment.
551: --
552:
553: V_ValueSetInfo FND_VSET.VALUESET_R;
554: V_ValueSetFormat FND_VSET.VALUESET_DR;
555: V_PoplistArray PoplistValues_A;
556: V_SegDefaultValue VARCHAR2(240);
557: V_NumOfTableElem NUMBER;

Line 554: V_ValueSetFormat FND_VSET.VALUESET_DR;

550: -- particular flexfield segment.
551: --
552:
553: V_ValueSetInfo FND_VSET.VALUESET_R;
554: V_ValueSetFormat FND_VSET.VALUESET_DR;
555: V_PoplistArray PoplistValues_A;
556: V_SegDefaultValue VARCHAR2(240);
557: V_NumOfTableElem NUMBER;
558: V_CheckboxChecked VARCHAR2(100);

Line 952: V_ValueSetInfo FND_VSET.VALUESET_R;

948: V_Context FND_DFLEX.CONTEXT_R;
949: V_Segments FND_DFLEX.SEGMENTS_DR;
950: V_IsFlexFieldUsed BOOLEAN;
951:
952: V_ValueSetInfo FND_VSET.VALUESET_R;
953: V_ValueSetFormat FND_VSET.VALUESET_DR;
954:
955: V_CurrentCallingSequence VARCHAR2(100) := 'PopulateCustomDefaultValues';
956: V_DebugInfo VARCHAR2(100);

Line 953: V_ValueSetFormat FND_VSET.VALUESET_DR;

949: V_Segments FND_DFLEX.SEGMENTS_DR;
950: V_IsFlexFieldUsed BOOLEAN;
951:
952: V_ValueSetInfo FND_VSET.VALUESET_R;
953: V_ValueSetFormat FND_VSET.VALUESET_DR;
954:
955: V_CurrentCallingSequence VARCHAR2(100) := 'PopulateCustomDefaultValues';
956: V_DebugInfo VARCHAR2(100);
957: TEST EXCEPTION;

Line 1147: V_ValueSetInfo FND_VSET.VALUESET_R;

1143: IS
1144:
1145: V_DefaultTaxCodeUpdateable VARCHAR2(1);
1146: V_DefaultTaxCode ZX_WEBEXP_CLASSIFICATIONS_V.LOOKUP_CODE%TYPE;--bug#14798565
1147: V_ValueSetInfo FND_VSET.VALUESET_R;
1148: V_ValueSetFormat FND_VSET.VALUESET_DR;
1149:
1150: V_CurrentCallingSequence VARCHAR2(100) := 'PopulatePseudoDefaultValues';
1151: V_DebugInfo VARCHAR2(100);

Line 1148: V_ValueSetFormat FND_VSET.VALUESET_DR;

1144:
1145: V_DefaultTaxCodeUpdateable VARCHAR2(1);
1146: V_DefaultTaxCode ZX_WEBEXP_CLASSIFICATIONS_V.LOOKUP_CODE%TYPE;--bug#14798565
1147: V_ValueSetInfo FND_VSET.VALUESET_R;
1148: V_ValueSetFormat FND_VSET.VALUESET_DR;
1149:
1150: V_CurrentCallingSequence VARCHAR2(100) := 'PopulatePseudoDefaultValues';
1151: V_DebugInfo VARCHAR2(100);
1152: l_OrgId ap_expense_report_headers_all.org_id%TYPE;

Line 2175: V_ValueSetInfo FND_VSET.VALUESET_R;

2171: l_debug_info VARCHAR2(2000);
2172: l_curr_calling_sequence VARCHAR2(200) := 'ValidateReceiptCustomFields';
2173: l_dflex_enabled VARCHAR2(1) := NULL;
2174: l_num_of_cust_fields BINARY_INTEGER := NULL;
2175: V_ValueSetInfo FND_VSET.VALUESET_R;
2176: V_ValueSetFormat FND_VSET.VALUESET_DR;
2177: V_Date DATE;
2178: V_Date_Format VARCHAR2(30);
2179: p_format_type VARCHAR2(1);

Line 2176: V_ValueSetFormat FND_VSET.VALUESET_DR;

2172: l_curr_calling_sequence VARCHAR2(200) := 'ValidateReceiptCustomFields';
2173: l_dflex_enabled VARCHAR2(1) := NULL;
2174: l_num_of_cust_fields BINARY_INTEGER := NULL;
2175: V_ValueSetInfo FND_VSET.VALUESET_R;
2176: V_ValueSetFormat FND_VSET.VALUESET_DR;
2177: V_Date DATE;
2178: V_Date_Format VARCHAR2(30);
2179: p_format_type VARCHAR2(1);
2180: p_number_precision NUMBER(2);