197:
198: -- Cursor to check the valid df context
199: cursor csr_style (c_context_code in varchar2) is
200: select dfc.descriptive_flex_context_code
201: from fnd_descr_flex_contexts dfc
202: where dfc.application_id = 800
203: and dfc.descriptive_flexfield_name = 'Person Developer DF'
204: and dfc.enabled_flag = 'Y';
205:
9713: --
9714: l_chk_per chk_party%rowtype;
9715: l_national_identifier per_people_f.national_identifier%type;
9716: l_party_id per_people_f.party_id%type;
9717: l_dff_ctx fnd_descr_flex_contexts.descriptive_flex_context_code%type;
9718:
9719: -- added by dbansal
9720: l_gre_name HR_ALL_ORGANIZATION_UNITS_TL.name%type;
9721: temp varchar2(20);