DBA Data[Home] [Help]

APPS.AP_WEB_DISC_PKG dependencies on FND_DFLEX

Line 88: p_segments in out nocopy FND_DFLEX.SEGMENTS_DR);

84: return boolean;
85:
86:
87: procedure getFlexFieldGlobalSegments(p_user_id in NUMBER, -- Bug 2242176
88: p_segments in out nocopy FND_DFLEX.SEGMENTS_DR);
89:
90: procedure getAllSegmentPrompts(p_user_id in NUMBER, -- Bug 2242176
91: p_report_header_info in AP_WEB_DFLEX_PKG.ExpReportHeaderRec,
92: p_segmentPromptTable in out nocopy segmentPrompt_table);

Line 240: l_segments FND_DFLEX.SEGMENTS_DR; -- For Flexfield global segments

236: l_AllowOverriderFlag varchar2(1) := 'N';
237: l_ApprReqCC varchar2(1) := 'N';
238: l_OverriderReq varchar2(1) := 'N';
239: zero_prompts_found varchar2(200) := 'No prompts found';
240: l_segments FND_DFLEX.SEGMENTS_DR; -- For Flexfield global segments
241:
242: BEGIN
243:
244: Disc_GetPrompts(l_region_code, p_table);

Line 3107: l_segments (FND_DFLEX.SEGMENTS_DR): Segments data for the global flexfield

3103: None
3104: Output:
3105: None
3106: Input Output:
3107: l_segments (FND_DFLEX.SEGMENTS_DR): Segments data for the global flexfield
3108: Assumption:
3109: The application is WEB
3110: The flexfield is EXPENSE AP_EXPENSE_REPORT_LINES
3111: Date:

Line 3115: p_segments in out nocopy FND_DFLEX.SEGMENTS_DR) is

3111: Date:
3112: 11/25/98
3113: */
3114: procedure getFlexFieldGlobalSegments(p_user_id in NUMBER, -- 2242176
3115: p_segments in out nocopy FND_DFLEX.SEGMENTS_DR) is
3116: l_DFlexField FND_DFLEX.DFLEX_R;
3117: l_DFlexInfo FND_DFLEX.DFLEX_DR;
3118: l_Contexts FND_DFLEX.CONTEXTS_DR;
3119: l_Context FND_DFLEX.CONTEXT_R;

Line 3116: l_DFlexField FND_DFLEX.DFLEX_R;

3112: 11/25/98
3113: */
3114: procedure getFlexFieldGlobalSegments(p_user_id in NUMBER, -- 2242176
3115: p_segments in out nocopy FND_DFLEX.SEGMENTS_DR) is
3116: l_DFlexField FND_DFLEX.DFLEX_R;
3117: l_DFlexInfo FND_DFLEX.DFLEX_DR;
3118: l_Contexts FND_DFLEX.CONTEXTS_DR;
3119: l_Context FND_DFLEX.CONTEXT_R;
3120: l_IsFlexFieldUsed BOOLEAN;

Line 3117: l_DFlexInfo FND_DFLEX.DFLEX_DR;

3113: */
3114: procedure getFlexFieldGlobalSegments(p_user_id in NUMBER, -- 2242176
3115: p_segments in out nocopy FND_DFLEX.SEGMENTS_DR) is
3116: l_DFlexField FND_DFLEX.DFLEX_R;
3117: l_DFlexInfo FND_DFLEX.DFLEX_DR;
3118: l_Contexts FND_DFLEX.CONTEXTS_DR;
3119: l_Context FND_DFLEX.CONTEXT_R;
3120: l_IsFlexFieldUsed BOOLEAN;
3121: l_DebugInfo VARCHAR2(100);

Line 3118: l_Contexts FND_DFLEX.CONTEXTS_DR;

3114: procedure getFlexFieldGlobalSegments(p_user_id in NUMBER, -- 2242176
3115: p_segments in out nocopy FND_DFLEX.SEGMENTS_DR) is
3116: l_DFlexField FND_DFLEX.DFLEX_R;
3117: l_DFlexInfo FND_DFLEX.DFLEX_DR;
3118: l_Contexts FND_DFLEX.CONTEXTS_DR;
3119: l_Context FND_DFLEX.CONTEXT_R;
3120: l_IsFlexFieldUsed BOOLEAN;
3121: l_DebugInfo VARCHAR2(100);
3122:

Line 3119: l_Context FND_DFLEX.CONTEXT_R;

3115: p_segments in out nocopy FND_DFLEX.SEGMENTS_DR) is
3116: l_DFlexField FND_DFLEX.DFLEX_R;
3117: l_DFlexInfo FND_DFLEX.DFLEX_DR;
3118: l_Contexts FND_DFLEX.CONTEXTS_DR;
3119: l_Context FND_DFLEX.CONTEXT_R;
3120: l_IsFlexFieldUsed BOOLEAN;
3121: l_DebugInfo VARCHAR2(100);
3122:
3123: begin

Line 3136: FND_DFLEX.Get_Segments(l_Context, p_segments, TRUE);

3132: -- Get information about the global context
3133: l_DebugInfo := 'Get information about the global context';
3134: l_Context.flexfield := l_DFlexField;
3135: l_Context.context_code := l_Contexts.context_code(l_Contexts.global_context);
3136: FND_DFLEX.Get_Segments(l_Context, p_segments, TRUE);
3137: end if;
3138:
3139: end getFlexFieldGlobalSegments;
3140:

Line 3165: l_DFlexField FND_DFLEX.DFLEX_R;

3161: */
3162: procedure getAllSegmentPrompts(p_user_id in NUMBER,
3163: p_report_header_info in AP_WEB_DFLEX_PKG.ExpReportHeaderRec,
3164: p_segmentPromptTable in out nocopy segmentPrompt_table) is
3165: l_DFlexField FND_DFLEX.DFLEX_R;
3166: l_DFlexInfo FND_DFLEX.DFLEX_DR;
3167: l_Contexts FND_DFLEX.CONTEXTS_DR;
3168: l_Context FND_DFLEX.CONTEXT_R;
3169: l_IsFlexFieldUsed BOOLEAN;

Line 3166: l_DFlexInfo FND_DFLEX.DFLEX_DR;

3162: procedure getAllSegmentPrompts(p_user_id in NUMBER,
3163: p_report_header_info in AP_WEB_DFLEX_PKG.ExpReportHeaderRec,
3164: p_segmentPromptTable in out nocopy segmentPrompt_table) is
3165: l_DFlexField FND_DFLEX.DFLEX_R;
3166: l_DFlexInfo FND_DFLEX.DFLEX_DR;
3167: l_Contexts FND_DFLEX.CONTEXTS_DR;
3168: l_Context FND_DFLEX.CONTEXT_R;
3169: l_IsFlexFieldUsed BOOLEAN;
3170: l_DebugInfo VARCHAR2(100);

Line 3167: l_Contexts FND_DFLEX.CONTEXTS_DR;

3163: p_report_header_info in AP_WEB_DFLEX_PKG.ExpReportHeaderRec,
3164: p_segmentPromptTable in out nocopy segmentPrompt_table) is
3165: l_DFlexField FND_DFLEX.DFLEX_R;
3166: l_DFlexInfo FND_DFLEX.DFLEX_DR;
3167: l_Contexts FND_DFLEX.CONTEXTS_DR;
3168: l_Context FND_DFLEX.CONTEXT_R;
3169: l_IsFlexFieldUsed BOOLEAN;
3170: l_DebugInfo VARCHAR2(100);
3171:

Line 3168: l_Context FND_DFLEX.CONTEXT_R;

3164: p_segmentPromptTable in out nocopy segmentPrompt_table) is
3165: l_DFlexField FND_DFLEX.DFLEX_R;
3166: l_DFlexInfo FND_DFLEX.DFLEX_DR;
3167: l_Contexts FND_DFLEX.CONTEXTS_DR;
3168: l_Context FND_DFLEX.CONTEXT_R;
3169: l_IsFlexFieldUsed BOOLEAN;
3170: l_DebugInfo VARCHAR2(100);
3171:
3172: l_segments FND_DFLEX.SEGMENTS_DR; -- For Flexfield global segments

Line 3172: l_segments FND_DFLEX.SEGMENTS_DR; -- For Flexfield global segments

3168: l_Context FND_DFLEX.CONTEXT_R;
3169: l_IsFlexFieldUsed BOOLEAN;
3170: l_DebugInfo VARCHAR2(100);
3171:
3172: l_segments FND_DFLEX.SEGMENTS_DR; -- For Flexfield global segments
3173: l_count number:=1;
3174: begin
3175: AP_WEB_DFLEX_PKG.GetExpenseLineDFlexInfo(p_user_id, l_DFlexField,
3176: l_DFlexInfo,

Line 3185: FND_DFLEX.Get_Segments(l_Context, l_segments, TRUE);

3181: -- Get the flexfield global prompts first
3182: l_DebugInfo := 'Get information about the global context';
3183: l_Context.flexfield := l_DFlexField;
3184: l_Context.context_code := l_Contexts.context_code(l_Contexts.global_context);
3185: FND_DFLEX.Get_Segments(l_Context, l_segments, TRUE);
3186:
3187:
3188: FOR i in 1..l_segments.nsegments LOOP
3189: if (l_segments.is_enabled(i)) then

Line 3206: FND_DFLEX.Get_Segments(l_Context, l_segments, TRUE);

3202: -- Get the rest(context) segments
3203: FOR i in 1..l_contexts.ncontexts LOOP
3204: if (i <> l_Contexts.global_context AND l_Contexts.is_enabled(i)) then
3205: l_Context.context_code := l_Contexts.context_code(i);
3206: FND_DFLEX.Get_Segments(l_Context, l_segments, TRUE);
3207: FOR j in 1..l_segments.nsegments LOOP
3208: p_segmentPromptTable(l_count).exptype := l_Contexts.context_code(i);/*context_name?*/
3209: p_segmentPromptTable(l_count).segment_num := l_segments.sequence(j);
3210: p_segmentPromptTable(l_count).prompt := l_segments.row_prompt(j);