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 115.6 2003/08/13 08:53:45 nprattip 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 300: chv_cum_periods ccp

296:
297: select sum(adjustment_quantity)
298: into x_adjustment_quantity
299: from chv_cum_adjustments cha,
300: chv_cum_periods ccp
301: where cha.organization_id = X_organization_id
302: and cha.vendor_id = X_vendor_id
303: and cha.vendor_site_id = X_vendor_site_id
304: and cha.item_id = X_item_id

Line 513: chv_cum_periods ccp

509: */
510: select sum(adjustment_quantity)
511: into x_adjustment_quantity
512: from chv_cum_adjustments cha,
513: chv_cum_periods ccp
514: where cha.organization_id = X_organization_id
515: and cha.vendor_id = X_vendor_id
516: and cha.vendor_site_id = X_vendor_site_id
517: and cha.item_id = X_item_id

Line 562: END CHV_CUM_PERIODS_S1;

558: raise;
559:
560: END get_cum_qty_received;
561:
562: END CHV_CUM_PERIODS_S1;