2277: end if;
2278: open get_asg_details;
2279: fetch get_asg_details into l_person_name, l_assignment_number, l_element_type, l_auto_org_name;
2280: close get_asg_details;
2281: psp_enc_crt_xml.p_set_of_books_id := p_set_of_books_id;
2282: psp_enc_crt_xml.p_business_group_id := p_business_group_id;
2283: if l_acct_type = 'N' then
2284: l_account :=
2285: psp_enc_crt_xml.cf_charging_instformula(l_susp_glccid,
2278: open get_asg_details;
2279: fetch get_asg_details into l_person_name, l_assignment_number, l_element_type, l_auto_org_name;
2280: close get_asg_details;
2281: psp_enc_crt_xml.p_set_of_books_id := p_set_of_books_id;
2282: psp_enc_crt_xml.p_business_group_id := p_business_group_id;
2283: if l_acct_type = 'N' then
2284: l_account :=
2285: psp_enc_crt_xml.cf_charging_instformula(l_susp_glccid,
2286: null,
2281: psp_enc_crt_xml.p_set_of_books_id := p_set_of_books_id;
2282: psp_enc_crt_xml.p_business_group_id := p_business_group_id;
2283: if l_acct_type = 'N' then
2284: l_account :=
2285: psp_enc_crt_xml.cf_charging_instformula(l_susp_glccid,
2286: null,
2287: null,
2288: null,
2289: null,
2289: null,
2290: null);
2291: else
2292: l_account :=
2293: psp_enc_crt_xml.cf_charging_instformula(null,
2294: l_project_id,
2295: l_task_id,
2296: l_award_id,
2297: l_expenditure_type,
5012: fetch get_asg_details into l_person_name, l_assignment_number, l_element_type, l_auto_org_name;
5013: fnd_file.put_line(fnd_file.log, fnd_date.date_to_canonical(SYSDATE) || ' l_person_name, l_assignment_number, l_element_type, l_auto_org_name'||l_person_name||','|| l_assignment_number||','|| l_element_type||','|| l_auto_org_name);
5014:
5015: close get_asg_details;
5016: psp_enc_crt_xml.p_set_of_books_id := p_set_of_books_id;
5017: psp_enc_crt_xml.p_business_group_id := p_business_group_id;
5018: if l_acct_type = 'N' then
5019: l_account :=
5020: psp_enc_crt_xml.cf_charging_instformula(l_new_glccid,
5013: fnd_file.put_line(fnd_file.log, fnd_date.date_to_canonical(SYSDATE) || ' l_person_name, l_assignment_number, l_element_type, l_auto_org_name'||l_person_name||','|| l_assignment_number||','|| l_element_type||','|| l_auto_org_name);
5014:
5015: close get_asg_details;
5016: psp_enc_crt_xml.p_set_of_books_id := p_set_of_books_id;
5017: psp_enc_crt_xml.p_business_group_id := p_business_group_id;
5018: if l_acct_type = 'N' then
5019: l_account :=
5020: psp_enc_crt_xml.cf_charging_instformula(l_new_glccid,
5021: null,
5016: psp_enc_crt_xml.p_set_of_books_id := p_set_of_books_id;
5017: psp_enc_crt_xml.p_business_group_id := p_business_group_id;
5018: if l_acct_type = 'N' then
5019: l_account :=
5020: psp_enc_crt_xml.cf_charging_instformula(l_new_glccid,
5021: null,
5022: null,
5023: null,
5024: null,
5024: null,
5025: null);
5026: else
5027: l_account :=
5028: psp_enc_crt_xml.cf_charging_instformula(null,
5029: l_project_id,
5030: l_task_id,
5031: l_award_id,
5032: l_new_expenditure_type,