APPS.CHV_CUM_PERIODS_S1 dependencies on CHV_CUM_PERIODS

Line 1: PACKAGE BODY CHV_CUM_PERIODS_S1 as

1: PACKAGE BODY CHV_CUM_PERIODS_S1 as
2: /* $Header: CHVPRCQB.pls 120.1.12020000.2 2013/02/11 00:39:06 vegajula ship $ */
3:
4: /*===========================================================================
5:

Line 18: chv_cum_periods_s1.get_cum_qty_received(83,

14: BEGIN
15:
16: --dbms_output.put_line('before call');
17:
18: chv_cum_periods_s1.get_cum_qty_received(83,
19: 85,
20: 45050,
21: 205,
22: 'N',

Line 306: chv_cum_periods ccp

302:
303: select sum(adjustment_quantity)
304: into x_adjustment_quantity
305: from chv_cum_adjustments cha,
306: chv_cum_periods ccp
307: where cha.organization_id = X_organization_id
308: and cha.vendor_id = X_vendor_id
309: and cha.vendor_site_id = X_vendor_site_id
310: and cha.item_id = X_item_id

Line 519: chv_cum_periods ccp

515: */
516: select sum(adjustment_quantity)
517: into x_adjustment_quantity
518: from chv_cum_adjustments cha,
519: chv_cum_periods ccp
520: where cha.organization_id = X_organization_id
521: and cha.vendor_id = X_vendor_id
522: and cha.vendor_site_id = X_vendor_site_id
523: and cha.item_id = X_item_id

Line 568: END CHV_CUM_PERIODS_S1;

564: raise;
565:
566: END get_cum_qty_received;
567:
568: END CHV_CUM_PERIODS_S1;