DBA Data[Home] [Help]

APPS.RCV_TRANSACTIONS_INTERFACE_SV1 dependencies on CHV_CUM_PERIODS

Line 949: x_cum_period_start_date chv_cum_periods.cum_period_start_date%TYPE;

945: x_supply_agreement_flag po_headers.supply_agreement_flag%TYPE := 'Y';
946: x_success VARCHAR2(1) := NULL;
947: x_progress VARCHAR2(3);
948: x_rtv_update_cum_flag chv_org_options.rtv_update_cum_flag%TYPE;
949: x_cum_period_start_date chv_cum_periods.cum_period_start_date%TYPE;
950: x_cum_period_end_date chv_cum_periods.cum_period_end_date%TYPE;
951: x_continue BOOLEAN := TRUE;
952: x_qty_received_primary NUMBER;
953: x_qty_received_purchasing NUMBER;

Line 950: x_cum_period_end_date chv_cum_periods.cum_period_end_date%TYPE;

946: x_success VARCHAR2(1) := NULL;
947: x_progress VARCHAR2(3);
948: x_rtv_update_cum_flag chv_org_options.rtv_update_cum_flag%TYPE;
949: x_cum_period_start_date chv_cum_periods.cum_period_start_date%TYPE;
950: x_cum_period_end_date chv_cum_periods.cum_period_end_date%TYPE;
951: x_continue BOOLEAN := TRUE;
952: x_qty_received_primary NUMBER;
953: x_qty_received_purchasing NUMBER;
954: x_total_cum_shipped NUMBER;

Line 1018: FROM chv_cum_periods

1014: SELECT cum_period_start_date,
1015: cum_period_end_date
1016: INTO x_cum_period_start_date,
1017: x_cum_period_end_date
1018: FROM chv_cum_periods
1019: WHERE organization_id = x_cum_quantity_record.to_organization_id
1020: AND x_cum_quantity_record.transaction_date BETWEEN cum_period_start_date AND cum_period_end_date;
1021:
1022: IF (g_asn_debug = 'Y') THEN

Line 1039: asn_debug.put_line('Call to chv_cum_periods_s1.get_cum_qty_received');

1035:
1036: IF (x_cum_quantity_record.item_id IS NOT NULL) THEN
1037: IF (x_continue) THEN
1038: IF (g_asn_debug = 'Y') THEN
1039: asn_debug.put_line('Call to chv_cum_periods_s1.get_cum_qty_received');
1040: END IF;
1041:
1042: chv_cum_periods_s1.get_cum_qty_received(x_cum_quantity_record.vendor_id,
1043: x_cum_quantity_record.vendor_site_id,

Line 1042: chv_cum_periods_s1.get_cum_qty_received(x_cum_quantity_record.vendor_id,

1038: IF (g_asn_debug = 'Y') THEN
1039: asn_debug.put_line('Call to chv_cum_periods_s1.get_cum_qty_received');
1040: END IF;
1041:
1042: chv_cum_periods_s1.get_cum_qty_received(x_cum_quantity_record.vendor_id,
1043: x_cum_quantity_record.vendor_site_id,
1044: x_cum_quantity_record.item_id,
1045: x_cum_quantity_record.to_organization_id,
1046: x_rtv_update_cum_flag,