DBA Data[Home] [Help]

APPS.CHV_CUM_PERIODS_S2 dependencies on CHV_CUM_PERIODS

Line 1: PACKAGE BODY CHV_CUM_PERIODS_S2 as

1: PACKAGE BODY CHV_CUM_PERIODS_S2 as
2: /* $Header: CHVCUMPB.pls 120.2.12020000.2 2013/02/10 18:19:18 vegajula ship $ */
3:
4: /*========================= CHV_CUM_PERIODS =================================*/
5:

Line 4: /*========================= CHV_CUM_PERIODS =================================*/

1: PACKAGE BODY CHV_CUM_PERIODS_S2 as
2: /* $Header: CHVCUMPB.pls 120.2.12020000.2 2013/02/10 18:19:18 vegajula ship $ */
3:
4: /*========================= CHV_CUM_PERIODS =================================*/
5:
6: /*=============================================================================
7:
8: PROCEDURE NAME: get_cum_info()

Line 121: FROM chv_cum_periods

117: cum_period_end_date
118: INTO x_cum_period_id,
119: x_cum_period_start_date,
120: x_cum_period_end_date
121: FROM chv_cum_periods
122: WHERE organization_id = x_organization_id
123: AND x_horizon_start_date BETWEEN cum_period_start_date
124: AND nvl(cum_period_end_date,x_horizon_start_date+1);
125:

Line 257: chv_cum_periods_s1.get_cum_qty_received(x_vendor_id,

253:
254: -- Get the CUM quantity received for the item.
255: x_progress := '030';
256:
257: chv_cum_periods_s1.get_cum_qty_received(x_vendor_id,
258: x_vendor_site_id,
259: x_item_id,
260: x_organization_id,
261: x_rtv_update_cum_flag,

Line 331: END CHV_CUM_PERIODS_S2;

327: RAISE;
328:
329: END get_cum_info;
330:
331: END CHV_CUM_PERIODS_S2;