3918: ******************************************************************************/
3919: FUNCTION Get_Context(p_FlexField_Name IN VARCHAR2
3920: ,p_context IN VARCHAR2)RETURN VARCHAR2 IS
3921:
3922: Flexfield FND_DFLEX.dflex_r;
3923: Flexinfo FND_DFLEX.dflex_dr;
3924: Contexts FND_DFLEX.contexts_dr;
3925:
3926:
3919: FUNCTION Get_Context(p_FlexField_Name IN VARCHAR2
3920: ,p_context IN VARCHAR2)RETURN VARCHAR2 IS
3921:
3922: Flexfield FND_DFLEX.dflex_r;
3923: Flexinfo FND_DFLEX.dflex_dr;
3924: Contexts FND_DFLEX.contexts_dr;
3925:
3926:
3927: x_context_code VARCHAR2(240);
3920: ,p_context IN VARCHAR2)RETURN VARCHAR2 IS
3921:
3922: Flexfield FND_DFLEX.dflex_r;
3923: Flexinfo FND_DFLEX.dflex_dr;
3924: Contexts FND_DFLEX.contexts_dr;
3925:
3926:
3927: x_context_code VARCHAR2(240);
3928:
3929: BEGIN
3930:
3931: -- Call Flexapi to get contexts
3932:
3933: FND_DFLEX.get_flexfield('QP',p_FlexField_Name,Flexfield,Flexinfo);
3934: FND_DFLEX.get_contexts(Flexfield,Contexts);
3935:
3936:
3937: For i in 1..Contexts.ncontexts LOOP
3930:
3931: -- Call Flexapi to get contexts
3932:
3933: FND_DFLEX.get_flexfield('QP',p_FlexField_Name,Flexfield,Flexinfo);
3934: FND_DFLEX.get_contexts(Flexfield,Contexts);
3935:
3936:
3937: For i in 1..Contexts.ncontexts LOOP
3938:
3961: ,p_Context_Name IN VARCHAR2
3962: ,p_attribute IN VARCHAR2
3963: ) RETURN VARCHAR2 IS
3964:
3965: Flexfield FND_DFLEX.dflex_r;
3966: Flexinfo FND_DFLEX.dflex_dr;
3967: Contexts FND_DFLEX.contexts_dr;
3968: segments FND_DFLEX.segments_dr;
3969: i BINARY_INTEGER;
3962: ,p_attribute IN VARCHAR2
3963: ) RETURN VARCHAR2 IS
3964:
3965: Flexfield FND_DFLEX.dflex_r;
3966: Flexinfo FND_DFLEX.dflex_dr;
3967: Contexts FND_DFLEX.contexts_dr;
3968: segments FND_DFLEX.segments_dr;
3969: i BINARY_INTEGER;
3970: x_attribute_code VARCHAR2(240) := NULL;
3963: ) RETURN VARCHAR2 IS
3964:
3965: Flexfield FND_DFLEX.dflex_r;
3966: Flexinfo FND_DFLEX.dflex_dr;
3967: Contexts FND_DFLEX.contexts_dr;
3968: segments FND_DFLEX.segments_dr;
3969: i BINARY_INTEGER;
3970: x_attribute_code VARCHAR2(240) := NULL;
3971:
3964:
3965: Flexfield FND_DFLEX.dflex_r;
3966: Flexinfo FND_DFLEX.dflex_dr;
3967: Contexts FND_DFLEX.contexts_dr;
3968: segments FND_DFLEX.segments_dr;
3969: i BINARY_INTEGER;
3970: x_attribute_code VARCHAR2(240) := NULL;
3971:
3972: BEGIN
3975: --fnd_message.debug('passsed values are ' ||p_Context_Name);
3976: --fnd_message.debug('passsed values are ' ||p_attribute);
3977:
3978:
3979: FND_DFLEX.get_flexfield('QP',p_FlexField_Name,Flexfield,Flexinfo);
3980: FND_DFLEX.get_segments(FND_DFLEX.make_context(Flexfield,p_Context_Name),
3981: segments,TRUE);
3982:
3983: For i in 1..segments.nsegments LOOP
3976: --fnd_message.debug('passsed values are ' ||p_attribute);
3977:
3978:
3979: FND_DFLEX.get_flexfield('QP',p_FlexField_Name,Flexfield,Flexinfo);
3980: FND_DFLEX.get_segments(FND_DFLEX.make_context(Flexfield,p_Context_Name),
3981: segments,TRUE);
3982:
3983: For i in 1..segments.nsegments LOOP
3984:
4219: ,p_Context_Name IN VARCHAR2
4220: ,p_attribute IN VARCHAR2
4221: ) RETURN VARCHAR2 IS
4222:
4223: Flexfield FND_DFLEX.dflex_r;
4224: Flexinfo FND_DFLEX.dflex_dr;
4225: Contexts FND_DFLEX.contexts_dr;
4226: segments FND_DFLEX.segments_dr;
4227: i BINARY_INTEGER;
4220: ,p_attribute IN VARCHAR2
4221: ) RETURN VARCHAR2 IS
4222:
4223: Flexfield FND_DFLEX.dflex_r;
4224: Flexinfo FND_DFLEX.dflex_dr;
4225: Contexts FND_DFLEX.contexts_dr;
4226: segments FND_DFLEX.segments_dr;
4227: i BINARY_INTEGER;
4228: x_segment_name VARCHAR2(240) := NULL;
4221: ) RETURN VARCHAR2 IS
4222:
4223: Flexfield FND_DFLEX.dflex_r;
4224: Flexinfo FND_DFLEX.dflex_dr;
4225: Contexts FND_DFLEX.contexts_dr;
4226: segments FND_DFLEX.segments_dr;
4227: i BINARY_INTEGER;
4228: x_segment_name VARCHAR2(240) := NULL;
4229:
4222:
4223: Flexfield FND_DFLEX.dflex_r;
4224: Flexinfo FND_DFLEX.dflex_dr;
4225: Contexts FND_DFLEX.contexts_dr;
4226: segments FND_DFLEX.segments_dr;
4227: i BINARY_INTEGER;
4228: x_segment_name VARCHAR2(240) := NULL;
4229:
4230: l_pte_code VARCHAR2(30);
4292:
4293: /* Commented out for 2332139 */
4294: /*
4295:
4296: FND_DFLEX.get_flexfield('QP',p_FlexField_Name,Flexfield,Flexinfo);
4297: FND_DFLEX.get_segments(FND_DFLEX.make_context(Flexfield,p_Context_Name),
4298: segments,TRUE);
4299:
4300: FOR i IN 1..segments.nsegments LOOP
4293: /* Commented out for 2332139 */
4294: /*
4295:
4296: FND_DFLEX.get_flexfield('QP',p_FlexField_Name,Flexfield,Flexinfo);
4297: FND_DFLEX.get_segments(FND_DFLEX.make_context(Flexfield,p_Context_Name),
4298: segments,TRUE);
4299:
4300: FOR i IN 1..segments.nsegments LOOP
4301: