APPS.POR_RCV_ORD_SV dependencies on RCV_PARAMETERS

Line 1456: FROM rcv_parameters

1452:
1453:
1454: SELECT to_char(next_receipt_num + 1)
1455: INTO X_receipt_num
1456: FROM rcv_parameters
1457: WHERE organization_id = X_to_org_id
1458: FOR UPDATE OF next_receipt_num;
1459:
1460: LOOP

Line 1469: update rcv_parameters

1465: WHERE receipt_num = X_receipt_num and
1466: ship_to_org_id = X_to_org_id;
1467:
1468: IF (X_count = 0) THEN
1469: update rcv_parameters
1470: set next_receipt_num = X_receipt_num
1471: where organization_id = X_to_org_id;
1472:
1473: EXIT;

Line 1598: FROM rcv_parameters

1594: when no_data_found then
1595: /* Get the Receipt Number */
1596: SELECT to_char(next_receipt_num + 1)
1597: INTO X_receipt_num
1598: FROM rcv_parameters
1599: WHERE organization_id = X_to_org_id
1600: FOR UPDATE OF next_receipt_num;
1601:
1602: LOOP

Line 1611: update rcv_parameters

1607: WHERE receipt_num = X_receipt_num and
1608: ship_to_org_id = X_to_org_id;
1609:
1610: IF (X_count = 0) THEN
1611: update rcv_parameters
1612: set next_receipt_num = X_receipt_num
1613: where organization_id = X_to_org_id;
1614:
1615: EXIT;