APPS.RCV_ROI_HEADER_COMMON dependencies on RCV_PARAMETERS

Line 430: FROM rcv_parameters

426: BEGIN
427: BEGIN
428: SELECT (next_receipt_num + 1)
429: INTO p_header_record.header_record.receipt_num
430: FROM rcv_parameters
431: WHERE organization_id = p_header_record.header_record.ship_to_organization_id
432: FOR UPDATE OF next_receipt_num;
433:
434: LOOP

Line 442: UPDATE rcv_parameters

438: WHERE receipt_num = p_header_record.header_record.receipt_num
439: AND ship_to_org_id = p_header_record.header_record.ship_to_organization_id;
440:
441: IF l_count = 0 THEN
442: UPDATE rcv_parameters
443: SET next_receipt_num = p_header_record.header_record.receipt_num
444: WHERE organization_id = p_header_record.header_record.ship_to_organization_id;
445:
446: EXIT;

Line 637: FROM rcv_parameters

633: IF v_count > 0 THEN -- We need to generate a receipt_num
634: BEGIN
635: SELECT user_defined_receipt_num_code
636: INTO v_rcv_type
637: FROM rcv_parameters
638: WHERE organization_id = p_header_record.header_record.ship_to_organization_id;
639:
640: /* assuming that the ship_to_organization_id is populated at the header level of
641: rcv_headers_interface */