APPS.RCV_HEADERS_INTERFACE_SV dependencies on RCV_PARAMETERS

Line 387: FROM rcv_parameters

383: IF v_count > 0 THEN -- We need to generate a receipt_num
384: BEGIN
385: SELECT user_defined_receipt_num_code
386: INTO v_rcv_type
387: FROM rcv_parameters
388: WHERE organization_id = p_header_record.header_record.ship_to_organization_id;
389:
390: /* assuming that the ship_to_organization_id is populated at the header level of
391: rcv_headers_interface */

Line 1629: lock and release the rcv_parameters table only to get the receipt number

1625: p_header_record.error_record.error_message := rcv_error_pkg.get_last_message;
1626: END derive_ship_to_org_from_rti;
1627:
1628: /* ksareddy - 2506961 - need to support automatic receipt in parallel processing
1629: lock and release the rcv_parameters table only to get the receipt number
1630: */
1631: PROCEDURE genreceiptnum(
1632: p_header_record IN OUT NOCOPY rcv_shipment_header_sv.headerrectype
1633: ) IS

Line 1640: FROM rcv_parameters

1636: BEGIN
1637: BEGIN
1638: SELECT (next_receipt_num + 1)
1639: INTO p_header_record.header_record.receipt_num
1640: FROM rcv_parameters
1641: WHERE organization_id = p_header_record.header_record.ship_to_organization_id
1642: FOR UPDATE OF next_receipt_num;
1643:
1644: LOOP

Line 1652: UPDATE rcv_parameters

1648: WHERE receipt_num = p_header_record.header_record.receipt_num
1649: AND ship_to_org_id = p_header_record.header_record.ship_to_organization_id;
1650:
1651: IF l_count = 0 THEN
1652: UPDATE rcv_parameters
1653: SET next_receipt_num = p_header_record.header_record.receipt_num
1654: WHERE organization_id = p_header_record.header_record.ship_to_organization_id;
1655:
1656: EXIT;