APPS.RCV_ROI_TRANSACTION dependencies on RCV_PARAMETERS

Line 3451: l_asn_exists_code rcv_parameters.receipt_asn_exists_code%TYPE;

3447: x_secondary_available_qty NUMBER := 0;
3448: l_receipt_source_code rcv_shipment_headers.receipt_source_code%TYPE;
3449: l_shipment_line_status_code rcv_shipment_lines.shipment_line_status_code%TYPE;
3450: l_asn_line_flag rcv_shipment_lines.asn_line_flag%TYPE;
3451: l_asn_exists_code rcv_parameters.receipt_asn_exists_code%TYPE;
3452: l_does_asn_exist VARCHAR2(1) := 'N';
3453: l_asn_count NUMBER := 0;
3454: l_dist_count number; /* Bug#3746516 */
3455: l_rate_date po_headers.rate_date%type; /* Bug#3746516 */

Line 4040: from rcv_parameters

4036: -- Bug 6796920 Start
4037: BEGIN
4038: select blind_receiving_flag
4039: into l_blind_receiving_flag
4040: from rcv_parameters
4041: where organization_id = temp_cascaded_table(current_n).to_organization_id;
4042: EXCEPTION
4043: when others THEN
4044: NULL;

Line 4693: * Options window. Get the control code from rcv_parameters.

4689: );
4690:
4691: /* Bug 3296214.
4692: * We need to use the control actions set in the Receiving
4693: * Options window. Get the control code from rcv_parameters.
4694: * If the transaction type is RECEIVE and if there is an
4695: * ASN existing for that PO, then depending on this value
4696: * we should either allow or error out.
4697: */

Line 4718: from rcv_parameters

4714: end if;
4715: else
4716: select nvl(max(receipt_asn_exists_code),'none')
4717: into l_asn_exists_code
4718: from rcv_parameters
4719: where organization_id = x_cascaded_table(n).to_organization_id;
4720:
4721: if (g_asn_debug = 'y') then
4722: asn_debug.put_line('asn code in rcv_parameters'|| l_asn_exists_code);

Line 4722: asn_debug.put_line('asn code in rcv_parameters'|| l_asn_exists_code);

4718: from rcv_parameters
4719: where organization_id = x_cascaded_table(n).to_organization_id;
4720:
4721: if (g_asn_debug = 'y') then
4722: asn_debug.put_line('asn code in rcv_parameters'|| l_asn_exists_code);
4723: end if;
4724: end if;
4725: else
4726: select nvl(max(receipt_asn_exists_code),'none')

Line 4728: from rcv_parameters

4724: end if;
4725: else
4726: select nvl(max(receipt_asn_exists_code),'none')
4727: into l_asn_exists_code
4728: from rcv_parameters
4729: where organization_id = x_cascaded_table(n).to_organization_id ;
4730:
4731: if (g_asn_debug = 'y') then
4732: asn_debug.put_line('asn code in rcv_parameters '|| l_asn_exists_code);

Line 4732: asn_debug.put_line('asn code in rcv_parameters '|| l_asn_exists_code);

4728: from rcv_parameters
4729: where organization_id = x_cascaded_table(n).to_organization_id ;
4730:
4731: if (g_asn_debug = 'y') then
4732: asn_debug.put_line('asn code in rcv_parameters '|| l_asn_exists_code);
4733: end if;
4734: end if;
4735: exception
4736: when others then