DBA Data[Home] [Help]

APPS.CSP_PLAN_DETAILS_PKG dependencies on CSP_PLAN_HISTORIES

Line 3259: insert into csp_plan_histories(

3255: l_history_date date := sysdate;
3256: begin
3257:
3258:
3259: insert into csp_plan_histories(
3260: plan_detail_type,
3261: organization_id,
3262: inventory_item_id,
3263: parent_type,

Line 3390: delete from csp_plan_histories

3386: end;
3387:
3388: procedure purge_saved_plans(p_days number) is
3389: begin
3390: delete from csp_plan_histories
3391: where history_date < sysdate - p_days
3392: and organization_id = nvl(l_organization_id,organization_id);
3393: end;
3394:

Line 3447: from csp_plan_histories

3443: security_group_id,
3444: plan_detail_id,
3445: period_size,
3446: forecast_periods
3447: from csp_plan_histories
3448: where organization_id = p_organization_id
3449: and inventory_item_id = nvl(p_inventory_item_id,inventory_item_id)
3450: and history_date = p_history_date;
3451: end;