APPS.PA_FP_CI_INCLUDE_PKG dependencies on PA_CI_IMPACTS

Line 318: This api is called to create financial realted impacts in pa_ci_impacts during

314: END FP_CI_COPY_CONTROL_ITEMS;
315: --end of FP_CI_COPY_CONTROL_ITEMS
316:
317: /*=============================================================================
318: This api is called to create financial realted impacts in pa_ci_impacts during
319: change document inclusion or change document copy.
320:
321: 02-Jul-2004 rravipat Bug 3677924
322: Initial Creation

Line 370: FROM pa_ci_impacts a

366: -- note FINPLAN record is not compulsory
367: CURSOR get_source_ci_impacts
368: IS
369: SELECT a.*
370: FROM pa_ci_impacts a
371: WHERE a.ci_id = p_source_ci_id
372: AND a.impact_type_code IN ('FINPLAN_COST','FINPLAN_REVENUE','FINPLAN')
373: AND (a.impact_type_code = 'FINPLAN' OR
374: EXISTS (SELECT 1

Line 388: FROM pa_ci_impacts

384: IS
385: SELECT ci_impact_id, description, implementation_comment,
386: implementation_date, implemented_by, record_version_number,
387: impacted_task_id
388: FROM pa_ci_impacts
389: WHERE ci_id = p_target_ci_id
390: AND impact_type_code = l_impact_type_code;
391:
392: BEGIN

Line 497: pa_ci_impacts_pkg.insert_row(

493: l_implementation_date, l_implemented_by, l_record_ver_number, l_task_id;
494:
495: IF get_orig_info%notfound THEN
496: -- insert a new record to the new impact
497: pa_ci_impacts_pkg.insert_row(
498: l_rowid,
499: l_new_ci_impact_id,
500: p_target_ci_id,
501: rec.impact_type_code,

Line 518: pa_ci_impacts_pkg.update_row(

514: ELSE
515: l_temp2 := Substr(l_desp || ' ' || rec.description, 1, 4000);
516:
517: -- update the existing one
518: pa_ci_impacts_pkg.update_row(
519: l_ci_impact_id,
520: p_target_ci_id,
521: l_impact_type_code,
522: NULL,