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.0.12000000.2 2007/04/28 09:01:28 vdurbhak 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.0.12000000.2 2007/04/28 09:01:28 vdurbhak ship $ */
3:
4: /*========================= CHV_CUM_PERIODS =================================*/
5:
6: /*=============================================================================
7:
8: PROCEDURE NAME: get_cum_info()

Line 115: FROM chv_cum_periods

111: cum_period_end_date
112: INTO x_cum_period_id,
113: x_cum_period_start_date,
114: x_cum_period_end_date
115: FROM chv_cum_periods
116: WHERE organization_id = x_organization_id
117: AND x_horizon_start_date BETWEEN cum_period_start_date
118: AND nvl(cum_period_end_date,x_horizon_start_date+1);
119:

Line 251: chv_cum_periods_s1.get_cum_qty_received(x_vendor_id,

247:
248: -- Get the CUM quantity received for the item.
249: x_progress := '030';
250:
251: chv_cum_periods_s1.get_cum_qty_received(x_vendor_id,
252: x_vendor_site_id,
253: x_item_id,
254: x_organization_id,
255: x_rtv_update_cum_flag,

Line 325: END CHV_CUM_PERIODS_S2;

321: RAISE;
322:
323: END get_cum_info;
324:
325: END CHV_CUM_PERIODS_S2;