[Home] [Help]
521: CAP_EXCESS_TASK_ID,
522: CAP_EXCESS_EXP_ORG_ID,
523: CAP_EXCESS_EXP_TYPE)
524: VALUES(
525: PSP_DISTRIBUTION_LINES_S.NEXTVAL,
526: payroll_rec.PAYROLL_SUB_LINE_ID,
527: L_payroll_start_DATE,
528: L_EFFECTIVE_DATE,
529: L_DIST_AMOUNT,
4241: if p_dist_line_id is not null then
4242: -- commented first check and introduced above for bug fix 2463092
4243: hr_utility.trace('CDL process --> suspense account --> dist line not null ='||p_dist_line_id);
4244:
4245: update psp_distribution_lines set
4246: suspense_org_account_id = l_organization_account_id,
4247: suspense_reason_code= p_suspense_reason_code,
4248: gl_project_flag = l_gl_project_flag,
4249: effective_date = g_gl_effective_date, --- added for 2663344
4356: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
4357: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4358: END IF;
4359: else
4360: update psp_distribution_lines set
4361: suspense_reason_code= p_suspense_reason_code,
4362: suspense_org_Account_id= l_organization_account_id,
4363: gl_project_flag = l_gl_project_flag,
4364: effective_date = p_effective_date,
4471:
4472: -- commented above and introduced if condition below for bug fix 2463092
4473:
4474: if p_dist_line_id is not null then
4475: update psp_distribution_lines set
4476: suspense_reason_code= p_suspense_reason_code,
4477: suspense_org_Account_id= l_organization_account_id,
4478: gl_project_flag = l_gl_project_flag,
4479: effective_date = p_effective_date, --- added for 2663344
5089: CAP_EXCESS_TASK_ID,
5090: CAP_EXCESS_EXP_ORG_ID,
5091: CAP_EXCESS_EXP_TYPE)
5092: VALUES(
5093: PSP_DISTRIBUTION_LINES_S.NEXTVAL,
5094: L_PAYROLL_SUB_LINE_ID,
5095: L_DISTRIBUTION_DATE,
5096: L_EFFECTIVE_DATE,
5097: L_DISTRIBUTION_AMOUNT,
7322: end loop;
7323:
7324: for i in 1..t_dist_line_id.count
7325: loop
7326: select psp_distribution_lines_s.nextval
7327: into t_excess_line_id(i)
7328: from dual;
7329: end loop;
7330: