APPS.RCV_TRANSACTIONS_INTERFACE_SV1 dependencies on CHV_ORG_OPTIONS

Line 137: x_cum_enabled chv_org_options.enable_cum_flag%TYPE := NULL;

133: x_unit_of_measure rcv_transactions_interface.unit_of_measure%TYPE := NULL;
134: x_unit_meas_lookup_code_lines po_lines.unit_meas_lookup_code%TYPE := NULL;
135: x_progress VARCHAR2(3);
136: x_new_conversion NUMBER := 0;
137: x_cum_enabled chv_org_options.enable_cum_flag%TYPE := NULL;
138: x_supply_agreement_flag po_headers.supply_agreement_flag%TYPE := NULL;
139: -- x_asl_uom chv_cum_period_items.purchasing_unit_of_measure%type := null;
140: x_asl_uom VARCHAR2(80) := NULL;
141: x_primary_unit_of_measure mtl_system_items.primary_unit_of_measure%TYPE := NULL;

Line 230: FROM chv_org_options

226: END IF;
227:
228: SELECT NVL(MAX(enable_cum_flag), 'F')
229: INTO x_cum_enabled
230: FROM chv_org_options
231: WHERE organization_id = NVL(x_uom_record.to_organization_id, organization_id);
232:
233: SELECT NVL(MAX(supply_agreement_flag), 'N')
234: INTO x_supply_agreement_flag

Line 948: x_rtv_update_cum_flag chv_org_options.rtv_update_cum_flag%TYPE;

944: ) IS
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;

Line 980: FROM chv_org_options

976:
977: IF (x_supply_agreement_flag <> 'N') THEN
978: SELECT MAX(enable_cum_flag)
979: INTO x_success
980: FROM chv_org_options
981: WHERE organization_id = NVL(x_cum_quantity_record.to_organization_id, organization_id);
982:
983: IF (g_asn_debug = 'Y') THEN
984: asn_debug.put_line('Enable cum flag ' || x_success);

Line 1000: FROM chv_org_options

996: -- first get the extra params you need to call get_cum_qty_received
997:
998: SELECT NVL(MAX(rtv_update_cum_flag), 'N')
999: INTO x_rtv_update_cum_flag
1000: FROM chv_org_options
1001: WHERE organization_id = x_cum_quantity_record.to_organization_id;
1002:
1003: IF (g_asn_debug = 'Y') THEN
1004: asn_debug.put_line('RTV update cum flag ' || x_rtv_update_cum_flag);