2150: end if;
2151: open get_asg_details;
2152: fetch get_asg_details into l_person_name, l_assignment_number, l_element_type, l_auto_org_name;
2153: close get_asg_details;
2154: psp_enc_crt_xml.p_set_of_books_id := p_set_of_books_id;
2155: psp_enc_crt_xml.p_business_group_id := p_business_group_id;
2156: if l_acct_type = 'N' then
2157: l_account :=
2158: psp_enc_crt_xml.cf_charging_instformula(l_susp_glccid,
2151: open get_asg_details;
2152: fetch get_asg_details into l_person_name, l_assignment_number, l_element_type, l_auto_org_name;
2153: close get_asg_details;
2154: psp_enc_crt_xml.p_set_of_books_id := p_set_of_books_id;
2155: psp_enc_crt_xml.p_business_group_id := p_business_group_id;
2156: if l_acct_type = 'N' then
2157: l_account :=
2158: psp_enc_crt_xml.cf_charging_instformula(l_susp_glccid,
2159: null,
2154: psp_enc_crt_xml.p_set_of_books_id := p_set_of_books_id;
2155: psp_enc_crt_xml.p_business_group_id := p_business_group_id;
2156: if l_acct_type = 'N' then
2157: l_account :=
2158: psp_enc_crt_xml.cf_charging_instformula(l_susp_glccid,
2159: null,
2160: null,
2161: null,
2162: null,
2162: null,
2163: null);
2164: else
2165: l_account :=
2166: psp_enc_crt_xml.cf_charging_instformula(null,
2167: l_project_id,
2168: l_task_id,
2169: l_award_id,
2170: l_expenditure_type,
4675: end if;
4676: open get_asg_details;
4677: fetch get_asg_details into l_person_name, l_assignment_number, l_element_type, l_auto_org_name;
4678: close get_asg_details;
4679: psp_enc_crt_xml.p_set_of_books_id := p_set_of_books_id;
4680: psp_enc_crt_xml.p_business_group_id := p_business_group_id;
4681: if l_acct_type = 'N' then
4682: l_account :=
4683: psp_enc_crt_xml.cf_charging_instformula(l_new_glccid,
4676: open get_asg_details;
4677: fetch get_asg_details into l_person_name, l_assignment_number, l_element_type, l_auto_org_name;
4678: close get_asg_details;
4679: psp_enc_crt_xml.p_set_of_books_id := p_set_of_books_id;
4680: psp_enc_crt_xml.p_business_group_id := p_business_group_id;
4681: if l_acct_type = 'N' then
4682: l_account :=
4683: psp_enc_crt_xml.cf_charging_instformula(l_new_glccid,
4684: null,
4679: psp_enc_crt_xml.p_set_of_books_id := p_set_of_books_id;
4680: psp_enc_crt_xml.p_business_group_id := p_business_group_id;
4681: if l_acct_type = 'N' then
4682: l_account :=
4683: psp_enc_crt_xml.cf_charging_instformula(l_new_glccid,
4684: null,
4685: null,
4686: null,
4687: null,
4687: null,
4688: null);
4689: else
4690: l_account :=
4691: psp_enc_crt_xml.cf_charging_instformula(null,
4692: l_project_id,
4693: l_task_id,
4694: l_award_id,
4695: l_new_expenditure_type,