4064: ******************************************************************************/
4065: FUNCTION Get_Context(p_FlexField_Name IN VARCHAR2
4066: ,p_context IN VARCHAR2)RETURN VARCHAR2 IS
4067:
4068: Flexfield FND_DFLEX.dflex_r;
4069: Flexinfo FND_DFLEX.dflex_dr;
4070: Contexts FND_DFLEX.contexts_dr;
4071:
4072:
4065: FUNCTION Get_Context(p_FlexField_Name IN VARCHAR2
4066: ,p_context IN VARCHAR2)RETURN VARCHAR2 IS
4067:
4068: Flexfield FND_DFLEX.dflex_r;
4069: Flexinfo FND_DFLEX.dflex_dr;
4070: Contexts FND_DFLEX.contexts_dr;
4071:
4072:
4073: x_context_code VARCHAR2(240);
4066: ,p_context IN VARCHAR2)RETURN VARCHAR2 IS
4067:
4068: Flexfield FND_DFLEX.dflex_r;
4069: Flexinfo FND_DFLEX.dflex_dr;
4070: Contexts FND_DFLEX.contexts_dr;
4071:
4072:
4073: x_context_code VARCHAR2(240);
4074:
4075: BEGIN
4076:
4077: -- Call Flexapi to get contexts
4078:
4079: FND_DFLEX.get_flexfield('QP',p_FlexField_Name,Flexfield,Flexinfo);
4080: FND_DFLEX.get_contexts(Flexfield,Contexts);
4081:
4082:
4083: For i in 1..Contexts.ncontexts LOOP
4076:
4077: -- Call Flexapi to get contexts
4078:
4079: FND_DFLEX.get_flexfield('QP',p_FlexField_Name,Flexfield,Flexinfo);
4080: FND_DFLEX.get_contexts(Flexfield,Contexts);
4081:
4082:
4083: For i in 1..Contexts.ncontexts LOOP
4084:
4107: ,p_Context_Name IN VARCHAR2
4108: ,p_attribute IN VARCHAR2
4109: ) RETURN VARCHAR2 IS
4110:
4111: Flexfield FND_DFLEX.dflex_r;
4112: Flexinfo FND_DFLEX.dflex_dr;
4113: Contexts FND_DFLEX.contexts_dr;
4114: segments FND_DFLEX.segments_dr;
4115: i BINARY_INTEGER;
4108: ,p_attribute IN VARCHAR2
4109: ) RETURN VARCHAR2 IS
4110:
4111: Flexfield FND_DFLEX.dflex_r;
4112: Flexinfo FND_DFLEX.dflex_dr;
4113: Contexts FND_DFLEX.contexts_dr;
4114: segments FND_DFLEX.segments_dr;
4115: i BINARY_INTEGER;
4116: x_attribute_code VARCHAR2(240) := NULL;
4109: ) RETURN VARCHAR2 IS
4110:
4111: Flexfield FND_DFLEX.dflex_r;
4112: Flexinfo FND_DFLEX.dflex_dr;
4113: Contexts FND_DFLEX.contexts_dr;
4114: segments FND_DFLEX.segments_dr;
4115: i BINARY_INTEGER;
4116: x_attribute_code VARCHAR2(240) := NULL;
4117:
4110:
4111: Flexfield FND_DFLEX.dflex_r;
4112: Flexinfo FND_DFLEX.dflex_dr;
4113: Contexts FND_DFLEX.contexts_dr;
4114: segments FND_DFLEX.segments_dr;
4115: i BINARY_INTEGER;
4116: x_attribute_code VARCHAR2(240) := NULL;
4117:
4118: BEGIN
4121: --fnd_message.debug('passsed values are ' ||p_Context_Name);
4122: --fnd_message.debug('passsed values are ' ||p_attribute);
4123:
4124:
4125: FND_DFLEX.get_flexfield('QP',p_FlexField_Name,Flexfield,Flexinfo);
4126: FND_DFLEX.get_segments(FND_DFLEX.make_context(Flexfield,p_Context_Name),
4127: segments,TRUE);
4128:
4129: For i in 1..segments.nsegments LOOP
4122: --fnd_message.debug('passsed values are ' ||p_attribute);
4123:
4124:
4125: FND_DFLEX.get_flexfield('QP',p_FlexField_Name,Flexfield,Flexinfo);
4126: FND_DFLEX.get_segments(FND_DFLEX.make_context(Flexfield,p_Context_Name),
4127: segments,TRUE);
4128:
4129: For i in 1..segments.nsegments LOOP
4130:
4365: ,p_Context_Name IN VARCHAR2
4366: ,p_attribute IN VARCHAR2
4367: ) RETURN VARCHAR2 IS
4368:
4369: Flexfield FND_DFLEX.dflex_r;
4370: Flexinfo FND_DFLEX.dflex_dr;
4371: Contexts FND_DFLEX.contexts_dr;
4372: segments FND_DFLEX.segments_dr;
4373: i BINARY_INTEGER;
4366: ,p_attribute IN VARCHAR2
4367: ) RETURN VARCHAR2 IS
4368:
4369: Flexfield FND_DFLEX.dflex_r;
4370: Flexinfo FND_DFLEX.dflex_dr;
4371: Contexts FND_DFLEX.contexts_dr;
4372: segments FND_DFLEX.segments_dr;
4373: i BINARY_INTEGER;
4374: x_segment_name VARCHAR2(240) := NULL;
4367: ) RETURN VARCHAR2 IS
4368:
4369: Flexfield FND_DFLEX.dflex_r;
4370: Flexinfo FND_DFLEX.dflex_dr;
4371: Contexts FND_DFLEX.contexts_dr;
4372: segments FND_DFLEX.segments_dr;
4373: i BINARY_INTEGER;
4374: x_segment_name VARCHAR2(240) := NULL;
4375:
4368:
4369: Flexfield FND_DFLEX.dflex_r;
4370: Flexinfo FND_DFLEX.dflex_dr;
4371: Contexts FND_DFLEX.contexts_dr;
4372: segments FND_DFLEX.segments_dr;
4373: i BINARY_INTEGER;
4374: x_segment_name VARCHAR2(240) := NULL;
4375:
4376: l_pte_code VARCHAR2(30);
4438:
4439: /* Commented out for 2332139 */
4440: /*
4441:
4442: FND_DFLEX.get_flexfield('QP',p_FlexField_Name,Flexfield,Flexinfo);
4443: FND_DFLEX.get_segments(FND_DFLEX.make_context(Flexfield,p_Context_Name),
4444: segments,TRUE);
4445:
4446: FOR i IN 1..segments.nsegments LOOP
4439: /* Commented out for 2332139 */
4440: /*
4441:
4442: FND_DFLEX.get_flexfield('QP',p_FlexField_Name,Flexfield,Flexinfo);
4443: FND_DFLEX.get_segments(FND_DFLEX.make_context(Flexfield,p_Context_Name),
4444: segments,TRUE);
4445:
4446: FOR i IN 1..segments.nsegments LOOP
4447: