[Home] [Help]
1877: CREATED_BY,
1878: LAST_UPDATE_LOGIN
1879: )
1880: VALUES (
1881: pa_fin_plan_amount_sets_s.NEXTVAL,
1882: 'COST',
1883: p_raw_cost_flag,
1884: p_burdened_cost_flag,
1885: p_cost_qty_flag,
1902: sysdate,
1903: fnd_global.user_id,
1904: fnd_global.login_id) RETURNING FIN_PLAN_AMOUNT_SET_ID INTO x_cost_amount_set_id;
1905:
1906: --SELECT pa_fin_plan_amount_sets_s.currval
1907: --into x_cost_amount_set_id
1908: --from dual;
1909:
1910: END IF;
1983: CREATED_BY,
1984: LAST_UPDATE_LOGIN
1985: )
1986: VALUES (
1987: pa_fin_plan_amount_sets_s.NEXTVAL,
1988: 'REVENUE',
1989: 'N',
1990: 'N',
1991: 'N',
2009: fnd_global.user_id,
2010: fnd_global.login_id)
2011: RETURNING FIN_PLAN_AMOUNT_SET_ID INTO x_revenue_amount_set_id;
2012:
2013: --select pa_fin_plan_amount_sets_s.currval
2014: --into x_revenue_amount_set_id
2015: --from dual;
2016:
2017: END IF;
2087: CREATED_BY,
2088: LAST_UPDATE_LOGIN
2089: )
2090: VALUES (
2091: pa_fin_plan_amount_sets_s.NEXTVAL,
2092: 'ALL',
2093: p_raw_cost_flag,
2094: p_burdened_cost_flag,
2095: 'N',
2113: fnd_global.user_id,
2114: fnd_global.login_id)
2115: RETURNING FIN_PLAN_AMOUNT_SET_ID INTO x_all_amount_set_id;
2116:
2117: --select pa_fin_plan_amount_sets_s.currval
2118: --into x_all_amount_set_id
2119: --from dual;
2120: END IF;
2121: END IF; -- cost and revenue