DBA Data[Home] [Help]

APPS.CN_COMP_PLAN_PVT dependencies on DUAL

Line 239: FROM DUAL;

235: l_comp_rec.attribute13,
236: l_comp_rec.attribute14,
237: l_comp_rec.attribute15,
238: l_comp_rec.org_id
239: FROM DUAL;
240:
241: -- *** Adding the org_id ***
242: l_comp_rec.org_id := p_comp_plan.org_id;
243:

Line 487: FROM DUAL;

483: SELECT DECODE (p_comp_plan.start_date, fnd_api.g_miss_date, TRUNC (l_old_comp_plan.start_date), TRUNC (p_comp_plan.start_date)),
484: DECODE (p_comp_plan.end_date, fnd_api.g_miss_date, TRUNC (l_old_comp_plan.end_date), TRUNC (p_comp_plan.end_date))
485: INTO l_start_date,
486: l_end_date
487: FROM DUAL;
488:
489: -- start date > end date
490: IF (l_end_date IS NOT NULL) AND (l_start_date > l_end_date)
491: THEN

Line 545: FROM DUAL;

541: l_attribute13,
542: l_attribute14,
543: l_attribute15,
544: l_org_id
545: FROM DUAL;
546:
547: -- 3. check object version number
548: IF l_old_comp_plan.object_version_number <> p_comp_plan.object_version_number
549: THEN

Line 1898: FROM DUAL;

1894: l_comp_plan_rec.attribute13,
1895: l_comp_plan_rec.attribute14,
1896: l_comp_plan_rec.attribute15,
1897: l_comp_plan_rec.org_id
1898: FROM DUAL;
1899:
1900: l_comp_plan_rec.object_version_number := 1;
1901:
1902: CN_PLANCOPY_UTIL_PVT.get_unique_name_for_component(p_comp_plan_id,